Randy -

You can name a chart this way:

Manually - Existing Chart:
Select a cell. Hold Shift or Ctrl while clicking on the chart. The
chart has white handles, not black (handles are those little squares on
the corners and midpoints of the edges). Click in the Name Box (above
the top left visible cell, to the left of the Formula Bar), where it
probably says something like "Chart 3", and type whatever name you want,
and press Enter.

VBA - Active Chart:
ActiveChart.Parent.Name = "Name of this Chart"

VBA - Any Existing Chart:
ActiveSheet.ChartObjects(3) = "Name of this Chart"

VBA - While Creating a New Chart:
If you're adding a chart (sheet) then locating it on a worksheet:

Charts.Add
ActiveChart.ChartType = xlXYScatterLines
ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("A3:G14")
ActiveChart.Location Whe=xlLocationAsObject, Name:="Sheet1"
ActiveChart.Parent.Name = "Name of this Chart"

If you're adding an embedded chart to a worksheet:

With ActiveSheet.ChartObjects.Add _
(Left:=100, Width:=375, Top:=75, Height:=225)
With .Chart
.ChartType = xlXYScatterLines
.SetSourceData Source:=Sheets("Sheet1").Range("A3:G14")
.Parent.Name = "Name of this Chart"
End With
End With

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Randal W. Hozeski wrote:

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-