D
Dee Sperling
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
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