Hi,

If the cells contain formula use NA() instead of "".
As any text content will be treated as zero.

Cheers
Andy

TinleyParkILGal wrote:
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.