How do I move the trend line equation and R^2 value in my chart?

Hi, I am using numbers for school. I have created a scatter plot and have added a trend line. I have also added the trend line equation and R^2 value. Numbers automatically puts them in the top left corner of the screen. This gets in the way of my plot. Is there a way that I can move this? I have tried and tried. You would think that it would be simple. This is pretty frustrating. It is very easy in Excel. Thanks for any help.

MacBook Pro, Mac OS X (10.5.8)

Posted on Oct 2, 2014 4:51 PM

Reply
6 replies

Oct 3, 2014 5:38 AM in response to SamAdam21

Funny. I cannot read. MOVE and remove are very different. I meant to add the best way is to remove them from showing and then type then in a text box which can place as needed OR

create a single table cell which computes the equation for you like this:

User uploaded file

For the slope and intercept:

A1="y = "&ROUND(INDEX(LINEST(Table 1::B,Table 1::A,1, 1),1, 1), 4)&"x "&IF(ROUND(INDEX(LINEST(Table 1::B,Table 1::A,1, 1),1, 2), 4)<0, " - ", "+ ")&ABS(ROUND(INDEX(LINEST(Table 1::B,Table 1::A,1, 1),1, 2), 4)


In the table below this (for the R squared value):

A1="R squared = "&ROUND(INDEX(LINEST(Table 1::B,Table 1::A,1, 1),3, 1), 4


now you can hide the information on the chart an place these tables as needed

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How do I move the trend line equation and R^2 value in my chart?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.