Excel: make a chart from classroom practice data

Use a small, non-sensitive table to practise charts. Choose a chart that explains the learning point without displaying unnecessary personal information.

How to make a chart from classroom practice data

  1. Create a clear table with headings and a few sample values.
  1. Select the relevant headings and data.
  1. Choose Insert and a suitable chart, such as a column chart for comparing categories.
  1. Add a meaningful chart title and check the category and value labels.
  1. Compare the chart with the table, then check readability on the classroom screen.

Practical guidance

A chart is only meaningful when the selected data range and labels are correct. Check whether the first row contains headings and whether categories are treated as labels.

If the usual instructions do not resolve it

If the chart looks wrong, inspect blank cells, totals included in the selection and numbers stored as text before changing chart type.

Still need help?

Tell IT the chart type and selected range if labels or values are wrong. Use anonymised examples rather than a pupil tracking sheet.

Official product help

Still need help?

Send a request and include the steps you already tried.

Submit a ticket

Rate this article

How useful was this article?
Add a correction or suggestion (optional)
Do not include passwords, pupil details, or other private information.