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" wrote in message ...
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