Put the formula that builds the desired title text into a cell, then select
the text element (it works for chart title, axis titles, data labels, and
shapes), click in the formula bar and type =, then click on the cell. The
formula bar should now look something like:

=Sheet1!$A$1

but with the appropriate sheet and cell address.

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


"doofy" wrote in message
...
Is it possible to include a variable/cell link in the title of a chart?

My client is wanting the current date in each report run to show up in the
chart title, and doing it by hand each time is a pain.