Rename chart name in VBA?

[Calicat]

I have a macro which creates a new Chart, and calls it Chart(1). I have the title, etc. already named in my macro, but I want to be able to rename the chart(1) tab in the workbook. The chart is NOT embedded in a spreadsheet.

In the VBA help, it mentions the name property, but the examples are not clear on how to use this in VBA for a chart. Any suggestions?

 

[Juan Pablo González]

Something like

Cht.Name = "MyChart"

if you use an object variable for the chart, or this too:

ActiveChart.Name = "MyChart"

or this

ActiveSheet.Name = "MyChart"

 

[Calicat]

Yes, it worked with Activechart.name = "Name"

I was trying it under the 'With chart' portion of my code, with the .name type of syntax.

THANKS! SOLVED.

 

[NateO]

Quick tack-on, it looks like you're trying to use an index with a chart object in a sheet. These should fire using indexes and names, without the chart being active:

Sheets(1).ChartObjects(1).Name = "test2"
Sheets(1).Shapes("test2").Name = "test3"
Sheets(1).Shapes(1).Name = "test1"
Sheets(1).ChartObjects("test1").Name = "test2"

Shapes is little more vague...

 

[Andrew Poulsom]

Yes, it worked with Activechart.name = "Name"

I was trying it under the 'With chart' portion of my code, with the .name type of syntax.

THANKS! SOLVED.

When a chart is on a worksheet the Name property applies to the ChartObject object which is the container for the Chart object. So:

With Chart
   .Parent.Name = "Name"
End With

should work.

 

[Juan Pablo González]

Actually...

The chart is NOT embedded in a spreadsheet

...

 

[Andrew Poulsom]

Actually...

The chart is NOT embedded in a spreadsheet

...

Better tell Nate too!

 

[Juan Pablo González]

Better tell Nate too!

Actually I was ! but then in the "Topic Review" saw your reply as well, so I deleted teh "Actually Nate" and put the "Actually..."

 

[NateO]

Better tell Nate too!

D'Oh! I swear I can read...

Well how's this not functional?

Charts(1).Name = "Test"

Looks like the OP was very close in the orginal post.