Rarefying Pivot Chart tick labels when the x axis gets crowded

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.

P.S. I don't seem to be able to attach a 90 kB zip file. I click on
the "Manage Attachments" button, select the zip file and click the
"Upload" button but I get the message:
*Warning*: filesize(): open_basedir restriction in effect.
File(/var/tmp/phpBCDmKG) is not within the allowed path(s):
(/usr/home/highdots/:/usr/lib/php:/usr/local/lib/php:/tmp) in
*/includes/functions_file.php* on line *286*
What's the meaning of it?


--
grovelli
------------------------------------------------------------------------
grovelli's Profile: http://www.hightechtalks.com/m36
View this thread: http://www.hightechtalks.com/t2345767