plotting a graph with variable start date

Hi.

I have a large table of data with dates in column A and 8 other columns. The dates start at 1/June of this year and extend, day by day, about 2 years into the future.

I need to plot some of the data with the date on the x-axis. I know how to do this, no problem.

But.. some graphs I want the x-axis to start with today's date, which changes day by day of course, rather than at 1/June. How do I go about this please?

Thanks as always. KK

PS I have Excel 2007

This looks interesting, I will explore, mega-thanks