Thanks, but when I try to record a macro to re-name this, I don't know where
the "Chart1" is stored.
If I record a macro to delete the chart anmd view this macro, The macro sees
Chart1, but if I create again it will be Chart2??

"bj" wrote:

If you are making the gapohs onn their own sheets, They must have different
names.
if not you can change the title inthe macro to what you want it to be.
record a macro where you change the name of a chart tto find the format and
in the main macro just rename the chart.

"John" wrote:

I'm writring macros to create graphs & pivot tables, but every time I create
a graph, the lable name changes.
Ie Chart1 to Chart2.

Is there a way tohave a constant name for each graph????