Wilfred:

Here' a link to a post I have on dynamic titles that sounds like what you
are looking for.

http://processtrends.com/pg_chart_dy...hart_title.htm

I use a text box and link the box to the chart by activating chart,
entering "=" in formula bar then pointing to source cell.

You can format the text and place where you want on the chart. As an aside,
I prefer this text box approach to using Excel's chart title option. I find
the chart title option takes up more space than is necessary for the title.

As the source cell is updated, the title will automatically be updated.

One last point, you can use a concatenation formula to make your source cell
update as your week changes.

Your source title could be = "Sales Activity for Week Ending " &
Text(A1,"mmmm d, yyyy"). Substitute the actual date cell for A1 in this
example.


...Kelly





"Wilfred" wrote in message
. ..
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?