You can possibly arrange for the charts to show the last 12 (or
whatever) data points in the source, saving on the need to do the
update at all; just entering the new month's data would result in the
charts moving on a month.

See, for example, funchrt1.zip on
http://www.oaltd.co.uk/Excel/Default.htm
---
Alternatively, record a macro while making the changes manually and
then consider how you could generalise it so it will work correctly
next month. If you need help with the generalising, post the relevant
part of the macro in your message - the Excel.Programming group is
probably the best one to choose.




Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup