Excel Chart which updates every month - how?

[Victor Delta]

One of my spreadsheets records a series of monthly statistics - it's not
really important what the data represents - with the months shown in row A
i.e. each column contains 5 key monthly statistics.

I have a chart which plots these statistics against time but what I would
like to be able to do is enable the chart to automatically show only the
last 12 months figures.

I have a chart which does this by manually changing the source data -
however, surely there must be a way of getting it to update automatically
each month so it always shows just the last 12 month's data?

Any suggestions would be much appreciated.

V

 

[Jon Peltier]

You need a dynamic chart. Try this:

http://peltiertech.com/Excel/Charts/DynamicLast12.html

- Jon

 

[Victor Delta]

You need a dynamic chart. Try this:
http://peltiertech.com/Excel/Charts/DynamicLast12.html
- Jon

I knew there must be a way! Very many thanks.

V