I use this type of setup:
In A2: Sales for the year ended
In B2: 30-Jun-02
In A3: =A2&" "&TEXT(B2,"dd mm yy")
A3 displays "Sales for the year ended 30-Jun-02" (without the apostrophes).
Please note the formula must be in a cell; it cannot be assigned to the text box. The formula for the text box references the cell containing the formula.
Put a text box on your Chart - make sure that it is "activated" and then in the formula bar type "=$A$3" (without the apostrophes).
Regards,
Mike
This message was edited by Ekim on 2002-08-26 13:26