See full list on wallstreetmojo.com. Flip /reverse data order horizontally in rows with Kutools for Excel With Kutools for Excel ’s Flip Horizontal Range tool, you can flip / reverse data order horizontally in selected rows quickly. Kutools for Excel includes more than 300 handy Excel tools. Free to try with no limitation in 30 days.
I came across a blog post called Is it just me? (software defaults), 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 Chart Busters, 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.
Reverse Order Of List Excel
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.
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. You select the same options, but they are located far apart on the dialog.
This changes the order of axis labels in our bar chart.
If you forget to make the value axis cross at the maximum category, the axis will now appear at the top of the chart. After reversing the order of the categories, the maximum category is at the bottom of the axis.
Values In Reverse Order Excel
Why Does Excel Do That, Anyway?
If we use the same data to make a column chart (line and area chart, too), the labels go from left to right, as expected.
Take another look at the column chart, and note where the origin of the axis system is located. I’ve indicated the origin with a red circle.
The values start low (at zero in this case) at the origin and increase in value as they move away from the origin. The category labels start with the first one next to the origin and later labels in the list extend further from the origin.
Now look at the bar chart and consider the origin of its axis system.
The values start low (zero) at the origin and increase in value as they move away from the origin. The category labels start with the first one next to the origin and later labels in the list extend further from the origin. Just like in the column chart.
Perhaps this is better illustrated if we remove the category data from the bar chart. In this case, Excel uses the counting numbers 1, 2, 3, etc. in place of the empty categories.
Both axes have low numbers next to the origin and higher numbers further away.
The whole problem arises because Excel follows the same axis ordering scheme for bar chart category axes as for any other axis in any other chart.
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.
This Excel tutorial explains how to sort data in alphabetical order based on two columns in Excel 2011 for Mac (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
Question: In Microsoft Excel 2011 for Mac, I'm trying to sort a chart that has 6 columns of data. I need to sort this data by 2 columns - first by column B (ie: Product column) in alphabetical order and then by column D (ie: Quantity) smallest to largest. How do I do this?
Answer: To apply this sort in Excel, highlight the data that you wish to sort. Then select the Data tab from the toolbar at the top of the screen. Then click on the Sort button and select Custom Sort from the popup menu.
Microsoft Office For Mac Free
When the Sort window appears, select the first column that you wish to sort by. In this example, we want to sort by the Product column (column B) in alphabetical order (A to Z). Then click on the + sign at the bottom left of the window.
Enter the second column that you wish to sort by. In this example, we want to sort next by the Quantity column (column D) in Smallest to Largest. Then click on the OK button.
Excel Office For Mac Reverse Row Order Status
Now when you return to the spreadsheet, the data should be sorted first by Product and then by Quantity.