Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
chart id number
hold down the control key while clicking to select the chart and you should
see the name in the Name box. (upper left corner on the formula bar - you need to have the formula bar visible). -- Regards, Tom Ogilvy "Paul" wrote in message ... When I record a macro and, in the process, click on a chart, the macro code includes the following: ActiveSheet.ChartObjects("Chart 12").Activate Is there another place to find the number (Chart 12) that excel has assigned to its charts? I am thinking there must be a way to get this infomation other than recording a macro. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
chart id number
Extending Tom's reply, if you are creating the chart programmatically, you could
have your code give it a unique name, which you could access in a subsequent routine. In fact, you are naming the chart object, so the code looks like: ActiveChart.Parent.Name = "ChtFinYE04" - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Tom Ogilvy wrote: hold down the control key while clicking to select the chart and you should see the name in the Name box. (upper left corner on the formula bar - you need to have the formula bar visible). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number and % on same chart | Charts and Charting in Excel | |||
How do I set up a chart with number not percentage. | Excel Discussion (Misc queries) | |||
Chart number of occurences | Charts and Charting in Excel | |||
Number formatting in chart | Charts and Charting in Excel | |||
Number of items per day in chart. | Charts and Charting in Excel |