| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XY Charts - not plotting zero or #N/A Points | Charts and Charting in Excel | |||
| Plotting data points on 2 axis | Charts and Charting in Excel | |||
| Not plotting data points in a line chart | Charts and Charting in Excel | |||
| Excel Incorrectly Plotting Non-sequential Data Points | New Users to Excel | |||
| Plotting two data points as one | Excel Discussion (Misc queries) | |||
Linear Mode
