G
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.
=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.