Pie Chart - How to tell the chart not to pick up zero values

K

Khawar Ahmad Khan

Good day,

I have data organised as follows.

Col A Col B
(Header) ( % )
red 39%
blue 0%
white 24 %
Green 10%
Brown 0%

My problem is that when i create a pie chart, it picks up the 0 valuses as
well, and so the chart looks clustured, as i need to have the lables.

Please advise how to tell the chart to omit 0 values.

One option which i cannot use due to layout of the report is Hiding rows and
then plotting only visible cells.

Thanks

Best regards
 
K

Khawar

Good Day, Jon,

Thanks for the answer, but what i need is for the chart not to plot 0
values.
SO that there are not too many slices of the pie.
Any way of doing this without hiding rows with 0 values.

Best regards
Khawar
 
T

Tushar Mehta

No, I don't know of any way to avoid plotting zero values in a pie
chart without removing the data from the plotted range. You can do so
with a Advanced Filter, or do it manually, or build some other
formula/VBA based method, but you have to remove the zeros from the
plotted data range.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
J

Jon Peltier

Khawar -

Does the 0-width pie slice show up at all? If you explode the chart (a
good thing to do with pie charts, but I mean explode in a different
way), you see a line where the piece fits in, but you can change the
border for that pie wedge to None, and it disappears. You can also hide
the legend entry for the zero-width piece: click to select the legend,
click again to select the legend entry, then press Delete.

Here's another idea. Keep your original data unchanged, copy it, then
in another worksheet use paste link to set up another table, linked to
the first. Now apply your filter to this data, and create your chart
based on it. Now move the chart back to the original sheet.

- Jon
 

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 not showing 0% 2
Zero Values on a Pie Chart 2
Help to pick constant color to a value in a Pie Chart? 6
How can I reset the default pie chart label "Other" to "Equity"? 1
How to produce a chart based on number of cells not values in thecells 2
How to stop Pie Chart from using N/A# for values 2
how do I setup a pie chart that does not plot zero values ? 1
Too much white space to the right of a pie chart! How to eliminate 1

Top