Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I wanted to draw two reference lines for two set of data and would like to know whether I can change reference line's width, location in order to line reference line to different data.
Please see my screen shot.
Hi
Use like this,
Expression-> click '+' sign, show value -> if(IntWeeks = -11, 1,0)
Hope it helps
Hi
Do you want something like attached file.. If so,
Use weight, color and style in Add reference option in presentation tab in chart properties
Actually I want the upper reference line for the second data set(right), and lower reference line for the first data set. The upper reference line should be cover 1-5, the lower reference line should cover -11 to -1. Is this possible? Thanks
Hi
I think Its not possible..
Is this possible to draw a line with expression?
Hi
Try like this
if(INtWeeks <= -1, 46.9), instead of numbers ,you use your exp
if(NtWeeks > 0, 31.9)
Hope it helps
It works perfectly. Is there any way to add a label to the these two lines? This is the last step. Thanks
Hi
Use add "text chart" in presentation tab.. and with help of ctrl+shift, you can move and place it.. when chart change, its the value correctly but place in that same place..
If the 'chart text' can stay with the line, that will be great.
I just tried enabling 'show value' property of expression, but it shows all the values at each data point even enough they are the same. If I can show only one value, that will solve my problem.
Thank you again.
Hi
Use like this,
Expression-> click '+' sign, show value -> if(IntWeeks = -11, 1,0)
Hope it helps