That Blue Square Thing

ECDL Excel

< back to the Spreadsheet menu...

Drawing Basic Charts

This deals with drawing bar charts (or coluns charts as Excel likes to call them), pie charts and line charts.

There are a couple of tricky things you need to be able to do, so follow the instructions carefully and work through the guides in order.

First, download the spreadsheet.

Excel file iconBiscuits Spreadsheet

Now follow the instructions... (updated for 2026)

PDF file iconBar Charts

PDF file iconPie Charts

Producing Line Charts

To produce line charts, use a different spreadsheet.

Excel file iconClimate Data Spreadsheet

Follow the instructions... (not updated so use your common sense)

PDF file iconLine Charts

More Spreadsheets for Charts

You can work with the data in this spreadsheet to draw more charts.

Excel file iconFishing Competition Spreadsheet

More Complex Charts

There are also guides on how to produce more complex charts such as climate charts and flood hydrographs. These aren't needed for the ECDL exam, but if you're good at using them it can only help.