Thread: How do you skip graphing some data?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default How do you skip graphing some data?

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



Reply With QuoteReply With Quote