error value in axis

[Guest]

I am trying to plot a chart for varying number of weeks. I use the formula
=IF(J63=0,NA(),J63-1) to stop with zero th week starting from the week I
define. I also use similar formulas for getting data i.e
=IF(ISERROR(VLOOKUP($K64,$A:$D,2)),NA(),VLOOKUP($K64,$A:$D,2)), where k64
indicates week number.

The problem now is the data line stops with 'NA' values as expected, but the
axis which contains week number shows 'NA' after the week numbers. Any ways
to fix this.

 

[Jon Peltier]

Now you need dynamic names (aka named ranges) that know where the numerical
data ends, and use these names as source data for your series:

http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon