L-Zone Spreadsheets 3

Spreadsheets and Modelling

Barcharts

Learning Objectives:

  • to learn how to produce barcharts from spreadsheet data
  • to learn simple formatting of charts
 

Task 1: A quick barchart

  1. Load Excel and produce a spreadsheet with this data.

 

  1. Highlight the table including the headings and then click the Chart Wizard icon..

  1. Choose the column barchart and then click Next >.

  1. At each screen, provide the information asked for and then click Next > to move on.  Type in titles and labels when asked.
  2. When you get to this screen....

....choose As new sheet and type in the name 'Cars Chart'.  This will put the chart on a new worksheet, by itself.

 

 

 

 

 

 

 

 

 

 

You can switch between the new chart and the original table using the 'tabs' at the bottom of each worksheet.

  1. Save your spreadsheet and printout a copy of the chart for your folder.  Write your name on the printout.

Task 2: Why stop at a barchart....any other charts?

 

  1. At this screen, you can choose a large number of different charts.  Some are useful and some not.  Produce some other types of charts.
  2. Save the spreadsheet with the new charts and then printout each new chart.

Task 3: Can we change the format of the charts?

  1. If you click on parts of the chart such as titles and labels and then click Format or right click and then select Format (chart item), you can change fonts, sizes, colours and other things.
  2. If you select the 'bars', for instance, on a barchart, you will be able to use colours, patterns and texture.  Check them out!
  3. Save the spreadsheet with the new improved charts using a different name and then printout each new improved chart.

 

 

L-Zone

Most recent revision 28 March 2007