Hi Charles,

Click in the title on the chart and select (highlight) whatever is in there
and then click up in the formula bar and enter = sign and then click in the
cell containing the title that you want.


--
Regards,

OssieMac


"Charles Eaves" wrote:

I am using Excel 2007.
I have a title (with a date in it) in my worksheet and it is the same on a
graph.
For my report, I always change that date on the worksheet.
how do I automatically change the title in the graph.