Ask Your Question
1

trend line over multiple scatter plots

asked 2018-03-07 02:11:15 +0100

DrewS gravatar image

updated 2018-03-07 23:57:50 +0100

I have data and a graph made from that data as such:

image description

I would like to have best fit curves/lines for each of the tests in the graphs. When I double click on the chart and hit insert, the trend line is disabled.

Test_summarys.xlsx

This is the file am trying to get to work. Specifically it is the last sheet "Summary of all tests"

edit retag flag offensive close merge delete

Comments

Could you share test file without any personal or sensitive info (check File → Properties) so that it's not needed to recreate data and graph from scratch just for sake of checking what might be wrong? Thanks

Kruno gravatar imageKruno ( 2018-03-07 14:06:53 +0100 )edit

@Kruno, I added the file I an trying to get to work. There is no sensitive info, just data that is dumped from the program, its the program that generates the data that I cannot share, I see no harm in sharing this.

DrewS gravatar imageDrewS ( 2018-03-07 23:58:43 +0100 )edit

2 Answers

Sort by » oldest newest most voted
1

answered 2018-03-08 01:16:06 +0100

mikebibo gravatar image

updated 2018-03-08 01:21:53 +0100

I think the problem is the way you are trying to do it. The 'add trendline' entry on the insert menu is probably greyed out because there are multiple data series and the program wouldn't know which to use. Instead, after you select the chart, if you right-click on one of the data points, the context menu includes an option to add a trend line for that data series.

An interesting note: when one does this in Excel, the trendiness all default to black, making it difficult to know which data series they belong to. In LO Calc, the trendlines default to colours that match the existing data series. (OSX 10.11.6, LO 6.0.2, Excel 2011).

edit flag offensive delete link more

Comments

You are absolutely right. I needed to select a point for it to work for that data series, I assumed it should do it for all of them separately.

DrewS gravatar imageDrewS ( 2018-03-08 03:51:22 +0100 )edit
1

answered 2018-03-08 01:46:42 +0100

w_whalley gravatar image

Your Brute Force graph has six data series. You can insert a trend line for each series individually. But your X ranges for each series do not match the Y ranges and this distorts the graph.

If you want a single trend line covering all the data, set up a single data series with all graph size values (x values) in column b and all runtime values (y values) in column c, then do a graph.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-03-07 02:11:15 +0100

Seen: 849 times

Last updated: Mar 08 '18