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.
Now you simply highlight your data, click Insert > Chart and under the Chart type picker choose “waterfall”, as shown in the following image:
Continue reading How to create a waterfall chart in Google Sheets
This is a simple but effective technique for adding dynamic bands to your charts, which are useful to highlight specific parts of your chart.
For example, in this chart of website pageviews, I’ve added bands to show weekdays or weekends and make it easier to see the changing trends.
Continue reading Web traffic chart with dynamic banding in Google Sheets
Find your team: See the history of each of the 47 teams in the Premier League here.
In this post I’ll show you how to create a dynamic bump chart like the one above, using historical data for the English Premier League going back to 1992-93 when it was created.
Continue reading Excel tutorial: build a dynamic bump chart of the English Premier League
