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