They say a picture is worth a thousand words. Well, a chart in a worksheet can be worth a thousand numbers! Charts are used to summarise data, reflecting proportions, trends, and anomalies in your data far more effectively. Charts provide a visual way of seeing trends in the data in your worksheet. The charting feature in Excel is extremely flexible and powerful and allows you to create a wide range of charts from the worksheet data. But the beauty of the charting process is that it is delightfully easy and simple – once you know how.
I have chosen a simple column chart for this
This embeds the chart into your current worksheet. When you click onto the chart you will see thick grey box around it and the data used for the chart will have different colour boxes around it.
When you are clicked onto the chart you are able to change it’s size by grabbing hold of the grey box at any of the points highlighted in yellow
If you decide that you don’t want your chart on the same sheet as your data you can move it onto it’s own sheet.
For this next section I have moved the chart back to an embedded chart on the same sheet as the data as this makes it easier to see what I am doing
You may realise that the data would be better displayed the other way round. To change it
If you are going to use the chart in something else, like a PowerPoint presentation, you may want to show the data as well. To do this
This is a VERY brief overview of what you can do with charts. To learn more, why not come along to our Excel Intermediate training?
Here is an example of the same chart with additional formatting: