Waterfall Chart is not appearing as desired

Hi everyone!

I am trying to make a waterfall chart but I am not sure how to make it look like my desired outcome.

Here is the Excel I am using, the data for the waterfall chart is on the "Q3" sheet.

BCD1001 Tutorial 8.xlsx


This is what it looks like now:

Screenshot 2024-01-02 100256.png

But I want to make it look like:

waterfall-chart.png

I want the waterfall chart to show change in net profit from 2011 to 2012 contributed by the change in each line item in the income statement. Can anyone help me change it?

Set as Total for Gross Profit and Net Profit.

Thank You very much! Exactly what I needed