Chart Title

[TKeefe]

I'm looking for a way to make a dynamic chart Title in Excel. I'm trying right now to get it to display something like "PGW at 70 deg F" With PGW coming from cell A1, and the 70 coming from cell B1. Is there any way to be able make a function that allows me to use cell A1, then use text, then cell B2, and then go back to finishing it in text?

[JieJenn]

https://support.office.com/en-za/art...2-b10c62fca6f5

[TKeefe]

Already had that part. But I keep getting error messages, when trying to go from =Sheet!A1, "text", Sheet"A2, "text"

[JieJenn]

Can you post your file?

[TKeefe]

TitleHelp.PNG Here is a image of just what I'm trying do. I just need it so that the header will change if the info in cells B2 and B3 end up changing. Let me know if the image is working.

[MrShorty]

Pictures are not as helpful as an actual spreadsheet.

That said, I think the usual expectation would be to have your =CONCATENATE() or ="string1 "&reference&" string2" type formula in a cell in the spreadsheet, then link to that cell in your chart title. So, perhaps cell D2 contains the formula =CONCATENATE(B2," ",B3), then your chart title references ='editable charts'!$D$2

[TKeefe]

That worked perfectly. Thanks both of you.