Excel Chart Axis Scale Date For Mac

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: • 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 and all I want to do is swap the axes, but I cant seem to do it.

This class is perfect for accountants who use QuickBooks or have clients who use it, small business owners -- sole proprietorships and S-Corps, and administrative or executive assistants.

Often there is a need to change the data labels in your Excel 2016 graph. The procedure. Select the Chart that you have created and navigate to the Axis you want to change. Our goal is to replace the X axis with data from Date Column. Oct 24, 2016 - An Excel line chart using a Date scale has a Date-only scale. The resolution is one day, so you can't distinguish between separate times in a.