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.
Bookmarks