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?