Educator and Google Developer Expert. Helping you navigate the world of spreadsheets & AI.
Welcome to issue 20 of the Sheets Insiders membership program. You can see the full archives here. Earlier today we had a great live workshop on techniques to create better looking charts in Google Sheets. We covered: Workshop Replay Workshop Google Sheets Template Download the Better Charts Template Click on “Use Template” in the top … Continue reading Sheets Insiders 20: Better Charts in Google Sheets Workshop Replay
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
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?