12 month rolling chart

I'm trying to create a dynamic chart in excel 2003 that shows the current month, plus 12 months in the future. I managed to create a dynamic chart using an OFFSET function, but it just shows the 12 months before the last row of data entered.

Unfortunately the nature of the data I'll be using means that some will be entered way in advance, but isn't useful to graph until it's in the next 12 months from the present time (if that makes sense).

Any help with getting it so it graphs from the month in Q3 onwards?

I followed this tutorial and used defining names of data to create this graph: http://peltiertech.com/Excel/Charts/DynamicLast12.html

Excel test 2.xls

Thanks for any help (and sorry for making 2 topics in the same day)

Yes, thank you for this! I've been fiddling for ages and couldn't get it to work! I'll have a play with the Index and Match functions too.