Controling Chart Names
 

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

Controling Chart Names
 

If you have already created the chart:

Sub dural()
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.Parent.Name = "some logical name"
End Sub
--
Gary''s Student - gsnu200813

Controling Chart Names
 

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.

--
__________________________________
HTH

Bob

"AllSensibleNamesTaken"
wrote in message ...
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

Controling Chart Names
 

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" wrote:

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.

--
__________________________________
HTH

Bob

"AllSensibleNamesTaken"
wrote in message ...
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

Controling Chart Names
 

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.

--
__________________________________
HTH

Bob

"AllSensibleNamesTaken"
wrote in message ...
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" wrote:

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.

--
__________________________________
HTH

Bob

"AllSensibleNamesTaken"
wrote in message
...
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