Do not display Zero values

[Stan Altshuller]

Hi All

I have two columns, in the first i have numbers, next labels.
I need to make a pie chart that ignores all numbers (and respective labels)
that are zero.

Is there a way to do that?

Thanks in advance!

Stan

[Andy Pope]

Hi Stan,

Check the example and the Alternative link example.
http://www.andypope.info/charts/piezeros.htm

Cheers
Andy

Stan Altshuller wrote:
> Hi All
>
> I have two columns, in the first i have numbers, next labels.
> I need to make a pie chart that ignores all numbers (and respective labels)
> that are zero.
>
> Is there a way to do that?
>
> Thanks in advance!
>
> Stan
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info