Forum Discussion
custom limit lines using line graph
- 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)
2. Add it to the legend.
Best Regards,
Dale
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-msft7 years agoMicrosoft Employee
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- Anonymous7 years agoNot applicable
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-msft7 years agoMicrosoft Employee
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