I use lots of charts which have a time x-axis showing, for example the last 6 months data and a projection of the next 6 months. Every day I manually change where the vertical axis crosses the x-axis to today's date. Is there a way I can make this automatic? I.e., can I put a range or cell address into the box where I manually type the date?

I've just started looking at VBA so could maybe eventually come up with a Macro to do this but I was wondering if there was an easy way around it. (I use Excel2010.)

Thanks.

All the best for Christmas and the New Year!