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