View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
[email protected] pablito108@gmail.com is offline
external usenet poster
 
Posts: 1
Default Hide Alternate Labels on Date Axis

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.