I used to use the following code to activate a chart called
"LoadGraph"

ActiveSheet.ChartObjects("LoadGraph").Activate
ActiveChart.ChartArea.Select

What I can not figure out is. How I gave it the name?

It was useful when wanting to edit an existing chart to change
it's options and layout.

Another question would be.... at what point in the chart creation
can I give it the name? By default Excel uses Chart Area, but I
can not get it to activate the chart.

-Randy-