Chart blanks

[Max Scott]

Hi

I have a chart with 2 lines on it. One has 52 data points and is last year's
data. This year's line has, say, only 20 points. I would like this years
line just to stop after the 20 points but it continues showing 0 for the
rest of year. How do I get it just to not plot!

Thanks

Max

 

[Pete_UK]

If you can arrange to have errors in those cells then they will not
plot. You can do this by:

=NA()

for those cells that do not have any data yet, then overwrite them
when the data becomes available.

Hope this helps.

Pete

 

[Max Scott]

Perfect. Thanks

If you can arrange to have errors in those cells then they will not
plot. You can do this by:

=NA()

for those cells that do not have any data yet, then overwrite them
when the data becomes available.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome, Max - thanks for feeding back.

Pete