What’s the message? Using data to give clarity
You have data in Excel that you could use to make many different points. Which are important? Let’s take as an example the turnover figures of a nationally operating company over a number of years.
Turnover in million EUR
Choose the most suitable diagram according to the point you’d like to make:
You’d like to show that turnover has increased 20% since 2010. Use a column chart of turnover against time and highlight the 20%.
You’re not so concerned with the exact figures as such, but you want to show that the company’s service centres are too concentrated in the south of the country. You can show this clearly using a map of the service centre locations.
You can get across the fact that two thirds of turnover is made in the south and west using a pie chart. Highlight both regions in colour.
If you want to show retrospectively that EUR 10 million in new business was made due to a key new customer in the west of the country, it could be most effective to show a picture of their premises.