dynamic chart with named ranges

Hello people,
I am trying to use as source data a named range and cant get the hang of it.
this would be the cod

Please Login or Register  to view this content.

Can you give me a hint on how can I use a named range as the data source for the chart?
Thank you

ActiveChart.SetSourceData Source:= Range("name_of_range")

ok but I want the "name_of_range" to be dynamic, as in I wanted to be linked to a data list that contains people names. Names who are also the name of some ranges of data.

Please Login or Register  to view this content.

or just attach your example-file to anderstand your problem more clearly for me

Book1.xlsx

this is an example file.. in the first sheet you have the "table", and in the 2nd one i want that when i change names the chart to update with the values from the table.

Just one additional table
Book1.xlsx

thank you for your help have an awesome weekend.