1

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?

migrated from superuser.com Jul 30 '17 at 9:12

This question came from our site for computer enthusiasts and power users.

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

Them 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, privacy policy and cookie policy

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