Forum Discussion

Dunner2020's avatar
Dunner2020
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

X-axis tick labels

Hi there,

 

I have a line chart that contains hour number on x-axis as shown in the figure:

 

 

The issue with the above picture is that the tick label shows a value from 0 to 23 but with an interval of 5. I want to make it a continuous display of values i.e from 0, 1, 2, 3, 4, 5, 6, 7........ 23. I tried to stretch the figure but still, the tick label value remains the same. 

  • Hi,  Dunner2020 

    After you  changed to Categorical , please make sure you have sort ascending by column "Hour".

    Please select "More options"  ->sort by "hours"->sort ascending

    result:

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

3 Replies

      • v-easonf-msft's avatar
        v-easonf-msft
        Icon for Community Support rankCommunity Support

        Hi,  Dunner2020 

        After you  changed to Categorical , please make sure you have sort ascending by column "Hour".

        Please select "More options"  ->sort by "hours"->sort ascending

        result:

         

        Best Regards,
        Community Support Team _ Eason
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.