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