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

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

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" <(E-Mail Removed)>
wrote in message news:CD081036-2813-4BAB-A6B0-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)>
> wrote in message news:CD081036-2813-4BAB-A6B0-(E-Mail Removed)...
> > 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
>
>
>

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" <(E-Mail Removed)>
wrote in message news:C750C9B0-8CC9-42B4-BB7B-(E-Mail Removed)...
> 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" <(E-Mail Removed)>
>> wrote in message
>> news:CD081036-2813-4BAB-A6B0-(E-Mail Removed)...
>> > 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
>>
>>
>>