Swapping chart axis in Excel 2013

[SammiH]

I am trying to create a scattergraph of concentrations (x-axis) against depth (y-axis). Excel will let me create a graph where concentrations are on the y-axis and depth is on the x-axis.

Firstly, the options available to me when I open the 'select data' window, is 'Legend Entries (Series)' and 'Horizontal (Category) Labels Series'. When I try to swap the axes of the scattergraph (using the Select Data -> Switch Row/Column method I've seen suggested elsewhere on this forum), Excel moves both depth and concentrations to the 'Horizontal' box on the righthand side, and creates a new list in the 'Legend Entries (series)' box on the lefthand side: 'series 1', 'series 2', etc to 'series x'.

Help, please. I don't know what I'm doing wrong. I think it must be something simple, but after two hours of trying everything option I could find, I can't seem to change it.

 

[Momentman]

One thing i can say though is this ,excel always plots Y against X. X is taken as first column of data while Y is taken as second column, so one way could be to put the data you want on the X axis in column 1 while that for the Y axis in column 2 i.e reverse how you placed concentrations and depths on the sheet

Seecondly, after plotting the graph, when you go to DESIGN>SELECT DATA and on the left side, you will see series, click to edit the series. In series one, select the column that would be on the x-axis and in series 2, select the column you want on the Y-axis

 

[SammiH]

One thing i can say though is this ,excel always plots Y against X. X is taken as first column of data while Y is taken as second column, so one way could be to put the data you want on the X axis in column 1 while that for the Y axis in column 2 i.e reverse how you placed concentrations and depths on the sheet

Seecondly, after plotting the graph, when you go to DESIGN>SELECT DATA and on the left side, you will see series, click to edit the series. In series one, select the column that would be on the x-axis and in series 2, select the column you want on the Y-axis

Thank you for the suggestions. For anyone with a similar problem, swapping the columns around on the spreadsheet worked to swap the axes on my graph.

Unfortunately as I need to add several other columns from my spreadsheet to my x-axis, this method did not work for me. The 'Horizontal series' box would not allow the additon of new fields, and contained each data value from my 'concentrations' column as separate series.

 

[Jon Peltier]

I'm not sure what your issue is in the last paragraph. If it's not a scatter chart, you can only have one set of X values. If it's a scatter chart, each series allows unique X and Y data ranges.