Educator and Google Developer Expert. Helping you navigate the world of spreadsheets & AI.
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.
These charts show the performance of all the teams that have competed in the Premier League since its inception, the 1992-93 season (Leicester highlighted blue as the current 2015/16 champions): AFC Bournemouth Arsenal Aston Villa See the dynamic version and read about how I created this chart in Excel in this in-depth tutorial I wrote. … Continue reading A history of the Premier League in 47 Excel charts
The Datatype font turns text values into miniature charts. It’s like a magic trick that turns data values in your Sheet into sparklines, but without the complexity of the sparkline formula. It’s been really fun to explore in Google Sheets. How to add the Datatype font in Google Sheets From the font selector in the … Continue reading Explorations with the Datatype Font in Google Sheets
With the new Sheets Canvas feature, we can build professional-looking interactive dashboards directly in our Google Sheets, using nothing more than natural language prompts. It’s a huge upgrade from how we used to build dashboards in Sheets. Previously, we clumped together charts and used formatting tricks such as borders and background cell colors to try … Continue reading Build Dashboards and Kanban Boards with the Google Sheets Canvas Tool