I have a embedded chart (there is only one chart) on a sheet. I tried naming
it with

ActivesSheet.ChartObjects(1).Name = "chart 1"

Question 1: did the above statement name the chart object or the chart
contained within the chart object?

Using a macro I tried to activate the chart with the command

Worksheets(2).ChartObjects(1).Activate

this however did not activate the chart.

If however I change the command to

Worksheets(2).ChartObjects("Chart 75").Activate

the chart is activated ("Chart 75" is the name of the chart as it appears on
the top of the widow that pops up if you right click on the chart and select
Chart Window). This name (on the Chart Window) changes everytime the chart is
redrawn.

Question 2: How can I select the chart on the desired sheet?
Question 3: Can I somehow extract the name as it appears on the Chart Window?

I do not know if it has anything to do with it, but the chart on sheet 2 was
placed as a result of a comboBox_Change code. ComboBox is on sheet 1.

Thanks for your help.