Setup Chart name
 

I created a bunch of charts of a sheet and I noticed that you can setup a
name per chart. I tried to do it from the chart properties menu but was not
able to find it. Where can I set the name of a chart so I can refer to it in
my VBA as "piechart" or "trendchart".

Thanks

Setup Chart name
 

Select the chart and enter a name in the "name" textbox.

Tim

"matelot" wrote in message ...
I created a bunch of charts of a sheet and I noticed that you can setup a
name per chart. I tried to do it from the chart properties menu but was not
able to find it. Where can I set the name of a chart so I can refer to it in
my VBA as "piechart" or "trendchart".

Thanks

Setup Chart name
 

One way
Hold down the shift keyselect the chart edgeyou will see chart1 or another
number in the NAME box to the left of the formula box type in the desired
name.

--
Don Guillett
SalesAid Software

"matelot" wrote in message
...
I created a bunch of charts of a sheet and I noticed that you can setup a
name per chart. I tried to do it from the chart properties menu but was
not
able to find it. Where can I set the name of a chart so I can refer to it
in
my VBA as "piechart" or "trendchart".

Thanks