Excel Charting Question

[RDMorgan]

I would like to place a reference to a calculated cell into the title of a chart. 1) is this possible and 2) how do I do it?

EX: Chart Title = "The Budget is XXXX over drawn."

Where the XXXX is the calculated result form, say, cell A1.

Thanks in advance....

 

[VoG]

You would need the complete title in a cell then try this http://www.processtrends.com/pg_chart_dynamic_chart_title.htm