VBA possible to read SeriesCollection by cell reference?

[Dimitris254]

I'm using a macro to make a chart in Excel, and i define the colors by:

myChart.SeriesCollection("Services").Interior.Color = RGB(...)

instead of a specific name, how could i define the collection's color by referencing the cell?

myChart.SeriesCollection("B1").Interior.Color = RGB(...)

does not work

 

[Domenic]

Try...

myChart.SeriesCollection(Range("B1").Value).Interior.Color = RGB(...)

 

[Dimitris254]

i didn't have to use it this time after all, but thank you, i'm sure it will come handy down the road