Controling Chart Names

[AllSensibleNamesTaken]

Is there a way to control the names charts are given in Excel?
For example, a combo box can be renamed by setting its Name property.

I cannot see a way to change a Chart's name.
I need this so my VBA code can correctly distinguish between different
charts using a more sensible naming convention than Chart1, Chart2 etc...

I sigh in expectation of no solution... perhaps what I should do is finally
ditch VBA and move to a proper OO .NET language where I hope to find event
handlers with some from of "this" concept. Anyone had good or bad experiences
moving or writing new event driven .NET code to work with Excel?

Thanks so much

 

[Gary''s Student]

If you have already created the chart:

Sub dural()
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.Parent.Name = "some logical name"
End Sub

 

[Bob Phillips]

Instead of just selecting the chart, Shift-Select it. You will then see the
chart name appear in the Names box, where you can change it.

 

[AllSensibleNamesTaken]

Nice one,

I find the Names box very fidgety. For some reason it only gives me a couple
of seconds to change anything in it. If I'm not quick enough it goes back to
the value before I started editing.

Is anyone else having that problem?

Can I perhaps use the namesManager (Ctrl+F3) in some way to name charts?

 

[Bob Phillips]

I don't get that problem. Once selected it stays.

NameManager manages defined names, a chart name is not one of those, so it
can't help you.