update as you go along

Hi All

I have a line chart which is setup against an incomplete set of data.
Therefore the line drops to zero on the chart when it reaches the incomplete
bit see below

Example
Jan 10
Feb 20
Mar blank (line drops here)
Apr blank
May 0blank etc

What I want is the line to go as far as the data and stop at that point.
Then when I add the data it continues.

Any ideas/suggestions greatly appreciated

Rexmann

If the cells are really blank, a line chart will not draw those points. If
however you have a formula that looks like

=IF(A3=0,"",A3)

then the "" is plotted as a non-numeric text value, or zero. You can change
the formula to:

=IF(A3=0,NA(),A3)

which gives the #N/A error in the cell, but which a line or XY chart will
not plot.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"rexmann" <rexmann DeleteThis @discussions.microsoft.com> wrote in message
news:32740F01-918E-4667-A1A5-3456CE508C21@microsoft.com...
> Hi All
>
> I have a line chart which is setup against an incomplete set of data.
> Therefore the line drops to zero on the chart when it reaches the
> incomplete
> bit see below
>
> Example
> Jan 10
> Feb 20
> Mar blank (line drops here)
> Apr blank
> May 0blank etc
>
> What I want is the line to go as far as the data and stop at that point.
> Then when I add the data it continues.
>
> Any ideas/suggestions greatly appreciated
>
> Rexmann
>