Create waterfall charts in Google Sheets (formulas and apps script versions)
Update December 2017:
Google have recently 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.
Now you simply highlight your data, click Insert - Chart and under the Chart type picker choose “waterfall”.
This tutorial from 2016 shows how to create waterfall charts in Google Sheets, first using formulas and then, second, using Apps Script. The key trick is to create a stacked column chart and set the base column values to be transparent.
Link to blog post:
http://www.benlcollins.com/spreadshee...
Link to GitHub page with code for embedded waterfall chart:
https://github.com/benlcollins/apps_s...
Link to my beginner guide to Apps Script:
http://www.benlcollins.com/spreadshee...
Watch video Create waterfall charts in Google Sheets (formulas and apps script versions) online, duration hours minute second in high quality that is uploaded to the channel Ben Collins 26 November 2016. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 38,924 times and liked it 132 visitors.
