Select the chart tile and then type the cell reference in the formula bar,
prefixed by the sheet name, such as =Sheet1!A2. To get what you want, in B2
add

="Service Calls - Sunday "&TEXT(A2,"dd-mmm-yyyy")

and the reference that cell.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Bill James" <Bill wrote in message
...
Is there a way to put a cell reference in the chart title text box? I
have
numerous charts that have a date in the title. It would be much less work
if
I can modify a date in a cell and have all the charts automatically be
updated. Example: "Service Calls - Sunday 02/03/08" would be "Service
Calls
- Sunday =A2" where cell A2 has my date. Or can this be modifiec via a
VBA
macro?