Page 13 - Ones and Zeros 4 (Workbook)

Spreadsheets

Lesson 4

Pie Charts

1. Open the file ‘Pie Chart.xlsx’.

2. Select cells ‘B4:C9’.

3. Insert a pie chart based on these cells.

4. Change the title of the chart to ‘Stationery Costs’.
5. Change the pie style to ‘Style 6’.

6. Save the file and exit.

Stationery Costs

Pencils € 2.00
Notebooks € 15.00
Folders € 10.00
Pens € 6.00
Rubber € 0.50
Paperclips € 1.00
Total: € 34.50

11