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