| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change the name of the chart as it appears on the Chart Window
I have a workbook that has code for combobox which when executed generates a
chart on one of the sheets. Each time this code is run the chart name, as it appears on the Chart Window, changes. I want to rename this to "Chart 1". As a general question what is difference between ChartObject and Charts? Thanks and regards Farooq Sheri |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
change the name of the chart as it appears on the Chart Window
a ChartObject is a container for a chart when it is hosted on a worksheet.
When a chart is on a Chartsheet, there is no ChartObject. Activesheet.ChartObjects(1).Chart.Name = "Chart 1" -- Regards, Tom Ogilvy "Farooq Sheri" wrote: I have a workbook that has code for combobox which when executed generates a chart on one of the sheets. Each time this code is run the chart name, as it appears on the Chart Window, changes. I want to rename this to "Chart 1". As a general question what is difference between ChartObject and Charts? Thanks and regards Farooq Sheri |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
change the name of the chart as it appears on the Chart Window
thanks for the reply but I am getting "object does not support this property
or method" error Farooq "Tom Ogilvy" wrote: a ChartObject is a container for a chart when it is hosted on a worksheet. When a chart is on a Chartsheet, there is no ChartObject. Activesheet.ChartObjects(1).Chart.Name = "Chart 1" -- Regards, Tom Ogilvy "Farooq Sheri" wrote: I have a workbook that has code for combobox which when executed generates a chart on one of the sheets. Each time this code is run the chart name, as it appears on the Chart Window, changes. I want to rename this to "Chart 1". As a general question what is difference between ChartObject and Charts? Thanks and regards Farooq Sheri |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
change the name of the chart as it appears on the Chart Window
Activesheet.ChartObjects(1).Name = "Chart 1"
is probably what you want. there is, however, also a chart name: ? Activesheet.ChartObjects(1).Chart.Name Sheet1 Chart 1 -- Regards, Tom Ogilvy "Farooq Sheri" wrote: thanks for the reply but I am getting "object does not support this property or method" error Farooq "Tom Ogilvy" wrote: a ChartObject is a container for a chart when it is hosted on a worksheet. When a chart is on a Chartsheet, there is no ChartObject. Activesheet.ChartObjects(1).Chart.Name = "Chart 1" -- Regards, Tom Ogilvy "Farooq Sheri" wrote: I have a workbook that has code for combobox which when executed generates a chart on one of the sheets. Each time this code is run the chart name, as it appears on the Chart Window, changes. I want to rename this to "Chart 1". As a general question what is difference between ChartObject and Charts? Thanks and regards Farooq Sheri |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I recenter a pie chart within a chart window? | Charts and Charting in Excel | |||
| Macro to change position of chart labels on line chart | Charts and Charting in Excel | |||
| Chart Titles not showing in excel chart Window | Excel Discussion (Misc queries) | |||
| How do you change a chart window name? | Excel Discussion (Misc queries) | |||
| vc++ automation: opening chart as chart window and setting scale | Excel Programming | |||
Linear Mode
