Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Naming charts on own sheet
Hi.
I have a series of charts (which are all contained on their own sheets). I need to name each of the charts (as they will be used by someone else in a macro). I have tried clicking on them and also pressing shift before clicking on them, and I am not able to change the name in the name combo box. Can anyone advise me of how I can change the names. Thanks for your help. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Naming charts on own sheet
Hi,
If you have chart sheets you can change the name by simply changing the sheet tab name. What you described is the method used on chartobjects, which are usually on a worksheet. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "BoRed79" wrote in message ... Hi. I have a series of charts (which are all contained on their own sheets). I need to name each of the charts (as they will be used by someone else in a macro). I have tried clicking on them and also pressing shift before clicking on them, and I am not able to change the name in the name combo box. Can anyone advise me of how I can change the names. Thanks for your help. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Naming charts on own sheet
Will the chart sheets be able to be used in a Macro (by referring to the
sheet tab name) or would they need to be chart objects, so that they can be named?? "Andy Pope" wrote: Hi, If you have chart sheets you can change the name by simply changing the sheet tab name. What you described is the method used on chartobjects, which are usually on a worksheet. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "BoRed79" wrote in message ... Hi. I have a series of charts (which are all contained on their own sheets). I need to name each of the charts (as they will be used by someone else in a macro). I have tried clicking on them and also pressing shift before clicking on them, and I am not able to change the name in the name combo box. Can anyone advise me of how I can change the names. Thanks for your help. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Naming charts on own sheet
You can access both types using the following style of code.
' chart sheet With ActiveWorkbook.Charts("Chart1") .HasTitle = True .ChartTitle.Text = "Chart Sheet" End With ' worksheet chart object With ActiveWorkbook.Worksheets("Sheet1") With .ChartObjects("Chart 1").Chart .HasTitle = True .ChartTitle.Text = "Chart Object" End With End With Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "BoRed79" wrote in message ... Will the chart sheets be able to be used in a Macro (by referring to the sheet tab name) or would they need to be chart objects, so that they can be named?? "Andy Pope" wrote: Hi, If you have chart sheets you can change the name by simply changing the sheet tab name. What you described is the method used on chartobjects, which are usually on a worksheet. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "BoRed79" wrote in message ... Hi. I have a series of charts (which are all contained on their own sheets). I need to name each of the charts (as they will be used by someone else in a macro). I have tried clicking on them and also pressing shift before clicking on them, and I am not able to change the name in the name combo box. Can anyone advise me of how I can change the names. Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Naming a sheet | Excel Discussion (Misc queries) | |||
naming sheet tab | Excel Worksheet Functions | |||
Naming Sheet | Excel Discussion (Misc queries) | |||
Workbook "Sheet" Naming | Excel Discussion (Misc queries) | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |