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?

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

Assuming you know how to do the rest...

'...
aChart.Series(i).Name=aChart.parent.parent.columns ("F").cells(i).value

where aChart is a variable referring to the chart in question.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , says...
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?