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.· 2 months agoYou're the best, thanks!
To post as a guest, your comment is unpublished.· 8 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
有时，您可能需要在图表中反转轴顺序。 例如，在条形图中，与数据相比，轴顺序在默认情况下反转，在这种情况下，您可能想要颠倒轴顺序以符合数据顺序，如下所示。 现在，本教程将告诉您如何快速在Excel中反转轴顺序。
1。 右键单击要倒转的y轴，然后选择 格式Axis从上下文菜单中选择。 看截图：
2。 在 格式轴 对话框，检查 分类顺序相反 选项 轴选项 部分。 看截图：
提示： 在条形图中，右键单击x轴并选择，保留x轴 格式轴 从上下文菜单中，然后检查 值以相反的顺序 在 格式轴 对话框。
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????