Centering Years, Months, Weeks, or labels between X-Axis Tick Marks.

Hello All,

I'm sorry to start my posing in these forums by picking your brains. I've been trying to get this to work for a day and a half and, as of yet, cannot figure out a solution.

My problem is this: In a Line chart in Excel 2007, I need to center my years between the applicable tick marks on the X axis.

I followed the example here:

http://peltiertech.com/WordPress/dat...entered-years/

and got close but could never seem to get it to work quite right. I think the formatting in the example might be different from mine for some strange reason.

Does anyone have a straightforward way of doing this that I could (eventually) build into a VBA macro to reproduce these charts every month? Attached is a sample of the data and charts where I would need the labels centered.

Test.xlsx

Again, I'm sorry to barge in here with questions but this is making me feel like an idiot. How could Microsoft look over something so obvious? Or am I the one overlooking the simple solution? :D

Thank you,
Michael

Andy,

Thanks for weighing in. I really appreciate the help. Just two questions:

- If the goal is to create text boxes and locate them under the series tick marks, Why not just do so directly?

- How did you get the years centered on the second horizontal axis between the ticks? That's exactly the effect I am going for.

Thanks again,
Michael

Hi,

I am trying to do something similar and this post was really usefull. However I still can't get what I need. What I need to do is:

- I want the year to be center (actually if I have monthly data I would like year (label) to be aligned with the June value)
- Also I would like a major tick mark at the beginning and end of each year and a minor (smaller) tick mark at every quarter (jun, sep, dec, mar)

Any advice?

Changing the text alignment to plus 1% often does the trick