提示:其他語言是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????