I have an index too <g:

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

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


"Tom Ogilvy" wrote in message
...
Also at Debra's site is an index into Jon Peltier's site. Look in that
index
for dynamic chart:

http://www.contextures.com/JPChartIndex.htm

--
Regards,
Tom Ogilvy


"Nigel RS" wrote:

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