Rarefying Pivot Chart Tick Labels When the X Axis Gets Crowded

  • Thread starter grovelli via AccessMonster.com
  • Start date
G

grovelli via AccessMonster.com

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 PadanaPivot.zip that you can
download from http://mio.discoremoto.virgilio.it/modulati/
, 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top