Juggernath wrote:
I have an selected chart and data column (G) in Worksheet. The number
of data and series is the same and supposed names of series are in
column (F). How to access data range of selected chart (in column G)
so i could change default Series names to supposed names of series?

John Walkenbach has created a class to help fill this hole in the Excel
object model:

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

Rob