Not sure? Do you have any idea because that system really did the
trick.

Thanks again


RagDyer wrote:
Why doesn't the #N/A work anymore?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Don Guillett" wrote in message
...

hide em

--
Don Guillett
SalesAid Software

"Kim" wrote in message
ups.com...
Hi all,

Is there a way to make missing data not be charted in an excel graph?

What I mean is... if my data set is as follows:

Jan 3
Feb 0
Mar 2
Apr 5
May No data
Jun No data
Jul 2
etc

How do I make it graph Jan to Apr and Jul but make the May and June
points not appear on the chart at all.

I used to be able to do this by putting #N/A for May and June but now
it actually graphs the points as #N/A rather than completely ommitting
them (which is what I want).

Any help would be much appreciated.

Thanks guys.

Kim