Shows an opening and closing value overlaid on top of a total variance. 

This is useful for understanding how an initial value (for example, net income) is affected by a series of positive and negative values. This chart requires five columns in the datasheet.

Datasheet:

Column 1: String (text)
Column 2: Number
Column 3: Number
Column 4: Number
Column 5: Number

Column 1 contains the X-axis values: in the second row, add the keyword WaterfallChart and the columns you want to display; in this example: WaterfallChart(B,C,D,E).

Columns 2 and 3 contain the initial values: add the values you want Awesome Table to display on your chart.

Columns 4 and 5 contain the end values: add the values you want Awesome Table to display on your chart.

The keyword WaterfallChart is an option from the Candelstick Chart. A daily candlestick shows the market's open, high, low, and close price for the day.

This is why in our example our data points are: Start 1, Start 2, End 1 and End 2. Depending on your use case, if you want to show an opening and closing value overlaid on top of a total variance, add different values in each cell.

You can use this keyword in the Charts app.

Learn more about WaterfallChart.