Drawing profiles using Excel

by Jack K   Last Updated January 14, 2018 12:01 PM

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?)

enter image description here

enter image description here



Related Questions






Excel graph with multiple item types

Updated April 04, 2017 00:01 AM