Not Displaying Zero Values
 

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

Not Displaying Zero Values
 

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