You can use the Formula property of the series. Jon Peltier has
instructions on his web site:

http://www.peltiertech.com/Excel/Charts/ChgSrsFmla.html

Mariusz wrote:
Hi,
I've got problem with charts in vba.
I'd like to modifty data in the chart.
For example data of series1 are addressed "=CHF!A1:A5" and I'd like to
change it for "EUR!A1:A5". I've got to read first where the data of series1
are located.

I wanted to do it through:

dim strAddress as string
dim obChart as Chart

...

strAddress=obChart.SeriesCollection(1).Values

but it doesnt work because obChart.SeriesCollection(1).Values returns array.
How to read the address of series1?

Thanks for help
Mariusz




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html