Chart blanks

  • Thread starter Thread starter Max Scott
  • Start date Start date
M

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
 
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
 
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
 
Back
Top