| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to change the name of the object Graph 1 in Excel ?
I've done some Macros in VBA in the spanish version and some users with the
Engish version can't use them due to the name of the graphs. I tried to change the name of the graphs (objects) but i cannot. Any idea to solve the problem? Thanks |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to change the name of the object Graph 1 in Excel ?
Hi,
Use something like this to change the name of the active chart object. Activechart.parent.name = "MyChart" For the 1st chart object on the sheet you could use the Index to reference it. Activesheet.chartobjects(1).Name = "MyChart" If you still need help it would be useful if you could post the code you currently use pointing out where it fails. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "rir" wrote in message ... I've done some Macros in VBA in the spanish version and some users with the Engish version can't use them due to the name of the graphs. I tried to change the name of the graphs (objects) but i cannot. Any idea to solve the problem? Thanks |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to change the name of the object Graph 1 in Excel ?
It didn't work. When I see the incrustated the window Graph it still appears
the old name (Gráfico 1). The macro works but it fails when one person using the English version of excel because in this version the name is Graph 1 Cheers and thanks "Andy Pope" wrote: Hi, Use something like this to change the name of the active chart object. Activechart.parent.name = "MyChart" For the 1st chart object on the sheet you could use the Index to reference it. Activesheet.chartobjects(1).Name = "MyChart" If you still need help it would be useful if you could post the code you currently use pointing out where it fails. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "rir" wrote in message ... I've done some Macros in VBA in the spanish version and some users with the Engish version can't use them due to the name of the graphs. I tried to change the name of the graphs (objects) but i cannot. Any idea to solve the problem? Thanks |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to change the name of the object Graph 1 in Excel ?
Both of my example code use other ways of referencing the chart object. The
name should not matter. I agree that code like this would fail if the object was called "Gráfico 1". Activesheet.chartobjects("Chart 1").name = "MyChart" Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "rir" wrote in message ... It didn't work. When I see the incrustated the window Graph it still appears the old name (Gráfico 1). The macro works but it fails when one person using the English version of excel because in this version the name is Graph 1 Cheers and thanks "Andy Pope" wrote: Hi, Use something like this to change the name of the active chart object. Activechart.parent.name = "MyChart" For the 1st chart object on the sheet you could use the Index to reference it. Activesheet.chartobjects(1).Name = "MyChart" If you still need help it would be useful if you could post the code you currently use pointing out where it fails. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "rir" wrote in message ... I've done some Macros in VBA in the spanish version and some users with the Engish version can't use them due to the name of the graphs. I tried to change the name of the graphs (objects) but i cannot. Any idea to solve the problem? Thanks |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to change the name of the object Graph 1 in Excel ?
You're completely right!
It works Thanks and cheers! Ramon "Andy Pope" wrote: Both of my example code use other ways of referencing the chart object. The name should not matter. I agree that code like this would fail if the object was called "Gráfico 1". Activesheet.chartobjects("Chart 1").name = "MyChart" Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "rir" wrote in message ... It didn't work. When I see the incrustated the window Graph it still appears the old name (Gráfico 1). The macro works but it fails when one person using the English version of excel because in this version the name is Graph 1 Cheers and thanks "Andy Pope" wrote: Hi, Use something like this to change the name of the active chart object. Activechart.parent.name = "MyChart" For the 1st chart object on the sheet you could use the Index to reference it. Activesheet.chartobjects(1).Name = "MyChart" If you still need help it would be useful if you could post the code you currently use pointing out where it fails. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "rir" wrote in message ... I've done some Macros in VBA in the spanish version and some users with the Engish version can't use them due to the name of the graphs. I tried to change the name of the graphs (objects) but i cannot. Any idea to solve the problem? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scale of Data Table in Graph Object | Charts and Charting in Excel | |||
| Control Bar Width with Graph Object | Charts and Charting in Excel | |||
| Chart wizard will not place (as object in) graph in same sheet | Excel Worksheet Functions | |||
| Unable to access GridLines in Microsoft Graph Object [URGENT] | Charts and Charting in Excel | |||
| how do I change the data series an an excel graph | Charts and Charting in Excel | |||
Hybrid Mode
