<div>
Just divide it and display as a percent<br />
SUM(D34:D63)/50600 
</div>


Just divide it and display as a percent
SUM(D34:D63)/50600

<div>
The pie charts show as percentages by default. Are you wanting to show a blank slice?
</div>


The pie charts show as percentages by default. Are you wanting to show a blank slice?

<div>
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.
</div>


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.

<div>
I want to show total sales compared to sales goal. So the blank slice would be unattained sales. <br />
Thank you for your help. 
</div>


I want to show total sales compared to sales goal. So the blank slice would be unattained sales.
Thank you for your help.

gdocs.PNG

<div>
<div class="content wysiwyg-content">
How do I have google spreadsheet pie chart show the sum of a group of cells as a percentage of a number?<br />
i.e.<br />
SUM(D34:D63) as a percentage of 50,600
</div>
</div>


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

google spreadsheet pie chart

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.