Bob,

I am not very advanced using excel. I do not know what to do with your
information or where to put any of this. I do not know what myData is or
where any of your example in the chart. I do not know what =Offset or
=Sheet1!myData is or where to us it.

Bob Phillips" wrote:

Try using a dynamic range, say myData for

=OFFSET(Sheet1!$A$1,1,0,COUNTIF(Sheet1!$A:$A,"<"&T ODAY()),1)

and use

=Sheet1!myData

in the chart

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"TinleyParkILGal" wrote in
message ...
David and Andy,
Thanks for your posts. Whether I use #N/A or =NA() I get the value 0 on my
chart and it is plotted so it looks like the value has gone down to zero.
I
do not even want the line after November since we have not yet closed
12/2007.

Thanks

"David Biddulph" wrote:

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.