Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel 2007 - change interval between labels on X axis
I have two layers of labels on the X axis.Top labels are days of the
month 1-30 or 31. Under that is the month - May, June etc. I cannot seem to change the interval between labels, to show for example days of the month as 1, 3, 5 ... rather than 1, 2, 3 ... I can change the interval in the Format Axis dialogue box but this does not flow through to the chart. I'm thinking it is something to do with having two layers of labels. Anyone have any thoughts? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel 2007 - change interval between labels on X axis
I think it's because of the compound axis. In Excel 2003, you aren't even
given the impression that you can change this spacing: the controls are disabled. They just didn't have time to make the dialogs "nice" for the release of 2007. Why not keep your complete date in a cell, and use a date-scale axis? It is more flexible and less cluttered than a two-layer axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "artemis" wrote in message ... I have two layers of labels on the X axis.Top labels are days of the month 1-30 or 31. Under that is the month - May, June etc. I cannot seem to change the interval between labels, to show for example days of the month as 1, 3, 5 ... rather than 1, 2, 3 ... I can change the interval in the Format Axis dialogue box but this does not flow through to the chart. I'm thinking it is something to do with having two layers of labels. Anyone have any thoughts? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel 2007 - change interval between labels on X axis
Thanks for responding Jon. Normally I do use a date format but in this
particular case the dual layer of labels gives a clearer picture of what's going on in the data. I will experiment with some other formats though. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel 2007 - change interval between labels on X axis
I suppose you could manually delete the cells in the 'day of the month'
range to prevent their appearance. Not elegant, but if it's effective.... - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "artemis" wrote in message ... Thanks for responding Jon. Normally I do use a date format but in this particular case the dual layer of labels gives a clearer picture of what's going on in the data. I will experiment with some other formats though. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 change column labels from numbers to letters | Setting up and Configuration of Excel | |||
Change Axis titles in Excel 2007 | Excel Discussion (Misc queries) | |||
Need to know the logic for determining the interval between Y axis labels | Charts and Charting in Excel | |||
change the position of X-axis labels | Charts and Charting in Excel | |||
Can't change x-axis labels | Charts and Charting in Excel |