SpreadsheetsCharts and graphs

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.

Part ofICTSoftware

Charts and graphs

Charts and graphs provide a 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 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
Image gallerySkip image gallerySlide1 of 4, Graph depicting temperature rise over a year, Line graph showing temperature during the year

Always use logical title and 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.

Bar graph of weekly income and outcome

Download a new version of Paul’s spreadsheet, which includes a chart.