Omitting zero values on pie charts

[eur6jto]

Hi,

How to make excel omitt zero values instead of displaying 2 or mor
zero values in one place on pie chart when some of values in sourc
data range (dynamic) will become zero?

(Sorry if this question was here already - I couldn`t find answer usin
Search button :-/ )

Jaca

 

[Frank Kabel]

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

 

[eur6jto]

Thanks!

That was exactly what I was looking for.

Jaca