View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
MWS
 
Posts: n/a
Default 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