I have an Excel spreadsheet with a sheet dedicated to my data. Additionally,
I have a chart pulling data from this sheet. I have data starting with
August 07. When I enter in data for August 08, I want the chart to reflect
only 12 months of data and thus, I want the August 07 data to fall off so it
can include the August 08 data and so on. I have searched for rolling over
data/chart and don't see anything. I must not be calling it the correct
thing. Anyway, I hope this makes sense. Any ideas?
Thanks for your time.