[SOLVED] Excel Chart title will not accept a date concatonated to a string

Excel Chart title will not accept a date concatonated to a string

I'm trying to include a date in my excel chart title by putting a formula inside the title formula box:

="Some text "&TEXT(NOW(),"mmm dd")

I've tried putting the date into a cell, and referencing the cell, but that doesn't work:

="Some text "&TEXT(Statistik!$H$26,"mmm dd")

Strangely, I can put a date into the chart title:

=Statistik!$H$26

But as soon as I add text ("eg "&), it gives me an error message that there is something wrong in the formula. If I paste the same formula into a cell, it works fine. =Concatonate doesn't work either.

Solution

All credit to Rory's comment:

Put the whole formula into a cell, then just refer to that cell.

Concatenation within the title cell of the excel chart does not work. The title cell needs to be a single reference to another cell, e.g., =A1, in which any concatenation occurs, e.g., ="Some text "&TEXT(Statistik!$H$26,"mmm dd").