I have the data table as shown below.

Y-loc x1-value x2-value
0.0 0.0 0.0
0.2 50.0 55.0
0.4 65.0 75.0
...
...
2.0 0.0 0.0

When I plot it in Excel (Scatter Plot), I get the curves with combined range of x1-value and x2-value on the Y-axis, and the Y-loc on the X-axis. What I really want is to have the curves turned on their side, with two y-scales, one on the left showing 0.0 to 2.0 in increments of 0.2, and the y-scale on the right showing the range of values at X-locations x1 and x2.

Does someone know how I can do this (in Excel?)

2

1 Answer

You need to use the ‘X-Y Scatter Plot’ type, and then switch the X and Y axes.
For that switch, either select them already inverted when creating the graph, or in the existing graph, click on the red / blue line, and edit the shown formula in the formula bar: it will have three parameters, which mean Title, X-data, and Y-data; simple exchange the second and third parameters.

6

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy