Stop the line when 0 is reached

[Guest]

I have a chart ranging from Jan to Dec I have values up till Oct, I want the
line to stop there, is there any way I can stop the line from appearing after
the last value

 

[Andy Pope]

Hi,

If the cells for Nov and Dec are really empty the line should stop.
If the cells contain formula then make use of NA() instead of ""

Cheers
Andy

 

[Guest]

Thanks Andy

Not sure where I should use the NA(),

here is the formula for the field

=IF(VLOOKUP($W$8,$A$31:$Q$291,O17,FALSE) =
0,NA(),VLOOKUP($W$8,$A$31:$Q$291,O17,FALSE))

Is that where I woudl use the NA() statement? It still retains the 0

Nigel

 

[Andy Pope]

That looks like the sort of thing.

Are you saying the line still drops to zero when the data is zero?