Hi,

In the linked cell enter the formula

=This is the report for :"&TEXT(TODAY(),"MMMM YYYY")

Then link as described,
Shane Devenshire

"Kent McPherson" wrote in message
...
Andy, thanks. I'm not sure this will solve my problem. I should have been
more specific. I have a title in a chart that says essentially "This is
the report for May 2007". I have several charts in this file that all
have similar titles with the month and year included. I'd like to leave
all the text alone except the month and year and fill those in from
another cell in the sheet somewhere. I know I can do string concatenation
in a cell but I'm not sure how to do it in a chart title or even if it can
be done.

"Andy Pope" wrote in message
...
Hi,

You can link the chart title to a cell.
Select the chart title object and then in the formula bar type = and
click the cell to link to.
You should then have a full cell reference formula, something like,

=Sheet1!$A$1

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Kent McPherson" wrote in message
...
I have a spreadsheet I update monthly. Is it possible to have the charts
update the month in the chart title automatically if I have the month in
a cell in the sheet somewhere? Or would have to do this with a macro?