Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to Ignore #N/As for X-Axis TickMarks?
I have a time-series line chart I am plotting at changing frequencies depending upon user input. Under the Axes option, I am using 'Category', so as to reflect the actual dates. At the highest frequency (daily), I have a date for every datapoint, so I have no problem here. However, at any other lower frequency, while the chart correctly ignores interim datapoints whose values are #N/A (rather than plotting zero), for some reason the x-axis does NOT ignore these and therefore I cannot accurately display the dates corresponding to the valid datapoints at these other frequencies, returning mostly #N/A tickmarks along the x-axis. Does anyone happen to know of a workaround solution to this? Any advice would be gratefully received. -Pete -- Peter Bernadyne ------------------------------------------------------------------------ Peter Bernadyne's Profile: http://www.excelforum.com/member.php...fo&userid=7017 View this thread: http://www.excelforum.com/showthread...hreadid=542554 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
how to add a second x axis with same Y axis value in one plot | Charts and Charting in Excel | |||
Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
Pivot Table to Ignore N/As | Excel Discussion (Misc queries) |