Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

X-axis keep adding time to date

Hi

 

I hope somebody can help me. 

I have a very simple graph with date i the x-axis and the values is a sum of minutes. 

The minutes is given as numbers in data and is not calculated, but the x-axis keep adding time to the date as in the picture. 

 

I have made sure that the date column is of type date and has the wanted format. 

If i make the graph a little smaller it removes the time but i do not want it to be so small. 

 

 

Hope there is somebody there can helt me!! 

 

3 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion

    Anonymous 

     

    Select the visual and in the formatting pane, select x-axis and change the "Type" to "Categorical"

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      PaulDBrown 

       

      Thank you for a quick response, but I need a trend line and that is not possible when it is "Categorical". 

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    It's hard to reproduce your scenario, can you share some sample data to us?

     

    Best Regards,

    jay