| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting,microsoft.public.excel.programming
|
|||
|
|||
Change the assigned chart number
|
|
#2
Posted to microsoft.public.excel.charting,microsoft.public.excel.programming
|
|||
|
|||
|
Change the assigned chart number
To manually rename a chart object:
Hold the Ctrl key, and click on the chart to select it Click in the Name box, to the left of the formula bar Type a new name, or edit the existing name Press the Enter key To programmatically rename a chart object: ActiveSheet.ChartObjects("Chart 1").Name = "NewChartName" Al Eaton wrote: If you use the Macro Recorder and select several charts (in the same worksheet) in secession you can see that Excel has assigned a name to each chart such as Chart 1, Chart 2, ect.. Is there a way to rename say Chart 15 to Chart 3, assuming Chart 3 does not already exist? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.charting,microsoft.public.excel.programming
|
|||
|
|||
|
Change the assigned chart number
see
http://peltiertech.com/Excel/ChartsH...ameAChart.html "Debra Dalgleish" wrote in message ... To manually rename a chart object: Hold the Ctrl key, and click on the chart to select it Click in the Name box, to the left of the formula bar Type a new name, or edit the existing name Press the Enter key To programmatically rename a chart object: ActiveSheet.ChartObjects("Chart 1").Name = "NewChartName" Al Eaton wrote: If you use the Macro Recorder and select several charts (in the same worksheet) in secession you can see that Excel has assigned a name to each chart such as Chart 1, Chart 2, ect.. Is there a way to rename say Chart 15 to Chart 3, assuming Chart 3 does not already exist? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I print the version number assigned in SharePoint? | Excel Discussion (Misc queries) | |||
| SeriesCollection - Incorrect ColorIndex Assigned to Chart | Charts and Charting in Excel | |||
| formula to color fill a cell if number over assigned value | Excel Worksheet Functions | |||
| Assigned macros change location | Excel Discussion (Misc queries) | |||
| How do I change the invoice number assigned in Invoice template... | Excel Discussion (Misc queries) | |||
Linear Mode
