Charts and Graphs

A chart is a way of showing the numbers in a table as a picture. It is much easier to compare values and spot trends from a chart than from a column of figures. In a spreadsheet the chart is linked to the data: if a number in a cell changes, the chart changes too.

To create a chart, first select the range of cells you need (with the headings), and then choose the chart type in the “Insert” menu. The main types are these: a column chart is good for comparing values, a line graph shows changes over time, and a pie chart shows parts of a whole (percentages).

To make a chart clearer, give it a title, label the axes and, if necessary, add a legend and value labels. For example, a graph of a class’s average mark over four quarters shows growth or decline at a glance. Remember that too many colors and slices make a chart confusing.

Key takeaways

• A chart shows the numbers of a table visually and is linked to the data.
• A column chart compares values, a line graph shows change, a pie chart shows parts of a whole.
• A title, axis labels and a legend are added to a chart.
• Too many colors and slices make a chart hard to read.