Forum Discussion

excelforjeff's avatar
excelforjeff
Copper Contributor
Oct 13, 2020

How can I change the order of column chart in excel?

I created a table and chart, but the order in the chart starts from "E" instead of "A". I want the chart to start from A down to E. instead of E on the top and A on the bottom. Please advise how I can do that. Thank you so much for reading my question. 

 

I've attached a screenshot. 

  • excelforjeff 

    Double-click any of the category axis (y-axis) labels.

    Tick the check box 'Categories in reverse order' in the 'Format Axis' task pane.

     

    • excelforjeff's avatar
      excelforjeff
      Copper Contributor

      HansVogelaar Thanks a lot!

       

      Do you happen to know if there is a similar setting for office for Mac? I looked in the axis property section but coudnt find one...

    • excelforjeff's avatar
      excelforjeff
      Copper Contributor

      I found this setting, but not reversing the orders...

       

      • HansVogelaar's avatar
        HansVogelaar
        MVP

        excelforjeff 

        You have reversed the value axis (the horizontal one) instead of the category axis (the vertical one).

        If you want to reverse the order of the vertical axis, you should double-click the vertical axis, of course.

Resources