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?