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
Bookmarks