How to customize reference line

[#1]

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.  

[MayilVahanan]

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

[#3]

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

[MayilVahanan]

Hi

I think Its not possible..

[#5]

Is this possible to draw a line with expression?

[MayilVahanan]

Hi

Try like this

if(INtWeeks <= -1, 46.9), instead of numbers ,you use your exp

if(NtWeeks > 0, 31.9)

Hope it helps

[#7]

It works perfectly. Is there any way to add a label to the these two lines? This is the last step. Thanks

[MayilVahanan]

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..

[#9]

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.

[MayilVahanan · Accepted solution]

Hi

Use like this,

Expression-> click '+' sign, show value -> if(IntWeeks = -11, 1,0)

Hope it helps