update as you go along

[rexmann]

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

 

[Jon Peltier]

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

 

[rexmann]

Hi

Nice one, thank you

Worked a treat

Cheers Rexmann