Not Displaying Zero Values

M

MWS

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 charts: want to avoid zero values 1
Drop down list control value in vba 2
Do not display Value label if value = zero 1
How to display zero value in blank fields of Cross Tab query 0
Use TODAY() function as the criteria in a SUMIF formula 1
Earned value (BCWP) showing as zero in chart 0
Hide zero entries from legend 1
How do I set up a chart to only chart values greater than 0 2

Top