Microsoft Office
Advanced charts exercise
Relatively easy
This Microsoft Office ADVANCED CHARTS exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl ADVANCED 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 picture charts
| 1) | Download the files needed to start this exercise: exercise-199.zip (and click here if you experience any problems unzipping this file after downloading it). |
| 2) | Create a simple column chart comparing car sales (for men only): |
A basic column chart
|
|
| 3) | Now amend this using the pictures on the Pictures sheet so that each data point has a different car stacked on it (you can decide which pictures represent which manufacturers!): |
An example of what the Mercedes data point might look like
|
|
| 4) | Save this as Iffy car pictures.xls, then close it down. |
Thank you for showing an interest in this Advanced Excel training course!
