Swap x and y axis without manually swapping values

Question

So I have a set of data that has conditional formatting  Basically it s a set of photometric measurements of stars that I want to put on a chart with different colors for stars in different ranges of Color Index  basically color them by their spectral class   So my data looks like this  Stars Data   The first column is the Absolute Magnitude  M  of the star - I want this on the X axis  The rest of the columns are the different spectral classes that have values from another column only in a particular range  - I want these on the Y axis  Currently the chart looks like this and all I want to do is swap the axes  but I cant seem to do it

User · Answer

-Right click on either axis   -Click  Select Data      -Then Press the  Edit  button  -Copy the  Series X values  to the  Series Y values  and vise versa     finally hit ok  I found this answer on this youtube video https   www youtube com watch v xLKIWWIWltE

User · Answer

Microsoft Excel for Mac 2011 v 14 5 9   Click on the chart Press the  Switch Plot  button under the  Charts  tab

User · Answer

Click somewhere on the chart to select it   You should now see 3 new tabs appear at the top of the screen called  Design    Layout  and  Format    Click on the  Design  tab  There will be a button called  Switch Row Column  within the  data  group  click it

User · Answer

In Numbers  click on the chart   Then in the BOTTOM LEFT corner there is the the option to either  Plot Rows as Series or  Plot Columns as series

User · Answer

Using Excel 2010 x64  XY plot  I could not see no tabs  it is late and I am probably tired blind  250 limit    Here is what worked for me   Swap the data columns  to end with X data in column A and Y data in column B   My original data had Y data in column A and X data in column B  and the graph was rotated 90deg clockwise  I was suffering  Then it hit me  an Excel XY plot literally wants  x y  pairs  i e  X data in first column and Y data in second column  But it does not tell you this right away  For me an XY plot means Y f X  plotted

[excel] Swap x and y axis without manually swapping values

Examples related to excel

Examples related to charts

Examples related to excel-2010

Examples related to axes