charting question

  • Thread starter Thread starter David
  • Start date Start date
D

David

Hello All


I am charting cells formated as percentages in a pie graph using Excel
2003. Is there a way to not show the 0% values in the pie chart?


Thank you
David
 
If you want to remove the values:
Select the chart
Choose Chart>Chart Options
On the Data Labels tab, remove the check mark from Values
Click OK

If you want to remove the % sign,
Add a column to the data, and calculate the percentage for each item,
then multiply by 100. For example:
=D2/SUM($D$2:$D$10)*100
Then, use that column as the data for the pie chart, and format the
numbers in the data labels with as many decimals as required.
 
Debra said:
If you want to remove the values:
Select the chart
Choose Chart>Chart Options
On the Data Labels tab, remove the check mark from Values
Click OK

If you want to remove the % sign,
Add a column to the data, and calculate the percentage for each item,
then multiply by 100. For example:
=D2/SUM($D$2:$D$10)*100
Then, use that column as the data for the pie chart, and format the
numbers in the data labels with as many decimals as required.
Click to expand...
Hi Debra

Thank you for replying. I want to keep both values and % sign. I was
just wondering if I could eliminate a value that is less than 1% from
being charted.


Thank you,
David
 
Back
Top