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 SPARKPIE, in honor of the eponymous SPARKLINE function.
In 1956, a 13-year old Bobby Fischer announced his chess genius to the world, winning one of the finest games in chess history. In fact, Chess Review called it “The Game of the Century“.
In a game full of beauty and surprise, Fischer overcame his much older, more experienced opponent, the International Master Donald Byrne.
In this video and blog post, we create a single formula in Google Sheets that plays through this game!
Whether you’re just starting out with Google Sheets or are a seasoned pro, sooner or later one of your formulas will give you a formula parse error message rather than the result you want.
It can be frustrating, especially if it’s a longer formula where the formula parse error may not be obvious.
In this post, I’ll explain what a Google Sheets formula parse error is, how to identify what’s causing the problem, and how to fix it.
The SEQUENCE function is a useful function in Google Sheets. It’s a powerful way to generate numbered lists.
SEQUENCE Function Syntax
=SEQUENCE(rows, columns, start, step)
As arguments for the SEQUENCE function, you specify 1) the number of rows, 2) the number of columns, 3) a start value, and 4) a step size.
Arguments 2, 3, and 4 are optional. However, if you want to set them you need to include the previous ones (e.g. if you want to set a step size in argument 4, then you need to set 1, 2, and 3 as well).
Keep this order in mind as you look through the examples below and you’ll soon understand how the function works.