| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date X axis Affect Bar Width in a Bar Chart | Charts and Charting in Excel | |||
| Y axis labels | Charts and Charting in Excel | |||
| Labels on Chart with Negative Value Axis | Charts and Charting in Excel | |||
| How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) | |||
| Linking Axis Labels | Charts and Charting in Excel | |||
Linear Mode
