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