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

update as you go along
 

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" wrote in message
...
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

update as you go along
 

Hi

Nice one, thank you

Worked a treat

Cheers Rexmann

"Jon Peltier" wrote:

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" wrote in message
...
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