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 data sheet.
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 of 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.