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

You need a dynamic chart. Try this:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Victor Delta" wrote in message
...
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" wrote in message
...
You need a dynamic chart. Try this:
http://peltiertech.com/Excel/Charts/DynamicLast12.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com

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

V