Dynamic chart by date

[Michael_E]

I have a 5 year plan chart, it's sort of a Gantt chart. I more or less have it how I want it, but the only thing I can't seem to get it to do is automatically adjust the minimum and maximum X axis values for the labels automatically, nor do I know if it is even possible to do so, but what I want to happen is for the first axis value to always be the current day and to create a sort of rolling chart. My chart looks very similar to this one at www.officetimeline.com, as I used their instructions to generate it.

 

[Michael_E]

I have solved this problem on my own through creative use of text boxes and formulae, I guess writing out the question helped me to better visualize this in my head. Thank you to anyone who may or may not have been attempting to help with this issue xD