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.
5 Answers
-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
1Click 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.
Microsoft Excel for Mac 2011 v 14.5.9
- Click on the chart
- Press the "Switch Plot" button under the "Charts" tab
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.
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'
