I just tried it in Excel 5.0, and it worked as advertised.

Jon Peltier wrote:
The error some people make is to type the formula as the text of the
title. You need to select the title without the cursor flashing in it
and type the = and cell reference (or click on the cell), or type the =
and cell reference in the formula bar.

And I'm sorry, I don't remember ever trying this in Excel 5.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Del Cotter wrote:

On Tue, 14 Dec 2004, in microsoft.public.excel.charting,
Nick M said:

"Patrick_KC" wrote:

"Gord Dibben" wrote:
Is there any way to use a cell reference in a chart title?
If you already have a Title, click on it to select the box. In
the formula
bar type an equal sign(=) then go select the cell you want as a
title. Hit
ENTER key.
Thanks, Gord - worked just like I wanted it to!



For some reason when i try that all i get is an equal sign in my
title. any
ideas??



You may, like me, have an older version of Excel (mine is Excel 95).
You can't put a formula in the actual title, only text, as you found out.

Not to worry, you can still make text boxes as formulas. Press F2 to
access the edit bar at the top of the screen, and type or select a
formula or cell: when you press "Enter" a new text box will be
created, usually in ten point Arial in the centre of the screen.
Format the text box just as you would the title, and reposition it,
and now you can get rid of the title!

Later versions of Excel, I understand, let you put formulae in the
title, which they should have done in the first place.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html