6. Making Charts in Spreadsheets

Sometimes the information you want to find in a spreadsheet can get lost among all the many numbers and calculations that the spreadsheet contains. A good way to highlight information in a spreadsheet to make it stand out is to create a chart.

Excel allows you to easily create bar charts, line charts, pie charts etc. to display as little or as much information as you want to show.

An Introduction to Making Charts!

An introduction to Making Charts! Click to Go Larger Screen

1. Download the file car sales.xls.
   
   
   
   
2. Add in what you think is the required formula to complete the spreadsheet.
3. Watch Movie 6 and using the methods shown, create separate charts for:
   1. Nissan cars.
   2. Peugeot cars.
4. Save your file.

More Practice with Charts

More practice with making Charts! Click to Go Larger Screen

1. Use the Car sales.xls file used in the last exercise.
2. Watch Movie 7 and create a single bar chart displaying details on the Vauxhall, Rover and Peugeot cars. - a number of separate charts will exists in the file so you will have to move them about to create space.
3. Save your file.

Different Charts

1. Open your file skating contest.xls (from the earlier exercise on replication) and
2. Create a fully labelled pie chart showing the overall average for each country
3. Save your file.

Mark off Exercise 7, 8, 9 in your Progress Grids

What you should now be able to do!

• Use Chart tools to make a range of different chart types. (Bar, Pie etc)

• Provide titles to your charts and place labels on the X and Y axis

• Provide fully labelled keys to your charts.

Continue to Section 7: Cell Protection