Formula Pie Charts in Google Sheets

In this post, we’ll look at how to create miniature formula pie charts in Google Sheets. Formula pie charts are miniature pie charts that exist inside a single cell of a Google Sheet. We’ll even create a Named Function to make it super easy to use these miniature pie charts. We’ll name this new function … Continue reading Formula Pie Charts in Google Sheets

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.