About this lesson
Waterfall charts help break "net change" into increases and decreases, giving more information about the business cycle.
Adding Waterfall charts to break down net change.
When to use
These charts are useful in breaking down net change values to show both increases and decreases. They are very useful for showing things like stock changes or membership changes.
- Ensure your data is arranged in a tall and narrow table, not a pivoted setup
- Select your Data --> Insert --> Waterfall or Stock Charts --> Waterfall chart
- Locate data points that represents a total --> Left click it (twice) then right click --> Set as Total
Excel 2013 and earlier
Adding the Waterfall Template to your system
- Open your target workbook
- Open the Waterfall Template.xlsx file
- In the Waterfall Template file, right click the Waterfall Chart tab --> Move or Copy
- Check the box to make a copy, then select your target workbook from the list
- Close the Waterfall Template file without saving changes
Updating the Waterfall chart for your data
- Update the chart title (cell B10) to something that makes sense for your data
- Update the legend names (cells B14:B16) to something that makes sense for your data
- Update cells B26 and B19 to the names you want on the start and end columns
- Link C26 to your opening value
- Insert rows between rows 27 and 28 for your data points
- Copy the formulas from D27:H27 down to cover the inserted rows
- For each row, link column B to the description you’d like, and column C to the change value
Deploying the chart
- Copy the desired chart to your dashboard
- Paste it on your dashboard
Hints & tips
- For the manual Waterfall chart, increases use positive values, decreases use negative values
- On the manual Waterfall chart, compare the ending value generated by the chart against your original data set. (The chart calculates this value automatically, and it should balance to your data)
Lesson notes are only available for subscribers.