Results 1 to 1 of 1
2005-09-28, 12:16 #1
- Join Date
- Jan 2001
- Alzano Lombardo, Italy
- Thanked 0 Times in 0 Posts
Rarefying tick labels when the x axis gets crowded
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
<font color=red>axCategory.TickLabelUnitType = 2</font color=red>
in the FormatSeriesLabel sub in Module1 with the message
<font color=448800>Invalid Parameter</font color=448800>
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 March 1, 2004 and the "ends" date to March 31, 2004, select the "Lake Level" option button and click the Chart button.