Select Insert > Waterfall or Stock chart > Waterfall from the Insert menu. You may also make a waterfall chart using the All Charts item in Recommended Charts.
The data for the waterfall chart is displayed in the pivot table starting in cell M3. The slicer is linked to this pivot table, as well as slicers for the Item field in the pivot table's Filters section.
Waterfall Charts are used to show how a starting value (such as a beginning monthly balance in a checking account) becomes a final value (such as the account balance at the end of the month) through a sequence of intermediate additions (deposits, transfers in) and subtractions.
A waterfall chart can be used for analysis, particularly to understand or explain the progressive transition in the quantitative value of an object that is subject to increment or decrement. A waterfall or cascade chart is frequently used to demonstrate variations in revenue or profit over time.
You can compare numerous things against multiple criteria using the Radar Chart, commonly known as a spider or star chart. It might be used to compare items in several different areas or to see how temperatures change in numerous locations over the course of a year.
Share a personalized message with your friends.