software

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

Hi,

I have one method explained here,
www.andypope.info/charts/piezeros.htm

Cheers
Andy

MWS wrote:
gt; Hello, I have a pie chart being created based on the value of a series of
gt; rows. Since some of the cells within these rows are zero, I would like the
gt; chart to populate based on the values that are greater than zero. I thought I
gt; could address it by writing a formula to only show a value, if the result was
gt; greater than zero, but to no avail.
gt;
gt; The ultimate goal, to make the chart less-busy, is to only have the chart
gt; populate on numbers greater then zero.
gt;
gt; Can anyone help with this?
gt;
gt; Any and All Help Will Be Appreciated - Thanks In Advance

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info