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