How to Format A Graph for a Moving 10 Week Period

[wec43wec]

I am creatng a graph with data for 10 weeks (cell A1 thru J1, however I will continue to add data after each week.

I want the graph to automatically update to the last 10 weeks of data.

Is there an easy way to do this without me manually changing the data range?

Thanks

 

[SkipVought]

hi,

Check out the OFFSET function for each series. There's an explanation in faq68-1331, and Excel HELP.

To find the beginning of the last 10 in a range, you would use COUNTA-9 as an offset.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}