[Solved] Plotting multiple trendlines on a graph

Discuss the spreadsheet application
Post Reply
Jobediah
Posts: 2
Joined: Tue Aug 28, 2012 12:53 am

[Solved] Plotting multiple trendlines on a graph

Post by Jobediah »

http://www.impactaging.com/papers/v3/n4 ... igure3.jpg

The link above shows what I'd like to do, but I can't figure it out. I'd like two trend lines for two groups on one graph (arm span by height for the sexes separately). This is one of my favorite analyses (ANCOVA) and my class will learn much more if I can show them their data properly labelled and organized. I can make a regular scatterplot with a single group, so I only need help making the two groups with different color points and separate lines.

Can anyone help? I'm running the latest version of OpenOffice on a new mac powerbook running 10.8.

Thanks in advance.
Last edited by Jobediah on Tue Aug 28, 2012 5:12 pm, edited 1 time in total.
Tobias Landberg OpenOffice 3.4.0 on MacOS 10.8
FJCC
Moderator
Posts: 9540
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: plotting multiple trendlines on a graph

Post by FJCC »

One way to do it is to put all of the x values in a single column and the y values in two columns. See the attached file.
Attachments
TwoYseries.ods
(14.91 KiB) Downloaded 715 times
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Jobediah
Posts: 2
Joined: Tue Aug 28, 2012 12:53 am

Re: plotting multiple trendlines on a graph

Post by Jobediah »

Sweet, thanks FJCC! That works for me.
I knew leaving MSOffice behind was going to make my life better :)
Thanks again, I'm off to the data races...
Tobias Landberg OpenOffice 3.4.0 on MacOS 10.8
Post Reply