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?