G
Gene Augustin
I have a scatter diagram. I am able to use "calculated text" for the legend.
In cell P7 I have =TEXTBW&"°" where BW is a named cell.
I enter into the series name ='H-PORT [email protected]'!$P$7
And the series name in the legend becomes 0.900°
If the numeric value changes, so does the series name.
How can I use calculated text for the chart title?
In cell P7 I have =TEXTBW&"°" where BW is a named cell.
I enter into the series name ='H-PORT [email protected]'!$P$7
And the series name in the legend becomes 0.900°
If the numeric value changes, so does the series name.
How can I use calculated text for the chart title?