Thread
:
Hide Alternate Labels on Date Axis
View Single Post
#
2
Posted to microsoft.public.excel.charting
Tushar Mehta
external usenet poster
Posts: 1,071
Hide Alternate Labels on Date Axis
In article . com,
says...
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
Reply With Quote
Tushar Mehta
View Public Profile
Find all posts by Tushar Mehta