Do not display Zero values
 

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

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