Microsoft Office
Charts exercise
Relatively easy

This Microsoft Office CHARTS exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl INTRODUCTION TO EXCEL course only, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Exercise: Car sales - creating basic charts

1) Download the files needed to start this exercise: exercise-193.zip (and click here if you experience any problems unzipping this file after downloading it).
2) Create a 3-dimensional column chart comparing sales data for men and women, but omitting BMWs (if only you could do this in life too ...):
Exercise screen-shot 278 See below for a summary of the main formatting changes
3) The main changes to make to the default chart created are:
  • A chart title and category and value axis label have been added
  • The gridlines and background colour have been removed
  • The legend has been moved
  • The category axis label Manufacturer has been rotated slightly
4) Save this as Car Sales without BMWs, and close it down.

Thank you for showing an interest in this Introduction to Excel training course!

All content copyright Wise Owl Business Solutions Ltd 2008.  All rights reserved..