Oct 28, 2018  Go to the Format tab, and in the dropdown box at the top left of your Ribbon that says Chart Area, and select Vertical (Value) Axis. Next click the Format Selection button directly beneath the dropdown list to open Format Axis Options. I really like the blog! My issue is with the added data table. I have the axis at the top (which I like) and I reversed my order for the left access (Jan through Oct with Jan at the top), but when I added the data table at the bottom, the months are backward. Click the axis for the categories, values, or series whose plotting order you want to change. On the Format menu, click Selected Axis, and then click the Scale tab. Note Selected Axis is only available on the Format menu when a data series is selected. Excel for Office 365 for Mac Excel 2019 for Mac Excel 2016 for Mac More. Excel can recommend charts for you. The chart it recommends depends on how you’ve arranged the data in your worksheet. Transpose your source data between the X and Y axis and paste the transposed data in a new location. Then you can use the transposed data to.

Then selecting the option under “Axis Options” > “Axis position”. There are many, many options for formatting various parts of a chart these days, and I just couldn’t figure out the right piece to select. Thanks again!

The Problem Let’s use some very simple data to illustrate the problem. Let’s make a simple bar chart. The labels were sorted from top down in the worksheet, but they appear from bottom up along the chart axis. The Fix It’s easy, if tedious, to correct the order of category axis labels. Select the axis, press Ctrl+1 (numeral one), the universal shortcut in Excel for Format This Object, and in Excel 2003 the following dialog appears. The fix is simple: check the two boxes for Categories in reverse order and Value (Y) axis crosses at maximum category. The protocol in Excel 2007 is the same, except the dialog looks a little different.

• Under Axis Options, click Fixed for Base Unit and then, in the Base Unit box, click Days, Months, or Years.

I came across a blog post called, which asks the age-old question, Why Are My Excel Bar Chart Categories Backwards? The post was in a new blog by Alex Kerin of Data Driven Consulting. Alex works on projects in analytics and dashboarding. I have been asked this question a number of times, and being a founding member of, of course I know the answer. I’ve answered the question a number of times, but if I answer it here, it will become available for the ages. I describe the problem and how to correct it. If you are really interested, I finish with an explanation of why this happens.

This describes the mechanics of axis label ordering. But, 99% of the time, a user expects the axis labels to go in the same order top to bottom as in the data source. Why Are My Excel Bar Chart Categories Backwards? Is still a valid question: Why can’t bar chart categories automatically be reversed? Alternatively, why can’t the options for a bar chart’s category axis default to: Works for me. Really, why can’t the “column” and “bar” chart types be abolished altogether, in favour of a “rotate by 90°” option available for all chart types? The axis would still have to be moved to the bottom for those who like it at the bottom, but at least the logic will make sense to users.

Please remember that it's not possible to reverse the plotting order of values in a radar chart. Reverse the plotting order of data series in a 3-D chart If you have a column or line chart with the third axis, which shows some columns (lines) in front of others, you can change the plotting order of data series so that large 3-D data markers do not overlap smaller ones. You can also use the below steps to create two or more charts for showing all values from the legend. • Right-click on the Depth (Series) Axis on the chart and select the Format Axis menu item. • You will get the Format Axis pane open. Tick the Series in reverse order checkbox to see the columns or lines flip.

To turn a row into a column, you follow the same procedure. You can even transpose a block of data, which will turn the entire selection by 90 degrees. Flipping Cells in Excel Rows To flip all of the cells in an Excel row, you need to combine the previous two steps. Because Microsoft Excel doesn’t support sorting rows, you’ll need to first turn the row into a column by using the instructions for transposing above. Once the row has been turned into a column, you can use the instructions for flipping the values in a column. After you’ve reversed the column, copy and paste it using Paste Special and Transpose. It’s a rather roundabout way to get it done, but it works! Microsoft office 2016 for mac (wah download).