Home Charts and graphs
Post
Cancel

Charts and graphs

Charts and graphs provide a visual representation 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 data 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
  • Line graph showing temperature during the year

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

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

This post is licensed under CC BY 4.0 by the author.