ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Chart Name (https://www.excelbanter.com/excel-programming/304198-chart-name.html)

K Dales

Chart Name
 
Try this:
Sheets("GRAPHS").ChartObjects(1).Name = "New Name"

-----Original Message-----
I have the following name associated with my chart "Chart

81" but I want to change it but I can't find where I'm
supposed to change the name.

in a macro I see Sheets("GRAPHS").DrawingObjects

("Chart 81")

TIA
KM
.


Jon Peltier[_7_]

Chart Name
 
All about chart names:

http://peltiertech.com/Excel/ChartsH...ameAChart.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

K Dales wrote:

Try this:
Sheets("GRAPHS").ChartObjects(1).Name = "New Name"


-----Original Message-----
I have the following name associated with my chart "Chart


81" but I want to change it but I can't find where I'm
supposed to change the name.

in a macro I see Sheets("GRAPHS").DrawingObjects


("Chart 81")

TIA
KM
.




All times are GMT +1. The time now is 05:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com