Hiding 0 in pie charts

[Jenny]

I have database that has alot of zero's in it and I'm
trying to plot a pie chart but without the zero's visible
on the pie charts as you get lots of leader lines with
zero percentages.

Each cell, including the zero cells, are calculated
through an equation so they are not blank cells and excel
doesn't seem to be reading them as plain zero's.

Any help would be greatly appreciated..

 

[Richard Dobis]

Hi,

If numbers are in column B I usually create next column (e.g. C) with a
formula =if(b1 == 0,"",b1) in the row 1 (for other rows similar formula with
different number)
and I make the chart from column C not from column B.

try also #N/A instead "" i.e. =if(b1 == 0,#N/A,b1) or other error symbols

does it help?

rd

 

[Frank Kabel]

Hi
see
http://andypope.info/charts/piezeros.htm

 

[Jon Peltier]

Jenny -

If the labels are concatenated text, this won't help, but if all you're
showing is values or percentages, you can use a custom number format.
Select the labels, press CTRL+1 to format them, and click on the Number
tab. Select Custom from the list, and enter something like this:

0;;;@
0%;;;@
0.0%;;;@

The four elements of the list by default are for positive, negative, and
zero values, and for text. 0, 0%, and 0.0% are sample numeric formats,
and @ means show the text. If you leave out a format for one element,
that element will not show. Given that Pie charts don't need negatives
or zeros, I've left both off in these examples.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Jenny]

Thanks, nearly..

When I tried it originally it worked and then when I came
back to try it again it didn't. I haven't changed
anything so I have no idea what has happen. Hopefully
you might?