Hi,

I have about 100 charts in a spreadsheet that refer to various sheets filled
with data of varying number of columns. When I import new data over the
existing data the charts ofcourse do not reflect the additional data. What I
want to do is be able to click a button to update all the charts by looping
through them to show the new data which is imported onto these sheets.

I don't want manually go to the series and make them dynamic as there are
one hundred of them. So I need to capture from the chart the reference to the
data and modify it.

Any guidance will be greatly appreciated.

Thanks in advance

Suzanne

http://www.j-walk.com/ss/excel/tips/tip83.htm

should get you started.

--
Regards,
Tom Ogilvy


"Grd" wrote in message
...
Hi,

I have about 100 charts in a spreadsheet that refer to various sheets
filled
with data of varying number of columns. When I import new data over the
existing data the charts ofcourse do not reflect the additional data. What
I
want to do is be able to click a button to update all the charts by
looping
through them to show the new data which is imported onto these sheets.

I don't want manually go to the series and make them dynamic as there are
one hundred of them. So I need to capture from the chart the reference to
the
data and modify it.

Any guidance will be greatly appreciated.

Thanks in advance

Suzanne

Yes

Thats exactly what I'm after

Thanks
S

"Tom Ogilvy" wrote:

http://www.j-walk.com/ss/excel/tips/tip83.htm

should get you started.

--
Regards,
Tom Ogilvy


"Grd" wrote in message
...
Hi,

I have about 100 charts in a spreadsheet that refer to various sheets
filled
with data of varying number of columns. When I import new data over the
existing data the charts ofcourse do not reflect the additional data. What
I
want to do is be able to click a button to update all the charts by
looping
through them to show the new data which is imported onto these sheets.

I don't want manually go to the series and make them dynamic as there are
one hundred of them. So I need to capture from the chart the reference to
the
data and modify it.

Any guidance will be greatly appreciated.

Thanks in advance

Suzanne