question about superscripting

G

Guest

I am using the following formula to generate a replica of the trendline
information for a scatter plot:

="y = " & TEXT(intercept,"##0.0##x") & IF(slope>0," +"," ") &
TEXT(slope,"##0.0##") & CHAR(10) & "R2 = " & TEXT(rsquared,"##0.0##"),

where intercept, slope & rsquared are calculated separately.

Is there a way to superscript the "2" in the R2 part? I cannot format as I
usually would (ctr-1 does nothing). Is there a CHAR equivalent of
superscripting? If so, what is the CHAR equivalent of undoing the
superscript afterwards?

wazooli
 

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

Similar Threads

Re : Excel VBA Charting of a Trendline, the Parameters do not Tally with the Calculations obtained b 2
Linear regression errors 1
mutiple regression help 1
LINEST with filtered data 5
Accessing values in exponential trendline equation 4
Graphing points to the 10^-19 14
semi log graphs 3
Regression through select points on a scatter plot. 3

Top