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
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
"Lee" <[email protected]> wrote in message
news:[email protected]
> 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(DataMonth>CurrentMonth,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:
[email protected]
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks