I'm having a problem with a possible bug that seemingly prevents the TickLabelUnitType property from working properly.
I'm trying to use the TickLabelUnitType property to display a tick label for every month on the time-scaled category axis but when I open the chart, the code stops at the line
axCategory.TickLabelUnitType = 2
in the FormatSeriesLabel sub in Module1 with the message
Invalid Parameter
chAxisUnitMonth, which is 2, is a valid constant for the TickLabelUnitType property according to help on line, so why the message?
To check it out, on the startup form of the attached mdb, please set the "begins" date to January 1, 2004 and the "ends" date to December 31, 2004, select the "Lake Level" option button and click the Chart button.
I'm trying to use the TickLabelUnitType property to display a tick label for every month on the time-scaled category axis but when I open the chart, the code stops at the line
axCategory.TickLabelUnitType = 2
in the FormatSeriesLabel sub in Module1 with the message
Invalid Parameter
chAxisUnitMonth, which is 2, is a valid constant for the TickLabelUnitType property according to help on line, so why the message?
To check it out, on the startup form of the attached mdb, please set the "begins" date to January 1, 2004 and the "ends" date to December 31, 2004, select the "Lake Level" option button and click the Chart button.
