You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

📰 Apple Fitness+ unveils an exciting lineup of new ways to stay active and mindful in 2025

Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

l_hi Author

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

Top-ranking reply

SGIII

Level 8

36,224 points

Posted on Sep 4, 2014 10:42 AM

Click a series in the chart first and then choose the Trendline option you want in the drop down under the Series tab:

Repeat for each series and you should get something like this:

View in context

22 replies

SGIII

Level 8

36,224 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

36,224 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,361 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

36,224 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.

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