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

  • Thread starter Thread starter Khawar Ahmad Khan
  • Start date Start date
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
 
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
 
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
 
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
 
Back
Top