If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Set position of x axis labels
Hi
I have an Excel 2007 chart that is showing monthly performance for some different teams. I have modified the x axis so, instead of displaying Jan 2009, Feb 2009 etc. it has one label, 2009, for the whole 12 months. I did this by going to Axis Options for the x axis and setting the major unit to be fixed for 1 year. This works fine except the date is shown right against the left tick mark (effectively the beginnig of the year). How do I get the label to sit centred in the middle of the year? Thanks |
#2
|
|||
|
|||
Set position of x axis labels
I did this in a tutorial on my web site:
Arbitrary Gridlines and Axis Labels http://peltiertech.com/Excel/Charts/ArbGridLabel.html - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Lozzaw wrote: Hi I have an Excel 2007 chart that is showing monthly performance for some different teams. I have modified the x axis so, instead of displaying Jan 2009, Feb 2009 etc. it has one label, 2009, for the whole 12 months. I did this by going to Axis Options for the x axis and setting the major unit to be fixed for 1 year. This works fine except the date is shown right against the left tick mark (effectively the beginnig of the year). How do I get the label to sit centred in the middle of the year? Thanks |
#3
|
|||
|
|||
Set position of x axis labels
Great tutorial thanks very much. In fact, your whole site is great (found an
answer to a question I had on Waterfall charts while I was looking!) As for my issue, well that is far to complex a solution just to move the labels. I think I'll cheat and use text boxes instead! Thanks again "Jon Peltier" wrote: I did this in a tutorial on my web site: Arbitrary Gridlines and Axis Labels http://peltiertech.com/Excel/Charts/ArbGridLabel.html - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Lozzaw wrote: Hi I have an Excel 2007 chart that is showing monthly performance for some different teams. I have modified the x axis so, instead of displaying Jan 2009, Feb 2009 etc. it has one label, 2009, for the whole 12 months. I did this by going to Axis Options for the x axis and setting the major unit to be fixed for 1 year. This works fine except the date is shown right against the left tick mark (effectively the beginnig of the year). How do I get the label to sit centred in the middle of the year? Thanks |
Thread Tools | |
Display Modes | |
|
|