Excel

Hi Yunyun,

Thank you for your question, welcome to the forum, in answer to your post;

As I'm sure you know Excel does not have a waterfall chart option, however there are proprietry programs that can be purchased as a bolt on.

If however you want to do a little bit of "cheating" you can follow these steps, I apologise for the data and cell references just being referred to and expecting you to have the same: so you might have to create a little table of your own first to follow the steps, and data as long as it is relevant will do;

So follow these steps to create this type of chart:

1. Use the Chart Wizard to create a stacked bar chart from a range eg A2:C13.
2. In Step 2 of the Chart Wizard, select the Columns option. Notice that Excel incorrectly uses the first two columns as the Category axis labels.
3. Also in Step 2 of the Chart Wizard, click the Series tab and add a new data series. Then set the chart