Posted By: Anonymous
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.
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.