Forum Discussion

ashmitp869's avatar
ashmitp869
Responsive Resident
1 year ago
Solved

vertical line in Line Chart

Hi ,

How to add vertical line in Line Chart.

 

 

  • You can add multiple constant lines referencing the dates that you want.

     

     

    But you are not able to view the X axis constant line because your data type may be in string format please transform the data into date format or numeric format, then you will be able to view the x axis constant line. This will resolve your issue and you will be able to constant lines as required.
    Thanks and regards.

13 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    ashmitp869 The Analytics pane only supports an X-axis constant line if you have a numeric x-axis. Otherwise, you just have to create a line shape and then overlay it. ๐Ÿ˜ž

    • ashmitp869's avatar
      ashmitp869
      Responsive Resident

      I am not looking for a constant line but similar like this.

      Every month

       

       

      • danextian's avatar
        danextian
        Super User

        You will need to add several constant lines to achieve that referring to different dates.

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support

    Hi @ashmitp869 ,
    Thank you for reaching out to Microsoft community support.


    You can find X-Axis Constant Line and Y-Axis Constant Line in Visualizations โ€“ Analytics.

    This feature will be available to numeric and date data types, but wont be available to text data type. We can transform text type to date type if possible to add constant lines but if that is not possible check the below steps.

    If you want to add a vertical line in a line chart, we donโ€™t have a direct feature to do so for Text values but there is a good enough work around to do for your desired task.


    -> Click on the Insert pane and click on shapes.

     

    ->From there select the line chart

    ->Click on the line chart and use format visual to rotate the line 90 degrees, we will obtain a vertical line.

     


    -> The resulting line is shown in the below picture

     

    ->Please use that shape to overlay over your line chart visual wherever you want, For ex

     



    Please consider Accepting the solution if the provided answer meets your requirement so as to help other users or get back to us if you have further queries.


    Thanks and Regards

    • ashmitp869's avatar
      ashmitp869
      Responsive Resident

      I am not looking for a constant line but similar like this.

      Every month

       

       

      • Irwan's avatar
        Irwan
        Super User

        hello ashmitp869 

         

        i might be mistaken but that picture looks like a vertical grid line to me.

         

         

        Thank you.

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support

    Hi ashmitp869 ,

    We have not heard back from you if any answer has met your requirement kindly  Accept it as the solution  to help out other community members.

    Thank you