Graph data updates

[este994]

Hello, I wonder if anyone can help me.

Im looking to update a graph every month but only ever want to include the latest 13 weeks. How can I tell the graph to only select the last 13 weeks of a range of data to which there will regularly be weeks added onto the end.

Thanks. Reply With Quote

[sweep]

Hi,

You could use a dynamic named range to plot the last 13 entries in a column of data.

Assuming your data is in column A, this formula

=OFFSET(Sheet1!$A$1,COUNT(Sheet1!$A:$A)-1,0,-13,1)

defines a range that is the last 13 entries.

Please see attachment for clarification.