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     ...
  • 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

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        The x and y values line up with a units column, so if you had:

         

                   y-axis             x-axis

        units    #amount      amount

         1          15                  100

         1          15                  600

         2          30                  1,200

         2          30                  1,400

         

        id like the legend to show the 1s and 2s not the Y vaules. 

         

        Thanks for replying,     -Collin