Sounded good, but I can't make it work.
Should I use Dim as String as declaration of the Name, or Range? Do you (or
any other reading this) have some test template etc?

This worked. Is your solution the same?
ActiveChart.SeriesCollection(1).Values = "=" & ActiveWorkbook.Name & "!" &
scol1v
I don't want to use this , please help me through this...


Regards

PS.
I have a lot of charts I want to create in VBA and try to find a way to loop
through them. I have already grouped the multi-ranges etc. with Names and
there is 3 seriecollections with their name, variables and one xValues in
each chart. AS a MVP, maybe you have something to share from your
library...?




"Jan Karel Pieterse" skrev i meddelandet
...
Hi Marie,

Please
give me a syntax or procedure that works that I can look at...


ActiveChart.SeriesCollection(1).Values =
Activeworkbook.Names("YourName").RefersToRange

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com