# How to Create a Stacked Waterfall Chart in Excel – 3 Steps

The following dataset contains records of price changes of product “X” from 2015 to 2021. A stacked waterfall chart will show the changes over the years.

## Step 1 – Modifying Dataset to Create a Stacked Waterfall Chart in Excel

• Modify the dataset by adding values. Add an extra column: Start Line before the Base Value column.

• Use the following formula in the second cell of the Start Line column corresponding to 2016.
`=E4`

It returns the value of the increment from E4 to C5.

• Use the following formula in C6.
`=C5+D5+E5`

C5, D5, and E5 are the values of the Start Line, Base Value, and Increment columns of the previous row.

• Press ENTER and drag down the Fill Handle tool.

It copies the formula from C6 to C9.

`=C8+D8+E8`

C8, D8, and E8 are the values of the Start Line, Base Value, and Increment columns in the previous row.

• Add the values of the Base Value and Increment columns by using the following formula in E10.
`=SUM(D4:E9)`

The SUM function adds values in D4:E9.

• Press ENTER

It returns the total value of \$55,680.00 as the 2021 End price.

## Step 2 – Inserting a Stacked Column Chart to Create a Stacked Waterfall Chart

This is the dataset:

• Select the data range and go to Insert Tab >> Charts Group >> Insert Column or Bar Chart Dropdown >> 2-D Stacked Column.

The following chart is showcased:

## Step 3 – Modifying a Stacked Waterfall Chart

• To hide the Start Line series: select it and Right-Click.

• Click Fill and select No Fill.

The Start Line series is invisible.

When the color of the 2015 Starting Price column and the 2021 End Price column are similar to the Increment series, changing the color is necessary.

• Double-click the 2015 Starting Price column and Right-click.

• Click Fill and select a color (Red here).

The color of the 2015 Starting Price column changed.

• Change the color of the 2021 End Price column.

Widen the columns:

• Select any series in the chart and Right-click.
• Choose Format Data Series.

In Format Data Series:

• Select Series and lower the Gap Width value.

The Gap Width changed from 150% to 26%.

This will be the final chart:

Change the chart title to “Price Changes of product “X” from 2015 to 2021”.

## Practice Section

Practice using the table below:

## Related Articles

<< Go Back to Waterfall Chart in Excel | Excel Charts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Tanjima Hossain

TANJIMA HOSSAIN is a marine engineer who enjoys working with Excel and VBA programming. For her, programming is a handy, time-saving tool for managing data, files, and online tasks. She's skilled in Rhino3D, Maxsurf C++, MS Office, AutoCAD, and Excel & VBA, going beyond the basics. She holds a B.Sc. in Naval Architecture & Marine Engineering from BUET and is now a content developer. In this role, she creates tech-focused content centred around Excel and VBA. Apart from... Read Full Bio