How to Create a Waterfall Chart in Google Sheets
In Google Sheets, after adding your data to your spreadsheet, select your data by dragging your cursor through it. Select Insert > Chart from the menu. In the Chart Editor sidebar under the Setup tab, select the “Chart Type” drop-down box. Then, select the waterfall chart under “Other.”
If you want to show how positive or negative values affect a starting value, you can create a waterfall chart in Google Sheets. You can then view the data sequentially or stacked for the most effective visual. We’ll show you how in this guide.
Here, we’ll look at two examples of a waterfall chart in Google Sheets. You’ll see one using just two columns of data sequentially and the other using three columns with the data stacked.
What Is a Waterfall Chart?
Waterfall charts show how adding or subtracting values affect a starting point over time. For example, you might chart a checking or savings account with money coming in or going out. Or, you might track inventory for a product with shipments added and sales subtracted.
By displaying these values on a waterfall chart, you…
Read Full Article Source