Level 1

0 points

How do I put two linear trend lines in a scatter plot with two different sets of values?

I have to set up a scatter plot for a chem lab. My scatter plot contains two different sets of data, one for pre-1982 pennies and one for post-1982 pennies. I was able to enter everything and create the scatter plot. Now I have to put linear trend lines in there but I need one for each set of data. When I want to put a linear trend line in there it creates only one for all data. Is there any way I can have two?

MacBook Pro (13-inch Mid 2012)

Posted on Sep 4, 2014 8:02 AM

22 replies

SGIII

Level 8

37,550 points

Sep 5, 2014 3:39 PM in response to l_hi

Delete the chart. Then Do the steps (which are very quick) again:

Select column B by clicking the B up top.
Hold down shift and click the D up top.
Click the chart icon in the toolbar and choose the scatter chart.
Click Edit Data References blue rectangle.
Uncheck 'Share X Values' in the drop down lower left.

l_hi Author

Level 1

0 points

Sep 5, 2014 3:44 PM in response to SGIII

I followed your steps but I still end up with the same thing that I had before. Are there any other adjustments I might have to make?

SGIII

Level 8

37,550 points

Sep 5, 2014 4:43 PM in response to l_hi

I can't think of any other adjustments. I was working from your document on Dropbox. I deleted your chart, and set up a new one following my own steps. Maybe Ian, who knows more about Numbers charts, can help. I think the sun is up in Australia now.

Yellowbox

Level 7

21,939 points

Sep 5, 2014 6:18 PM in response to l_hi

Hi I_hi,

Here is your plot from Dropbox

Add Chart Data ???? I don't know where that came from.

X axis 0 to 12 ????

Anyway, best to ignore what we don't understand and start again.

SG wrote

Delete the chart. Then Do the steps (which are very quick) again:

Select column B by clicking the B up top.
Hold down shift and click the D up top.
Click the chart icon in the toolbar and choose the scatter chart.
Click Edit Data References blue rectangle.
Uncheck 'Share X Values' in the drop down lower left.

and, Hey Presto,

I am running Numbers 3.2.2 on OS X 10.9.4

What versions are you running?

Regards,

Ian.

l_hi Author

Level 1

0 points

Sep 5, 2014 8:30 PM in response to Yellowbox

I finally got it, it is working now! Thank you so much!

Feb 9, 2015 3:49 AM in response to l_hi

I have been struggling with this for four hours. I had already figured out that the problem was that x values were shared between the multiple series of data. Now I found out that unchecking "share x values" solves everything.

This would be completely logical EXCEPT THAT IN THE DUTCH VERSION OF NUMBERS "SHARE X VALUES" IS MISTRANSLATED AS "SHOW X VALUES".

I hereby apply to Apple for a job as a Dutch translator.

SGIII

Level 8

37,550 points

Feb 9, 2015 5:32 AM in response to hanswesterbeek

hanswesterbeek wrote:

This would be completely logical EXCEPT THAT IN THE DUTCH VERSION OF NUMBERS "SHARE X VALUES" IS MISTRANSLATED AS "SHOW X VALUES".

I hereby apply to Apple for a job as a Dutch translator.

Hi hanswesterbeek,

It sounds as if you would be doing a good deed to report that mistranslation to Apple via your menu: Numbers > Provide Numbers Feedback.

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 put two linear trend lines in a scatter plot with two different sets of values?