Module 1.2
Task 9 - Bar Charts


A.M.D.G.

We can present information in a spreadsheet in a graphical form. To help you through the process, choose the Chart Wizard tool, .


  • Open Module 1.2
  • Enter the following information on a new worksheet
 
A
B
C
D
E
1
  Manufacturer  No. Of Cars      
2
 Ford
13
      
3
 Vauxhall 
11
      
4
 BMW 
4
      
5
 Volkswagen 
16
      
6
 Mercedes 
7
      
  • Highlight the information from cell A1 to B6
  • Choose the chart wizard
  • Follow the steps to produce a bar/column chart
  • Save your work

Answer the following questions in your jotter.

1. Draw and name 5 different types of chart.

2. Draw three different ways of displaying a bar chart.

3. For the X and Y axes, which one is vertical and which one is horizontal?