Educator and Google Developer Expert. Helping you navigate the world of spreadsheets & AI.
This post looks at how to make a line graph in Google Sheets, an advanced one with comparison lines and annotations, so the viewer can absorb the maximum amount of insight from a single chart. For fun, I’ll also show you how to animate this line graph in Google Sheets. Want your own copy of … Continue reading How to Create an Annotated Line Graph in Google Sheets
Dashboard design is hard. You start with a blank canvas, or a blank Google Sheet in this case, and you have to somehow turn that into business insights, which will grow your bottom line, make your organization more efficient or help you understand your customers better. The blank screen stares back at you, waiting for … Continue reading Dashboard Design Checklist: From a Blank Google Sheet to Business Insights
It’s day two of a four day product launch. You’ve worked hard all year to create a fantastic product, test your sales systems and tell the world about this amazing offer. You know you’ve sold 100 products so far, but… …you don’t know whether your ads are effective, which affiliates are really killing it versus … Continue reading How to build a real-time sales dashboard for E-junkie using Google Sheets and Apps Script
Find the Google Sheet formula you’re after to solve your problem, with these examples. Click the link to read the post. Posts without active links are in the works and coming soon. Have a specific question? Drop me a line here. General questions > How do I zoom in or out in Google Sheets? Date … Continue reading Formula Examples
A tutorial on creating waterfall charts in Google Sheets, first using formulas and then, second, using Apps Script. The key trick is to create a stacked column chart and set the base column values to be transparent.