If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Plotting NA() or #N/A data points
I have formulas that return the NA() or #N/A to cells I used for plotting on
charts. The last two cells do not show up on the chart, as intended. However, when I enter the data into the first of the two cells, it plots the last data point as zero. Ex: Jan-Oct has data, Nov and Dec default to the above. When Nov is filled in, the chart plots Nov and then adds Dec at zero value and returns #N/A in the axis. |
Thread Tools | |
Display Modes | |
|
|