Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart name
Here is an easy one, I guess, for those who know the answer: Charts on a worksheet are named Chart1, Chart2, etc. as they are created, and this is the name you must refer to when manupulating them in VBA. Is it possible to look up the name of a chart, and if affirmative is it possible to change it? NSV -- nsv ------------------------------------------------------------------------ nsv's Profile: http://www.excelforum.com/member.php...o&userid=26500 View this thread: http://www.excelforum.com/showthread...hreadid=557251 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart name
Hi,
Hold the Shift key whilst selecting the chartobject, sizing handles shold be white instead of black, and the charts name will appear in the Name Box (next to the formula bar). You can then change the charts name via the name box. With code use, Activechart.parent.name = "NewName" Cheers Andy nsv wrote: Here is an easy one, I guess, for those who know the answer: Charts on a worksheet are named Chart1, Chart2, etc. as they are created, and this is the name you must refer to when manupulating them in VBA. Is it possible to look up the name of a chart, and if affirmative is it possible to change it? NSV -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart name
Thanks Andy... -- nsv ------------------------------------------------------------------------ nsv's Profile: http://www.excelforum.com/member.php...o&userid=26500 View this thread: http://www.excelforum.com/showthread...hreadid=557251 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting values in a bar chart | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |