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

Multiple Y-axis labels in Excel 2010 line chart

Updated April 16, 2018 16:01 PM

Stacked Bar Graph in Excel or Matlab

Updated April 08, 2018 08:01 AM