custom limit lines using line graph

[Anonymous]

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]

Hi Collin,

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

Best Regards,
Dale

[Anonymous]

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]

Hi Collin,

So what's the result you expect?

Best Regards,
Dale

[Anonymous]

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 

[v-jiascu-msft]

Hi Collin,

Just add the units into the legend. Is it?

Best Regards,
Dale

[Anonymous]

Hello dale, so this is what i have for data now . i would like to be able to have these dots connect  but not continuous .

origonal - what i have

what i want

thanks,

-Collin

[v-jiascu-msft · Accepted solution]

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)

2. Add it to the legend.

Best Regards,
Dale

[Anonymous]

yes, Thankyou, that equasion was exactly what i needed. 

I have another question. I have a graph that looks like this currently                  .   

This is the data for the chart above-------------

ID	Frequency	Requirement Level	Values in chart
1	1	70	point 1
1	15	106	?
1	30	106	?
1	15	96	?
1	30	96	?
1	30	106	?
1	400	96	point 4

I would like it to show all 7 points and not sum diffrent things. i have made the frequency and requirement columns set to not sum from the modeling tab. "values in chart " is not part of graph.

Thanks for the help. 

- Collin

[v-jiascu-msft]

Hi Collin,

How about applying the same trick on this topic? If it can't work, I would suggest you create a new thread in this forum. One topic, one post. Please also mark the proper answers as solutions. Thanks for your understanding.

Best Regards,
Dale