Create a hard coded title.

then select it

go to the formula bar, put in

=Sheet1!$B$3


for example.

In code:
With ActiveChart.ChartTitle
.HasTitle = True
.Text = "=Sheet1!R3C2"
End With

The reference must be in R1C1 (at least in xl97 and xl2000).



--
Regards,
Tom Ogilvy

"John Baker" wrote in message
...
Hi:

I have a problem with Excel Charts (Excel 2000 Window 98)

I am trying to set up one basic chart (a simple line chart) that will
accept different
data sets of the same type of data. Specifically two columns of dates and
values, however
the number of items in a column will vary, so the number of points in the
data will vary.
I plan to deal with this by giving the two columns a name and redefining
the cells
included in the name each time we open the chart.

A bigger problem (strange as it may seem ) is the chart label. I want to
have the chart
label in a cell, and the chart references the cell for its label. I have a
Manual (Excel5
Super Book) and it refers to ways that this can be done but they don't
work in Excell
2000.

Can someone give me some pointers on this please.

Thanks in advance

John Baker