how do I setup a pie chart that does not plot zero values ?

D

Dimmy

I have a set of rows and columns were column 1 is the description and column
2 is the value (in percentage). I have setup a pie chart linked to these data
to display these categories and their respective percentage. Howver, when a
cell from column 2 has a zero value, I would like this whole row (description
+ zero percentage), not to be displayed on the pie chart as it is
meaningless. Can you please suggest to me how to do it ?

Thanks,

Dimmy.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pie Chart 4
Excel 2010 Data Labels options not saving 0
Pie Chart that Shows Values instead of Percentages 1
Chart won't show zero percent 1
Pie Chart and Zero Value Labels 1
Zero Values on a Pie Chart 2
Pie Chart - Columns 1
Pie chart break down 0

Top