Ask Your Question

Revision history [back]

You say that you want "a single line showing the relation between the two columns." I have to say that your data, taken in two columns as x and y, does not have a linear relationship, so a single line might or might not have much meaning, depending on the source of the data.
I plotted your data as a scatter diagram without interconnecting lines, just data points, and have added a "trend line" which is linear. To add a trend line, just put the chart in edit mode, then click on one data point to select all of them, then right click on the point to get a menu of options. Select "trend line" or other options.
I will try to attach the result (but bear with me as I have never done this before). Ask-test.ods

You say that you want "a single line showing the relation between the two columns." I have to say that your data, taken in two columns as x and y, does not have a linear relationship, so a single line might or might not have much meaning, depending on the source of the data.
I plotted your data as a scatter diagram without interconnecting lines, just data points, and have added a "trend line" which is linear. To add a trend line, just put the chart in edit mode, then click on one data point to select all of them, then right click on the point to get a menu of options. Select "trend line" or other options.
I will try to attach the result (but bear with me as I have never done this before). Ask-test.ods Sorry, didn't work.

You say that you want "a single line showing the relation between the two columns." I have to say that your data, taken in two columns as x and y, does not have a linear relationship, so a single line might or might not have much meaning, depending on the source of the data.
I plotted your data as a scatter diagram without interconnecting lines, just data points, and have added a "trend line" which is linear. To add a trend line, just put the chart in edit mode, then click on one data point to select all of them, then right click on the point to get a menu of options. Select "trend line" or other options.
I will try to attach the result (but bear with me as I have never done this before). Ask-test.odsaskLO-test.png Sorry, didn't work.

You say that you want "a single line showing the relation between the two columns." I have to say that your data, taken in two columns as x and y, does not have a linear relationship, so a single line might or might not have much meaning, depending on the source of the data.
I plotted your data as a scatter diagram without interconnecting lines, just data points, and have added a "trend line" which is linear. To add a trend line, just put the chart in edit mode, then click on one data point to select all of them, then right click on the point to get a menu of options. Select "trend line" or other options.
I will try to attach the result (but bear with me as I have never done this before). askLO-test.png Is that what you had in mind?

click to hide/show revision 5
No.5 Revision

You say that you want "a single line showing the relation between the two columns." I have to say that your data, taken in two columns as x and y, does not have a linear relationship, so a single line might or might not have much meaning, depending on the source of the data.
data.

I plotted your data as a scatter diagram without interconnecting lines, just data points, and have added a "trend line" which is linear. To add a trend line, just put the chart in edit mode, then click on one data point to select all of them, then right click on the point to get a menu of options. Select "trend line" or other options.
options.

I will try to attach the result (but bear with me as I have never done this before). askLO-test.pngbefore).

askLO-test.png

Is that what you had in mind?