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...

• #science_technology
• #google_sheets
• #waterfall_charts
• #data_visualization
• #data_viz
• #spreadsheets