Ignore zeros in chart data

[Steve00]

Is there any way for zeros to be ignored in chart data? My chart data is large, and at any given moment, a lot of the information is zeros. It would be nice if this data could not even show up in the chart as an excessive amount of zeros makes the chart less readable.

[greyscale]

I am having a similar problem. I can use ISBLANK when it is referencing only one other cell but some of my cells contain calculations for cells that will not be populated until next month so need to find a way to make the cell blank until the data it is referencing is populated. Any ideas?

[shg]

Steve, zeros are going to plot. You need to change them to #N/A, or hide the rows or columns in which they appear, to have them ignored.

greyscale, you're welcome to listen but not to ask questions else's thread, please.

[greyscale]

My apologes. I thought I was doing the right thing by not creating mulitple threads on the same topic.

[shg]

Start your own thread. Someone will help you.

[Steve00]

Excellent, thanks for the help!