Once you have the title on the chart, select it, then go to the formula bar
and put in the formula

=Sheet1!A1

Now when you change the text in A1 of Sheet1, the chart title will change.

Not sure that was covered in the link provided.

--
Regards,
Tom Ogilvy

"pronto " wrote in message
...
Dont know if this has been asked before but, how do you make the title
of a chart dynamic? I want to control the title in a cell in the sense
that if i change the cell text, it would update the title in the chart.
I want to avoid clicking and editing the chart title every time.

Any help would be appreciated.


---
Message posted from http://www.ExcelForum.com/