提示:其它语言是由 Google 机器翻译的。 你可以访问 English 版本。
登录
x
or
x
x
注册账户
x

or

如何在Excel中反转轴顺序?

有时,您可能需要在图表中反转轴顺序。 例如,在条形图中,与数据相比,轴顺序在默认情况下反转,在这种情况下,您可能想要颠倒轴顺序以符合数据顺序,如下所示。 现在,本教程将告诉您如何快速在Excel中反转轴顺序。

DOC-扭转轴1
DOC箭头
DOC-扭转轴2

在图表中反转轴顺序


箭头蓝色右泡 在图表中反转轴顺序


“格式轴”对话框中有一个用于反转轴顺序的选项。

1。 右键单击要倒转的y轴,然后选择 格式Axis从上下文菜单中选择。 看截图:

DOC-扭转轴3

2。 在 格式轴 对话框,检查 分类顺序相反 选项 轴选项 部分。 看截图:

DOC-扭转轴4

提示: 在条形图中,右键单击x轴并选择,保留x轴 格式轴 从上下文菜单中,然后检查 值以相反的顺序格式轴 对话框。

3。 关闭对话框,现在y轴顺序颠倒。

DOC-扭转轴5



推荐的Excel生产力工具

Kutools for Excel帮助您提前完成工作,并从人群中脱颖而出

  • 超过300强大的高级功能,专为1500工作场景设计,通过70%提高生产力,让您有更多时间照顾家庭和享受生活。
  • 不再需要记忆公式和VBA代码,从现在起让你的大脑休息一下。
  • 成为3分钟的Excel专家,复杂和重复的操作可以在几秒钟内完成,
  • 每天减少成千上万的键盘和鼠标操作,现在告别职业病。
  • 110,000高效人才和300 +世界知名公司的选择。
  • 60-day full功能免费试用。 60天退款保证。 2多年的免费升级和支持。

将选项卡式浏览和编辑带到Microsoft Office,远比浏览器的选项卡强大

  • Office选项卡专为Word,Excel,PowerPoint和其他Office应用程序设计:Publisher,Access,Visio和Project。
  • 在同一窗口的新选项卡中打开并创建多个文档,而不是在新窗口中。
  • 通过50%提高您的工作效率,每天为您减少数百次鼠标点击!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Laurie · 2 years ago
    When 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.
      Sandy · 2 years ago
      Click "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.
        Domel · 2 months ago
        You're the best, thanks!
      • To post as a guest, your comment is unpublished.
        Don · 8 months ago
        Double 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.
        SK · 1 years ago
        Thanks Sandy
  • To post as a guest, your comment is unpublished.
    Laurie · 2 years ago
    This 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????