Spreadsheets are used to store information and data. Once we have our information in a spreadsheet we can run powerful calculations, make graphs and charts and analyse patterns.
Charts and graphs provide a visual representationA picture, image or graph designed to show information. of data, which can often be easier to understand.
To make a chart, use the chart wizard or the gallery, then follow the onscreen instructions.
There are several types of charts. Choose a chart based on the type of dataValues, typically letters or numbers. to be displayed. The charts you can choose from include:
line graph – to show a change over time
pie chart – show the individual parts that make up a whole
bar chart – compare things that aren’t directly related
scatter graph – look for a pattern or link between two sets of data
Scatter graph showing ice cream sales against temperature
1 of 4
Slide1 of 4, Graph depicting temperature rise over a year, Line graph showing temperature during the year
End of image gallery
Always use logical title and axis labelsA label for a graph's horizontal or vertical axis that explains what the value relates to. so that your chart makes sense to others.
Paul could use a bar chart to quickly see if his incomings are greater than his outgoings.