Waterfall charts have initial and final value columns with floating columns in between, demonstrating negative and positive values with an impact on the initial and final values. In this way, waterfall charts are often used to show changes in profit between two time periods.
Waterfall charts include columns representing Positive Change and Negative Change.
To set column colors:
- Select your chart.
- Right-click to open the Chart Properties panel.
- Select the series from the drop-down menu under Series.
- Click the color swatches for Positive Color and Negative Color to set the colors individually.
- Select Total in the Series drop-down, and work just with the color for the total column.
Customize Waterfall Charts
You can change the orientation of the chart from vertical to horizontal. Choose either the vertical or horizontal icon under the General section in the Chart Properties panel.
Many of the other settings applicable to waterfall charts are the same as other types of column or bar charts. This includes labels, axis settings, chart size, plot area fill and legend options.
The chart size settings and fills are at the very top of the Chart Properties panel. Controls for the legend are found at the bottom of the panel, including the ability to show or hide the legend and to position the legend.
For additional information on chart customization, see the following articles:
Label value formatting for the chart is controlled from the data table. Please see Chart Label Value Formats for more information.
For more information on display options, see Axis and Series Display for Charts