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????