Replace your 2008 entries with #N/A, or =NA()
--
David Biddulph

"TinleyParkILGal" wrote in
message ...
Professionals, I want to continue my 2007 charts through 2008 but without
values until the time arrives. My charts just show 0's for all of 2008
even
though I clicked on tools, options, chart, and plot emty cells as not
plotted
(leave gaps).

How can I do this?

Oct 2007 - 2
Nov 2007 - 5
Dec 2007 - 9
Jan 2008 - NOT PLOTTED
Feb 2008 - NOT PLOTTED

Thanks in advance.