Capturing the last row of a chart and changing it
 

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

Capturing the last row of a chart and changing it
 

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

Capturing the last row of a chart and changing it
 

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