I have a chart for a year and what I want the chart to do automatically is just show the last specified number of weeks (without me having to change data source every week). e.g. if I am in in week 10 of a year and I only want the chart to show the last 5 weeks, when I add data for week 11, what will appear in my chart (automatically) are weeks 6-11 inclusive. Equally when I add data for week 12, the chart will now just show week 7-12 inclusive.
My gut feeling is that it is some sort of dynamic range creation but am looking forward to seeing your answers..