Forum Discussion
custom limit lines using line graph
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
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
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
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