To post as a guest, your comment is unpublished.· 2 years agoClick "categories in reverse order" to fix the order problem, then click "value (Y) axis crosses at maximum category" to put the axis at the bottom.
These two together will make horizontal bar charts work the way any normal human would want... :-)
To post as a guest, your comment is unpublished.· 10 days agoYou're the best, thanks!
To post as a guest, your comment is unpublished.· 6 months agoDouble Thanks Sandy.
Why on Earth am I formatting the Horizontal Axis in the Vertical Axis Format Properties Microsoft?!?!?!?! I NEVER would have figured this out without Sandy.
To post as a guest, your comment is unpublished.· 1 years agoThanks Sandy
How to reverse axis order in Excel?
Sometimes, you may need to reverse axis order in a chart. For example, in a bar chart, compared with the data, the axis order is reversed in default, in this case, you may want to reverse the axis order to meet the data order as show as below. Now this tutorial will tell you how to reverse the axis order quickly in Excel.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
There is an option in Format Axis dialog for reversing the axis order.
1. Right click the y axis you want to reverse, and select Format Axis from the context menu. See screenshot:
2. In Format Axis dialog, check Categories in reverse order option in Axis Options section. See screenshot:
Tip: In bar chart, reserve the x axis with righting click the x axis and selecting the Format Axis from context menu, then checking the Values in reverse order in the Format Axis dialog box.
3. Close the dialog, now the y axis order is reversed.
Recommended Productivity Tools
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 2 years agoWhen you reverse the order of the y axis, how do you keep the x axis labels at the bottom of the chart? And, why do they move to the top of the chart?
To post as a guest, your comment is unpublished.· 2 years agoThis is good; however, I still need the x-axis lables to remain at the bottom fo the chart. When you reverse the order, they move to the top. Who would want the axis labels at the top of the chart????