I am trying to create a straight line on a line chart showing other data. The line will present what is the good level within the levels for what the original data is actually presenting.
I am trying to create the red line on the attached image:
Asked
Active
Viewed 1,135 times
2 Answers
1
You have to add an additional values serie to your chart. Go to Chart Data and press + button:
In expression use the constant value, in your case 180:
=180
Let me know if this helps.
alejandro zuleta
- 13,962
- 3
- 28
- 48
-
1This sounds more like something for a **StripLine**. – Hannover Fist Aug 03 '16 at 19:16
-
It can be done using StripLine or adding other serie (my approach), however in my opinion a StripLine is more complex and wont let set the line dynamically. – alejandro zuleta Aug 03 '16 at 20:19
-
Yes, this was very helpfully, thank you. I was able to add a IF statement to the expression to make the line a bit more dynamic. – user3382674 Aug 05 '16 at 11:02
0
Just add a column of int values at the end of you Stored Procedure (or whatever is supplying your data) and plot it just like any other series.
StelioK
- 1,771
- 1
- 11
- 21