Page 14 - Ones and Zeros 4 (Workbook)
P. 14
4 Spreadsheets
4
Lesson 5
Changing the Chart Type
1. Open the file ‘Pie Chart.xlsx’.
2. Change the chart type to a ‘bar’ chart.
3. Choose the ‘clustered bar chart’ type.
Stationery Costs
Pencils € 2.00
Notebooks € 15.00
Folders € 10.00
Pens € 6.00
Rubber € 0.50
Paperclips € 1.00
Total: € 34.50
4. Now, add ‘data labels’ to the bars of the chart.
Stationery Costs
Pencils € 2.00
Notebooks € 15.00
Folders € 10.00
Pens € 6.00
Rubber € 0.50
Paperclips € 1.00
Total: € 34.50
5. Save the file and exit.
12
