How to move a chart? Can't get the name syntax right

[MattTran]

Hi, newbie here again.

I created a macro using the recorder, and it gave me this.

ActiveSheet.Shapes.AddChart2(240, xlXYScatter).Select
ActiveSheet.Shapes("Chart 6").IncrementLeft 261
ActiveSheet.Shapes("Chart 6").IncrementTop -59.25

Later on in the macro I name the chart "2000 to 2001" using

ActiveChart.HasTitle = True
ActiveChart.ChartTitle.Text = "2000 to 2001"

I want to move the chart again, but when I use the code:

ActiveSheet.Shapes("2000 to 2001").IncrementLeft 200

or

ActiveSheet.ChartObjects("2000 to 2001").IncrementLeft 200

Neither work.

The error I get is "The item with that specified name is not found"

What is a way I can move the chart by referring to it's title?

[Andy Pope]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

You can not use the chart title to automatical create a reference. You would either need to loop through all charts checking whether they had a chart title and then seeing if the text matches. Or name the chart object, which you can use to reference directly