View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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