Chart only a part of a large data set

[delboy2405]

Hi,

I am looking to set up a chart with a years worth of data but i only want to chart a 13 week period. This 13 week period will change every week.

i.e. if this week is week 51 then I want to chart week 39 to 51 and next week will be 40 to 52.

I have setup up the data as the rows are the week from 1 to 52 and the columns are Level 3, 4, and 5 respectively

each cell will have a number anywhere usually from 1 to 10.

I know if probably needs a dynamic named range but i've never used this before.

Thanks