Charts and graphs
Spreadsheets can become very large and complex. Imagine keeping track of large projects or finances for an entire organisation.
Most people find large tables of data difficult to understand. It can become very hard to follow what is happening over a period of time and identify trends.
Charts and graphs provide a A picture, image or graph designed to show information. of data, which can often make it easier to understand.
To produce a chart, use the chart wizard or the gallery, then follow the onscreen instructions. There are several types of chart. Choose a chart based on the type of Values, typically letters or numbers. to be displayed. The charts you can choose from include:
- Line graph – to show a change over time
- Pie chart – to show the individual parts that make up a whole
- Bar chart – to compare things that aren't directly related
- Scatter graph – to look for a pattern or link between two sets of data
Image caption, Line graph showing temperature during the year
1 of 4
End of image gallery