CODEWITHSUNDEEP
excelexcel-formulaexcel-charts
DrWhat
DrWhat

Reputation: 2490

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.

Upvotes: 1

Views: 248

Answers (2)

DDover
DDover

Reputation: 1

I used the Alt-Enter key to insert a LF/CR within the hard-coded text string to make my title appear as 2 lines on the chart.

Upvotes: 0

DrWhat
DrWhat

Reputation: 2490

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").

Upvotes: 1

Related Questions