| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Graphing error using Time as X axis. | Excel Worksheet Functions | |||
| How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
| Error when more than 60 items on X-axis | Charts and Charting in Excel | |||
| Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another | Charts and Charting in Excel | |||
| error bars when breaking the y-axis | Charts and Charting in Excel | |||
Threaded Mode
