Capturing the last row of a chart and changing it

[Guest]

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

 

[Tom Ogilvy]

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

should get you started.

 

[Guest]

Yes

Thats exactly what I'm after

Thanks
S

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

should get you started.