Chart Examples 2- Combo Charts

Please sign up for the course before starting the lesson.

Exercise 4

In the sheet ‘EBITDA’

  • We want to create a column chart that shows Revenue, Costs and the EBITDA %. We want all numbers to be positive i.e. although costs are negative we need to show them as positive on the chart
    • In G26 to V28 create formula to use in the chart (convert negative to positive numbers where applicable)
    • Create a chart where Revenue and Costs are Column Charts. These must be slightly overlapped
    • Include a line chart for the EBITDA %

Chart Exercise

To see the full course contents click here.

Back to: Advanced Excel Course > Charting In Excel