naming charts 1

[jluft]

all,
i am trying to rename a chart/graph...when created, it is being assigned the default name, "Chart 29"...for some reason it is not allowing me to manipulate this value manually or via code...i tried the line

activechart.name = "XYZ" and this is returning an error msg..does anyone have an idea as to how i can resolve this? thanks

 

[SkipVought]

Hi,

Please post ALL the code up to the point where it errors.

Skip,

_{[red]Be advised:[/red]To be safe on the FOURTH, don't take a FIFTH on the THIRD, or...
You might not come FORTH on the FIFTH!}

 

[SkipVought]

BTW, there's a difference in a Chart Object and a ChartObject Object. This may be the problem.

Charts & VBA faq707-4811

Skip,

_{[red]Be advised:[/red]To be safe on the FOURTH, don't take a FIFTH on the THIRD, or...
You might not come FORTH on the FIFTH!}

 

[jluft]

skip,
actually i was just testing the property by selecting the chart, and then trying to execute the code that i already showed you...
for example,
<select the chart manually>
enter code and run
activechart.name = "XYZ"

i do not understand why this property would be behaving as though it is unalterable..even when i simply click on the chart itself and try to overwrite the name on the top left of the screen, it does not allow for this action to take place. could this be as simple as me havnig a property disable without knowing it?

 

[SkipVought]

I deduce that you have an embedded chart in a worksheet.

Did you read the FAQ? It might have helped you discover the answer.

Chart Objects have name properties.

Chart properties in ChartObject Objects do NOT have name properties. ChartObject Objects have name properties.

So in YOUR CASE...

ActiveChart.Parent.Name = "XYZ"

Skip,

_{[red]Be advised:[/red]To be safe on the FOURTH, don't take a FIFTH on the THIRD, or...
You might not come FORTH on the FIFTH!}