Line Graph X-Axis Labels

[Nate123]

I have a chart with data from Jan. 1, 2005 - Feb. 15, 2011. I only want labels along the bottom going back year by year from the most recent date. I.e. Feb. 15, 2011; Feb. 15, 2010; etc. However, the chart defaults to starting the labels on the first date. Is this possible to do this without fiddling around with the major and minor units and messing with dates until it works? I want it to update automatically as new data is frequently added.

Thanks for the help.

 

[Gerald Higgins]

If I understand you correctly, there are several ideas in this thread which may help . . .
http://www.mrexcel.com/forum/showthread.php?t=535033