avoiding plotting zero values on graphs
 

How do I when plotting points of a graph avoid plotting the zero values.

During the start of a new period, there will be several zero values, how can
i aviod excel from plotting these zero values

avoiding plotting zero values on graphs
 

"Lee" wrote in message

How do I when plotting points of a graph avoid plotting the zero
values.

During the start of a new period, there will be several zero values,
how can i aviod excel from plotting these zero values


Hi Lee,

I suggest that, unless the result you want *is* actually zero, you
don't have a formula that returns that value.

Better, IMO at least, to return Not Applicable (#N/A) if the result is
not (yet) applicable.

For example:

=IF(DataMonthCurrentMonth,NA(),Result)

This has the advantage that any results that are not able to be
applied remain unplotted on a chart.

Hope that helps,

Alan.

--
The views expressed are my own, and not those of my employer or anyone
else associated with me.

My current valid email address is:



This is valid as is. It is not munged, or altered at all.

It will be valid for AT LEAST one month from the date of this post.

If you are trying to contact me after that time,
it MAY still be valid, but may also have been
deactivated due to spam. If so, and you want
to contact me by email, try searching for a
more recent post by me to find my current
email address