| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
naming charts
Thanks Andy! I hadn't considered that. -- Mariano "Andy Pope" wrote: As the chart is embedded you need to use ActiveChart.parent.name = "HourChart" Cheers Andy Mariano B. wrote: Tushar, I'm creating some charts and I want to name them as they are created for further use on my macro, but i've been having trouble with it. I get an error every time I try to rename the chart. Here's my code : Sub IPChart() Charts.Add With ActiveChart .ChartType = xlColumnStacked .SetSourceData Source:=Sheets("Recortadores").Range("B37:L94"), PlotBy:=xlColumns .Location xlLocationAsObject, name:="Recortadores" End With 'To make sure there is a name, I always get "Recortadores Chart x" MsgBox ActiveChart.name ActiveChart.name = "HourChart" End Sub Sub prueba() If ChartExists("Recortadores", "IPInfoChart") Then MsgBox "ok" End If End Sub I hope you can help me with this. Greetings -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| link excel charts to web pages and update charts automatically | Charts and Charting in Excel | |||
| Help with naming | Excel Discussion (Misc queries) | |||
| Naming charts on own sheet | Charts and Charting in Excel | |||
| tab naming | Excel Worksheet Functions | |||
| Tab naming | Excel Discussion (Misc queries) | |||
Threaded Mode
