error value in axis
 

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($K 64,$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.

error value in axis
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Nirmal" wrote in message
...
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($K 64,$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.