Line chart problem

Hello,
Good day. I need to make a line graph where in X -axis will be VSW% (volumatric soil water content %) and Y-axis will be soil depth. Here soil depth are negative value. I am trying to create this but failed. Can you please help me. I am attaching you the excel file. The graph may look like this.

Thanks
Kind Regards
Sohel

You need to use xy-scatter chart rather than Line chart.
Insert a xy-scatter and then use the Select Data dialog to adjust ranges used for x and y values.

Excel expects the first column to contain x values and subsequent columns y values for each series.

Andy Pope said:

You need to use xy-scatter chart rather than Line chart.
Insert a xy-scatter and then use the Select Data dialog to adjust ranges used for x and y values.

Excel expects the first column to contain x values and subsequent columns y values for each series.

Click to expand...

Thanksa