Access an embedded chart via its name???

[DashBoarder]

Greetings to all!

Excel 2010
Win7 Ultimate SP1

I'm working on some dashboards using embedded charts. I know how to access a chart by first activating it, then using ActiveChart to modify it, e.g....

ActiveSheet.ChartObjects("TestChart2").Activate
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(2).Name = "=Sheet2!$R$2"
...

But is there a way to access a chart directly, by name, without having to first activate it? If possible, I prefer to interact with entities by name rather than selecting or activating them first.


Thanks!

 

[pgc01]

Hi
Welcome to the board

Try:

...
Dim cht As Chart

Set cht = ActiveSheet.ChartObjects("TestChart2").Chart
With cht
    .SeriesCollection.NewSeries
    .SeriesCollection(2).Name = "=Sheet2!$R$2"
    ' ...
End With
...

 

[DashBoarder]

Super! Works great. THANKS for your kind and prompt reply!

 

[pgc01]

You're welcome. Thanks for the feedback.