Complex scatter chart

[Mtes]

Hello.

I need to make scatter chart with line which would use 3 sets of data. Problem is that i can't make the chart to look like the way i need. Either it consists only of 1 set of data, or the X and Y axes are swapped.

I'm sorry, i can't explain my problem better with words, so i added attachment with input data, goal and my attempts to make this chart.

Thanks for help.

[Andy Pope]

Excel expects the first row/column to contain the X values and 2nd and subsequent row/columns to contain the Y values.

You data is the exact opposite so this mean you will need to manually set the data ranges for the x and y values of each series. You can do this via the Select Data dialog

[Mtes]

Thank you very much, i didn't know it was possible to adjust data for each series separately.