Capturing the last row of a chart and changing it

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Back
Top