Swap x and y axis without manually swapping values

flux picture flux · Aug 14, 2014 · Viewed 558.9k times · Source

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.

Answer

anon picture anon · Sep 7, 2017

-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