Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Step chart step location

Hi, I've created a step chart for data where the value is either 1 or 0 and the step chart shows a timeline of it.

Currently it looks like this.

My problem is that in the data the last two rows have date values of 9:10:50AM and 9:17:25AM but the chart puts the step in the middle of those two, around 9:14AM. I would like it to show it exactly where the value is, so in this case at 9:17:25AM.

I couldn't find any info on this, any help would be greatly appreciated.

Need Help

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous ,

     

    Please change the X-axis type to "Categorical".

     

    Best regards,

    Yuliana Gu

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi v-yulgu-msft 

      Thank you for your reply!

       

      The categorical type doesn't seem to influence where the line is drawn.

      In the screenshot you sent, it still draws the line at around 9:14 which is not what I'm looking for. I'd like for it to draw the line at 9:17:25AM, the same place that the date is in the dataset.