Rename Charts

[Rene]

I create a series of charts in a Sheet, every time Excel
give a name to the chart. When seeing the chart window will
look like [name of the workbook.xls]Chart 1, then I create
a macro to print a set of Charts.
The problem I have is on how to rename the chart name give
by Excel, because when I create other chart on a new
workbook excel assign a consecutive number for the new
chart.

Thanks

Rene

 

[Jon Peltier]

http://peltiertech.com/Excel/ChartsHowTo/NameAChart.html

- Jon