Renaming Chart Objects

[tobyst1]

I have some VBA code running to format charts based on different currencies. One worksheet has several charts and many of them have the same chart name (Chart 5).

I guess this happened with some lazy copies and pastes a long time ago. The problem is the VBA code for Chart 5 will understandably only apply itself to the first Chart 5 it finds in the worksheet.

I have a partial solution by saving the chart as a template and inserting new charts with new names. However, the charts are very intricate and the template doesn't reproduce them perfectly.

I've been looking through the forum and on the web and it seems the option to rename a chart object with the drop down list in the rbbon was removed in Excel 2013. Is there an easy way to change the chart object name?

Many thanks.

[Greg M]

Hi there,

Maybe I'm missing something here, but you can rename ChartObjects using either the following code:

Please Login or Register  to view this content.

or else by inserting the required name in the highlighted box when the ChartObject is selected:


Hope this helps - please let me know how you get on.

Regards,

Greg M

[tobyst1]

Hi Greg,

Thanks a million. The code worked perfectly.

However, unless I'm mistaken, the option to edit the object name shown in your screenshot is no longer permissible in Excel 2013. It is possible to overtype a new name, but it then reverts to the old name. (Maybe this is a settings issue.)

Thanks again for the code.

Toby

[Greg M]

Hi Toby,

Many thanks for your feedback and also for the Reputation increase

As far as I know you can use the "screenshot" approach to rename a ChartObject provided that the proposed new name is not already assigned to an existing ChartObject on the same worksheet. If you want to rename Chart 99 as Chart 1 and Chart 1 already exists, you must first rename Chart 1 as (e.g.) Chart 567 and then rename Chart 99 as Chart 1.

Hope this helps,

Best regards,

Greg M