Changing Chart Series Names
 

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?

Changing Chart Series Names
 

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

Changing Chart Series Names
 

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?