Chart only a part of a large data set

**delboy2405** · 12-23-2008, 11:32 AM

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

**Andy Pope** · 12-23-2008, 11:39 AM

There are plenty of examples on the forum. Try searching for dynamic ranges.

This explains Last 12 months but the principle will be the same
http://peltiertech.com/Excel/Charts/DynamicLast12.html

**JimmyA** · 12-23-2008, 11:40 AM

Hi There

Not sure if this works in other verisons of excel but it 2007 if you create a chart based on all the data and use auto filter on the data, the chart will change based on the auto filter.

Hope this helps

Cheers

Jim

**delboy2405** · 12-23-2008, 12:14 PM

Hi i've had a look at other questions but can't find something similar to mine.

I am using rows and not column, i have attached a workbook for you to look at thanks