P
Peter Bernadyne
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
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