CODEWITHSUNDEEP
excelvba
flamingbird123
flamingbird123

Reputation: 133

How do I name a chart object?

How do I change the name of a chartobject instead of referring it as ChartObject(1)? The Chartobject is on a sheet named "Unit2SelectedData"

Sheets("Unit2SelectedData").ChartObjects.Add Left:=1700, Top:=50, Width:=800, Height:=400
Sheets("Unit2SelectedData").ChartObjects(1).Activate

Upvotes: 0

Views: 106

Answers (1)

Shai Rado
Shai Rado

Reputation: 33672

Try setting the ChartObject first, and then name it:

Dim ChtObj As ChartObject

Set ChtObj = Sheets("Unit2SelectedData").ChartObjects.Add(Left:=1700, Top:=50, Width:=800, Height:=400)
ChtObj.Name = "My Chart"

Upvotes: 3

Related Questions