google spreadsheet pie chart

How do I have google spreadsheet pie chart show the sum of a group of cells as a percentage of a number?
i.e.
SUM(D34:D63) as a percentage of 50,600
LVL 1
swedishmotorsAsked:
Who is Participating?
 
TommySzalapskiConnect With a Mentor Commented:
So, do you want the blank so it looks like a guage? The one on the right was created by hitting 'Edit Chart' and changing the background of the unattained slice to white.
sampleHere's a link if you want to see.
https://spreadsheets.google.com/ccc?hl=en&hl=en&key=tfnqUOwrv8_4g6fvXoXwPFg&authkey=CNLsg8QG#gid=0 
0
 
TommySzalapskiCommented:
Just divide it and display as a percent
SUM(D34:D63)/50600
0
 
TommySzalapskiCommented:
The pie charts show as percentages by default. Are you wanting to show a blank slice?
0
 
TommySzalapskiCommented:
You could make another cell that equals =50600 - sum(all the other cells). Then add that cell to the pie chart and format it white.
0
 
swedishmotorsAuthor Commented:
I want to show total sales compared to sales goal. So the blank slice would be unattained sales.
Thank you for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.