Plot 2 data columns against each other - not time related [closed]
I have two data columns which I would like to compare on a chart. Say current and voltage. I do not want a stacked chart. When I use a scatter chart, I get a jumble of connected lines. What I want is a single line showing the relation between the two columns.
EDIT:
Thanks for your suggestion [editor's note: referring to @Jim K's answer] but the current column is ordered like a time series. If the current column were not in numeric order then I don't think it will work.
Here is a copy of some of my data.
33 26
34 29
56 32
47 30
33 33
18 24
39 30
41 24
28 30
37 30
34 28
32 28
41 26
27 26
25 26
32 27
14 18
39 24
I would copy my scatter chart but it does not seem to copy.
This might be one solution : When you choose a scatter chart, choose the one without lines (just shows the data points). Then add a "trend line" to the chart, to show the relationship between the x and y data.
Please provide some example data. If there is a simple relationship between current and voltage, such as exponential, then the solution in my answer should work.
Ther is not (not even approximately) a function-like dependence in the data. Left the values 32, 33, 34, 39 and 41 occur twice, and at least in two cases the associated right values are very different. If you want to get a "single line", basically a trendline out of this, you need to predefine a model (space of functions) to search for the approximating one in. Linear? Logarithmic? Whatever?
I know but I see my data as linked pairs. There will be a relationship but there are other factors affecting the pairs. I am interested in trying to assess these factors so a graphical display might throw some light on the problem/challenge
So you have a real-world curve-fitting problem in three or more variables but for which you have measurements of only two (x and y). Real-world data is never tidy. If you can control at least one of the other variables, say z, perhaps the comments and answers here so far will enable you to measure and plot your x and y values for z=z1, then to measure and plot x and y again for z=z2, again for z=z3, and so on, until the relationship you are looking for becomes clear.