Hello,
Is there a way to have a chart title be linked to two cells? I know it can be linked to one cell (ex. =Sheet1!$A$209), however I might have data that it in two different cells, and I cannot construct the formula. I’ve tried:
=Sheet1!$A$209 & “” & Sheet1!$A$210 and some other similar versions, which do not work.
I also tried to make a separate textbox below the title of the chart with link to the second cell, but the chart will not print that text box, as it is not part of the chart itself.
Thanks in advance!
K.