2

I'm using Google's monthly budget sheet to track my expenses.

I need to have a pie chart but I don't want it to be floating around in the sheet and be in a specific cell(s). So I thought a formula like Sparkline might be the answer. But is there such a formula? How can I achieve this?

2 Answers 2

1

For the moment at least, I think not. Try a pie chart using SPARKLINE and the error is:

Function SPARKLINE parameter 2 option charttype value is pie. It should be one of: 'line', 'column', 'winloss', 'bar'.

You might consider embedding an IMAGE instead but I doubt worth the bother ever were the image to be dynamic, that would be yet more bother.

1

You can add a pie chart inside a cell doing the following:

  1. Create a floating pie chart, move it to it's own sheet and publish it as a static image;
  2. Get the published URL and use it in an IMAGE function inside a cell

Then tweak the chart formatting as you like.
I recommend removing title and legends and adding the labels with a large font inside the slices, plus checking the option to maximize.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.