Organize X axis

user08739
user08739 Member
in Charting

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 Coach
    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'

Answers

  • Godiepi
    Godiepi Coach
    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'
  • user08739
    user08739 Member

    Thanks so much! That worked!

This discussion has been closed.

Categories