Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1165
  • Last Modified:

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
0
swedishmotors
Asked:
swedishmotors
  • 4
1 Solution
 
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
 
TommySzalapskiCommented:
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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now