chart title text

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top