Hi,
I have one method explained here,
http://www.andypope.info/charts/piezeros.htm
Cheers
Andy
MWS wrote:
Hello, I have a pie chart being created based on the value of a series of
rows. Since some of the cells within these rows are zero, I would like the
chart to populate based on the values that are greater than zero. I thought I
could address it by writing a formula to only show a value, if the result was
greater than zero, but to no avail.
The ultimate goal, to make the chart less-busy, is to only have the chart
populate on numbers greater then zero.
Can anyone help with this?
Any and All Help Will Be Appreciated - Thanks In Advance
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info