Blog of Calc LLC

Waterfall charts were added to Google Sheets recently. It used to take many steps to make a waterfall chart in Google Sheets. If the method of creating waterfall chart taught by a tutorial is too hard, it is a sign that the tutorial is outdated. Waterfall chart is used to show how the value changes over time or over steps of a process. Suppose a factory tracks its inventory of a part by the amount of changes, waterfall chart can be used. In the following table, suppose the factory has 52 parts in January. The number of parts decreases by 3 in February, increases by 5 in March etc. 1. Select the data. Click Insert > Charts . Immediately a line chart is shown. However, this is not what we want. We need to change it to waterfall chart. On the Chart editor on the right, under Setup , scroll down and select Other . We pick waterfall chart (in red circle in the following figure). 2. Now You have a pretty waterfall chart. Blue columns show positive change, and red columns show negative ...

Waterfall chart is used to show cumulative effect of a series of positive and negative values, such as investment gain or loss. Suppose the following table shows our investment gain or loss in 10 days.  1. Click Insert > Charts > Other Charts > Waterfall 2. You will see how your investment changes each day. In this chart, blue bars means gain. Orange bars means loss. For each day, the value starts from the closing value of the previous day. That's how waterfall tracks the cumulative effect.