I have a workbook with one data sheet and several charts which represent
weekly activity. I want to be able to pick up the title of the charts from
the spreadsheet, e.g. "Sales Activity for Week Ending April 7, 2006". This
title information is contained in a cell in the spreadsheet.

How do I get it to display at the top of each chart without having to
manually type it in the title area under Chart Options?