Radial Bar Charts in Google Sheets

In this post, I’m going to show you how to create radial bar charts in Google Sheets. They look great and grab your attention, which is important in this era of information overload. But they should be used sparingly because they’re harder to read than a regular bar chart (because it’s harder to compare the … Continue reading Radial Bar Charts in Google Sheets

Multi-colored line charts in Google Sheets

In this article, you’ll see how to create a multi-colored line chart in Google Sheets, for example when the line is increasing it’s colored green, when it’s decreasing it’s colored red, as shown in this image: Colors are a powerful way of adding context to your charts, to bring attention to certain trends and add … Continue reading Multi-colored line charts in Google Sheets

How can I format individual data points in Google Sheets charts?

In this article, you’ll see how to annotate your Google charts, by adding formatting and data labels to specific data points only. Formatting specific datapoints or adding data labels are a very powerful way of adding context to your charts, to bring attention to certain data points and add additional explanation. How to add formatting … Continue reading How can I format individual data points in Google Sheets charts?

Funnel charts in Google Sheets using the chart tool, formulas and Apps Script

How to build funnel charts in Google Sheets using tricks with the chart builder tool, sparklines, the REPT formula and finally, and best of all, how to build a tool to create these charts automatically using Apps Script.

Recreating Tufte’s famous weather chart with Google Sheets and Charts API

Recreating Tufte’s famous weather chart using Google Sheets data and the Google Charts API. This chart encapsulates the historic min/max range, the normal range, the 2015 temperature and any occasions when the 2015 temperature was a record min or max.