charting question

[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

 

[Debra Dalgleish]

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.

 

[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.

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

 

[Debra Dalgleish]

Andy Pope has instructions here:

http://www.andypope.info/charts/piezeros.htm