I have a number of charts that need to be extended each day as a new
column of data is added daily. I know how to do this manually but it's
a pain so I want to automate this. Once I (manually) add the new
column of data I want to run a macro that will simply extend each data
source by the new column. I can see how to do this manually and I can
see how to use the SetSourceData method to change the data source but I
don't see what property/method I can use to get the current data source
in a text form (eg, r2c1:r4c20) so I can extend it. If I can get this
text form of the data source I could edit the text (-- r2c1:r4c21) and
use SetSourceData and I'll be in business.

Is there a property/method I can use to get this text form of the data
range? Or is there a better way to do this data range extension?

Denis

No need for VBA. You can set up dynamic ranges as the data source for each
series:

http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Denis" wrote in message
oups.com...
I have a number of charts that need to be extended each day as a new
column of data is added daily. I know how to do this manually but it's
a pain so I want to automate this. Once I (manually) add the new
column of data I want to run a macro that will simply extend each data
source by the new column. I can see how to do this manually and I can
see how to use the SetSourceData method to change the data source but I
don't see what property/method I can use to get the current data source
in a text form (eg, r2c1:r4c20) so I can extend it. If I can get this
text form of the data source I could edit the text (-- r2c1:r4c21) and
use SetSourceData and I'll be in business.

Is there a property/method I can use to get this text form of the data
range? Or is there a better way to do this data range extension?

Denis