in the dialog for assigning ranges

=Sheetname!RangeName

or

=BookName.xls!RangeName

works for me.

--
Regards
Tom Ogilvy

"John Baker" wrote in message
...
Thanks. That works fine.

I have found that I now have another similar problem. The X and Y axis
parameters don't
appear to accept names of named ranges. Is there some other way I can deal
with variations
in the number of rows that will be used in the graph?

Best

John Baker

"Tom Ogilvy" wrote:

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).