whemovement.blogg.se

Notice that all of the bars are above the x-axis (Case 1), which makes the data set up vastly simpler than the case when we have a mix of bars above and below the x-axis, or spanning the x-axis (see Case 2 below). The waterfall chart above is relatively easy to create in Google Sheets but does still require some data wrangling to set it up. It shows the number of staff in our department at the start of the year (left grey bar), the number of people added from other departments or as new hires (green bars), the number of people who left (red bars) and finally the balance which is the headcount at the end of the year (right grey bar). The following waterfall chart shows the headcount changes for a department, visually depicting the cumulative effect of the additions and deletions to the start value: They show the cumulative effect of a series of positive and/or negative values on an initial starting value. In this post, we’ll look at how to create a waterfall chart in Google Sheets.

This original post that follows was first published in late 2016, and I’m leaving it here for anyone who wants to look under the hood at how waterfall chart data is constructed and how to do that using apps script.

Now you simply highlight your data, click Insert > Chart and under the Chart type picker choose “waterfall”, as shown in the following image:

Update December 2017: Google has added Waterfall Charts to the native charts in the Chart Tool of Google Sheets, obviating the need for you to manually create your waterfall charts (or use apps script) per my original post.