Hide Alternate Labels on Date Axis

[pablito108]

Hi,

I'm having trouble trying to hide every other label along a horizontal
date axis. I start on the 01-Jan up to 10-Jan and through using the
'Format Axis'->'Scale'->'Major Unit' and setting this to 2 I can hide
the labels: '02-Jan'; '04-Jan'; etc.

However, I want to hide the odd dates: '01-Jan'; '03-Jan'; etc. I have
tried the various combinations with the dialog box but can't get
anything to work.

Should I be using a custom formula or something?

Any help is much appreciated.



Paul.

 

[Tushar Mehta]

Hi,

I'm having trouble trying to hide every other label along a horizontal
date axis. I start on the 01-Jan up to 10-Jan and through using the
'Format Axis'->'Scale'->'Major Unit' and setting this to 2 I can hide
the labels: '02-Jan'; '04-Jan'; etc.

However, I want to hide the odd dates: '01-Jan'; '03-Jan'; etc. I have
tried the various combinations with the dialog box but can't get
anything to work.

Should I be using a custom formula or something?

How about just starting the x-axis at Dec. 31?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions