how can i getting chart's sourcedate range

[classpeople]

I can create a chart by set it's sourcedata like
excelchart.SetSourceData(excelrange);//delphi programme language
but how can i get sourcedata range from a existed chart
just return like "Sheet2!$B$2:$E$12"

Thanks !

 

[Jon Peltier]

There is no easy way to do this. It is possible that different series
have different numbers of points, and different starting rows or
columns, or even different sheets. You can determine the source of each
series' data, and perhaps do a union of these ranges.

John Walkenbach has developed a class module to extract this information
from a series. It's located on his web site:

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

Lots of other cool stuff there too.

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