add date to a chart title?

[neowok]

I have a chart on a sheet which is printed via a button and a macro s
tha only the chart is printed and not the entire sheet (but the char
has to be ON a sheet because it goes with a table).

What I need to do is add the current date to the end of the chart titl
after the text "Date: " which comes at the end of the title, an
overwrite any existing date there. This way it will update the date o
the title every day without user intervention.

Thank

 

[TroyW]

A solution using only worksheet formulas is possible. For example in cell A1
on the first worksheet create a formula as follows:

A1: ="This is my chart title Date: "&TEXT(NOW(),"yyyy-mm-dd")

Then click on the chart and select the chart title to make it the active
selection. In the formula bar type: =Sheet1!A1 and hit enter (change
Sheet1 to whatever your sheet's name is). The title should change to value
in cell A1. Each time the worksheet is recalculated the value in cell A1
(and the chart) will be updated.

Troy

 

[neowok]

ok thanks. that worked fine