Geek Answers Handbook

Swap the x and y axes without manually changing values

So, I have a dataset that have conditional formatting. Basically, this is a set of photometric measurements of stars that I want to plot on a graph with different colors for stars in different ranges of the color index (basically, their color according to their spectral class). Therefore, my data looks like this: Star data

  • The first column is the absolute magnitude (M) of the star - I want this on the X axis
  • The remaining columns represent various spectral classes that have values ​​from another column only in a certain range. - I want them on the y axis.
  • The chart currently looks like this , and all I want to do is swap the axes, but I can't do it.
+4
source share
4 answers

  • Click somewhere on the chart to select it.

  • You should now see 3 new tabs at the top of the screen called Design , Layout , and Format .

  • Click the Design tab .

  • In the " data " group, a button will appear with the name " Row / Column of the switch ).

+8
source

Microsoft Excel for Mac 2011 v 14.5.9

  • Click on chart
  • Click the "Switch Plot" button on the "Charts" tab.
+2
source

Excel 2010 x64. XY: (, , , , 250 ?). :

, X_data A Y_data B.

Y_data A X_data B, 90 . . : Excel XY {x,y}, X_data Y_data . . XY Y=f(X).

+1

-

- " ..."

-Then ""

-Copy " X" " Y"   , ok

YouTube https://www.youtube.com/watch?v=xLKIWWIWltE

+1

More articles:


All Articles