The Chart Title can contain a cell reference so, if you prefer, you can
add a title to the chart and link it to the cell with the formula.

Phil Hageman wrote:
Debra,

I see in Chart Options the Chart Title now does not exist. Does this mean
Chart Title cannot hold a formula, and to do so requires a text box? Will
the text box function/act exactly the same as Chart Title?

Phil

"Debra Dalgleish" wrote:


In another cell, e.g. J2, enter the formula:

="FORECAST THROUGH " & UPPER(TEXT(J1,"dd mmm yy"))

Select the chart
Type an equal sign, then click on the cell that contains the formula
Press the Enter key
Move and format the text box that contains the title text.

Phil Hageman wrote:

I want a chart title to say: FORCAST THROUGH 26 SEP 05. Where the date is
located in cell J1. What would the formula be?
Thanks, Phil


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html