Changing the chart name
Where/how can I change the name of a chart?
When my chart is referenced in macro code, it is referred to as "Chart 2", i.e. ActiveSheet.ChartObjects("Chart 2").Activate I want to be able to change the name to something more meaningful, but I want to do it directly on the chart itself and not in the macro code. Any ideas? Thanks in advance |
Changing the chart name
http://peltiertech.com/Excel/ChartsH...ameAChart.html
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Sarah (OGI)" wrote in message ... Where/how can I change the name of a chart? When my chart is referenced in macro code, it is referred to as "Chart 2", i.e. ActiveSheet.ChartObjects("Chart 2").Activate I want to be able to change the name to something more meaningful, but I want to do it directly on the chart itself and not in the macro code. Any ideas? Thanks in advance |
All times are GMT +1. The time now is 04:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com