Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

custom limit lines using line graph

Hello, I have a set of data that if correct should present to form limit lines.  For example one  set might be:

 

 

y-axis             x-axis

#amount      amount

15                  100

15                  600

30                  1,200

30                  1,400

 

 

 

Idealy for the limit lines to present correctly the line would be connected from 100 to 600 then disconnected from 600 to 1200 and connected from 1200 to 1400.

 

All I can get is them the apear in point forms or one whole line. Is there a way, what should i try.

 

Any and all help is greatly apriciated, thanks

 

Collin.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Collin,

     

    So how can we or the graph know which dots should be connected and which dots shouldn't be connected?

    Maybe there is a workaround that adds a new column to group these dots. Please download the demo and give it a try.

    1. Create a column.

    Column = if([X] <= 600, 1, 2)

    custom-limit-lines-using-line-graph

    2. Add it to the legend.

    custom-limit-lines-using-line-graph2

     

    Best Regards,
    Dale

9 Replies

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

    Hi Collin,

     

    Can adding the Y to the legend solve this requirement? Please refer to the snapshot below.

    custom_limit_lines_using_line_graph

     

     

    Best Regards,
    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thankyou Dale that Worked, 

       

      One more thing, 

      is there a way to have a diffrent or added legend to the graph without changing the data. 

      the graph looks good but would like the legend to catagorize diffrently.

       

      thanks for the help. 

       

      - Collin

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

        Hi Collin,

         

        So what's the result you expect?

         

         

        Best Regards,
        Dale