Organize X axis

Hi Everybody, 


I am trying to create a graph from Excel, and I would like to show In the x axis the number of hours in a day. From 1, 2,3... to 24.


My excel already includes Hours title, and the values. 


But when I create the chart, the x axis for some reason are not in the rate order. Instead of having from 1 to 24 they get mixed.


When I click on the bottom that supposely changes the order of the X axis, no matter how many times I change it that it doesn't reach the right 1 to 24 order.


Anybody knows how can I fix this?

Thanks in advance. 

Best Answer

  • Godiepi
    Godiepi 🟣
    Answer ✓

    Bring your Hours title to the sorting box and select "no aggregation" in ascending order


    Screen Shot

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'


This discussion has been closed.