Microsoft Office
Advanced charts exercise
Average difficulty
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: McDonalds combination chart
| 1) | Download the files needed to start this exercise: exercise-197.zip (and click here if you experience any problems unzipping this file after downloading it). |
| 2) | Create a basic column chart comparing burger sales across regions, but missing out the AVERAGE figures: |
| 3) | Swap the axes round, so that you are comparing areas against McDonalds products: |
The total columns distort the chart
|
|
| 4) | Chart the Total column as a line chart against a separate axis to make your chart easier to read: |
The totals show up as the dashed red line
|
|
| 5) | Save this file as Dodgy data 2.xls, and close it down. |
Thank you for showing an interest in this Advanced Excel training course!
