Chart Object Name

Excel assigns a name to each new chart object on a
worksheet as they are created (Chart 1, Chart 2, ...).
If a chart is deleted the next chart created is assigned
the next sequential number, so if the last chart built
was "Chart 7" and you delete it and add another chart, the
next chart is assigned "Chart 8." I would like to
rename "Chart 8" to "Chart 7." Is there any way to
accomplish this?

Thanks,

LB

To manually rename a chart object:

1. Hold the Ctrl key, and click on the chart to select it
2. Click in the Name box, to the left of the formula bar
3. Type a new name, or edit the existing name
4. Press the Enter key

LB wrote:
> Excel assigns a name to each new chart object on a
> worksheet as they are created (Chart 1, Chart 2, ...).
> If a chart is deleted the next chart created is assigned
> the next sequential number, so if the last chart built
> was "Chart 7" and you delete it and add another chart, the
> next chart is assigned "Chart 8." I would like to
> rename "Chart 8" to "Chart 7." Is there any way to
> accomplish this?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hello,

I know how to do this using vba:

Sub renameChart()

ActiveChart.Parent.Name = "Chart 7"

End Sub

Highlight the chart in question and run this code.

HTH,
Raj

AnalysisWorks Inc
Evidence-Based Analytic Consulting
www.analysisworks.net

Download a free Excel Box Plot add-in:
http://www.analysisworks.net/downloads.htm#BoxPlotPro

"LB" <lb1959@txmail.sbc.com> wrote in message news:<0fb701c38139$e38e0400$a001280a@phx.gbl>...
> Excel assigns a name to each new chart object on a
> worksheet as they are created (Chart 1, Chart 2, ...).
> If a chart is deleted the next chart created is assigned
> the next sequential number, so if the last chart built
> was "Chart 7" and you delete it and add another chart, the
> next chart is assigned "Chart 8." I would like to
> rename "Chart 8" to "Chart 7." Is there any way to
> accomplish this?
>
> Thanks,
>
> LB

Sorry, I missed a part in the vba code I sent you. It should be this:

Sub renameChart()

Dim nm As String

nm = ActiveSheet.Name

ActiveChart.Parent.Name = "Chart 7"

ActiveSheet.Name = nm

End Sub

HTH,
Raj

"LB" <lb1959@txmail.sbc.com> wrote in message news:<0fb701c38139$e38e0400$a001280a@phx.gbl>...
> Excel assigns a name to each new chart object on a
> worksheet as they are created (Chart 1, Chart 2, ...).
> If a chart is deleted the next chart created is assigned
> the next sequential number, so if the last chart built
> was "Chart 7" and you delete it and add another chart, the
> next chart is assigned "Chart 8." I would like to
> rename "Chart 8" to "Chart 7." Is there any way to
> accomplish this?
>
> Thanks,
>
> LB

Hi Raj -

Actually, your first one was fine. The extra lines seem to serve no
purpose.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Raj Singh wrote:
> Sorry, I missed a part in the vba code I sent you. It should be this:
>
> Sub renameChart()
>
> Dim nm As String
>
> nm = ActiveSheet.Name
>
> ActiveChart.Parent.Name = "Chart 7"
>
> ActiveSheet.Name = nm
>
> End Sub
>
> HTH,
> Raj
>
> "LB" <lb1959@txmail.sbc.com> wrote in message news:<0fb701c38139$e38e0400$a001280a@phx.gbl>...
>
>>Excel assigns a name to each new chart object on a
>>worksheet as they are created (Chart 1, Chart 2, ...).
>>If a chart is deleted the next chart created is assigned
>>the next sequential number, so if the last chart built
>>was "Chart 7" and you delete it and add another chart, the
>>next chart is assigned "Chart 8." I would like to
>>rename "Chart 8" to "Chart 7." Is there any way to
>>accomplish this?
>>
>>Thanks,
>>
>>LB
>