| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning the name of a chart
Jon Peltier helped by explaining how to see the name of a chart by Ctrl+click on it. Is there a way of selecting a chart of unknown name - say by clicking on it - and returning the name to use in code for subsequent operations eg returning to it, or renaming i? *** Sent via Developersdex http://www.developersdex.com *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Returning the name of a chart
One way... Dim x As String x = ActiveChart.Name -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Gordon Humphreys" wrote in message Jon Peltier helped by explaining how to see the name of a chart by Ctrl+click on it. Is there a way of selecting a chart of unknown name - say by clicking on it - and returning the name to use in code for subsequent operations eg returning to it, or renaming i? *** Sent via Developersdex http://www.developersdex.com *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Returning the name of a chart
If it's an embedded chart, use ActiveChart.Parent.Name
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jim Cone" wrote in message ... One way... Dim x As String x = ActiveChart.Name -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Gordon Humphreys" wrote in message Jon Peltier helped by explaining how to see the name of a chart by Ctrl+click on it. Is there a way of selecting a chart of unknown name - say by clicking on it - and returning the name to use in code for subsequent operations eg returning to it, or renaming i? *** Sent via Developersdex http://www.developersdex.com *** |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement not returning a blank so a chart line won't gap | Charts and Charting in Excel | |||
| GET.CHART.ITEM returning strange results | Charts and Charting in Excel | |||
| Returning the name of an embedded chart? | Excel Programming | |||
| Returning values from a multiple chart series | Excel Programming | |||
| returning a chart series formula | Excel Programming | |||
![Gordon Humphreys[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
