Check Jon Peltiers website.
He's the man when talking about chrts....

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


--
Mark Rosenkrantz
--
Spreadsheet Solutions
Witkopeend 24
1423 SN, Uithoorn
Netherlands
--
W: www.rosenkrantz.nl
E:
--
"Nigel RS" wrote in message
...
Hi All,
I have a set of embedded charts (linked to worksheet data). Typically
these
might show the last 12 months of data, but it may be other fixed periods
as
required.

How can I arrange for the chart ranges to dynamically change as new values
are added to next empty cell in the range? For example if I am
displaying
the last 12 months say Jul06 thru Jun07, when I add a value for Jul07 the
chart changes to show Aug06 thru Jul07.

Currently we edit the chart ranges manually, which is both tedious and
error
prone.

Prefer a Excel function solution but if VBA needed we can use it.

Many thanks