Excel. Switch x and y axes

Question

Hello assembled genii !

I have a very short range of 10 measurements I want to display as a line graph.  When I select the data and 'insert line graph' Excel automatically makes my measurements the Y axis so it displays the graph horizontally.  Even if I change the way the measurements are recorded on the page (i.e. written across the page instead of down the page) it still makes the data the Y axis and displays the graph horizontally. 

I want to make the measurements the X axis so it rotates the line ninety degrees and displays vertically.  Can I do this?  I searched help but unless you know the exact phrase to ask, help is unhelpful. 

It seems such a simple thing to want to do, swap x and y data but I just can't see how to do it??

I work on a server so I don't know the exact version of Excel it is, 2010 I guess but the worksheet is created as a Excel 97-2003 .

Thanks in advance

John

Answer 1

Use a Scatter chart instead of a Line chart.

A Scatter chart has XY data which can be exchanged, a Line chart has Y data and categories data which is shown on the X axis always.

Andreas.

Answer 2

Thank you Andreas,

That did it.  Can't really see why Microsoft didn't include that as a standard function on every chart.  It would be quite useful I would think.

Thanks again

John