I have a line chart that has the x and y data on the opposite axes to what I
need. I can't figure out how to get my data to chart correctly. The data is
basically as follows and I need height on the y axis and Distance on the x
axis, with each distance group in a common series or line:

Height Distance1 Distance2 Distance3 etc
1 x11 x21 x31
3 x13 x23 x33
5 x15 x25 x35
8 x18 x28 x38
etc

The closest I can get is height on the x axis and distance on the y axis.

I'm sure there must be something I'm missing.

Thanks, Kris