I have created stacked column graphs using the OFFSET function to
automatically update when each week's information is added to the worksheet.

However, now my boss want's only the last 4-6 weeks of information to be
displayed on the graph. Is there a way to do this without manually changing
each data point (there are 6 for each week for each chart--YIKES) every
week?

Thank you for your time,
Dee

I found it!
http://www.peltiertech.com/Excel/Cha...micLast12.html


"Dee Sperling" wrote in message
...
I have created stacked column graphs using the OFFSET function to
automatically update when each week's information is added to the
worksheet.

However, now my boss want's only the last 4-6 weeks of information to be
displayed on the graph. Is there a way to do this without manually
changing
each data point (there are 6 for each week for each chart--YIKES) every
week?

Thank you for your time,
Dee