reference line expression

[samuel_brierley]

Hi all,

first of all thanks for any and all help its much appreciated.

I want to add a reference line onto a chart but I want the reference line to be a value from an excel table.

this table is not releated to the data on the chart and a lookup in the script seems to take FARRRRR too long so thats out.

id like the line to show the value of RLev10 in the table.

Parameter:	Value:
RLev10	750

thanks for any help.

[samuel_brierley]

apologies i forgot to add the name of the table is Settings, im pretty sure this will be required.

thanks again

[MK_QSL]

Go to Presentation >> Reference Lines >> Add >> Expression >> =RLev10 or =750

[samuel_brierley]

Doesnt work,

I cant just put 750 as im trying to make a temp[late that will work regardless of the input data.

[MK_QSL]

Can you share your sample data or apps or even a picture of your current chart?

[samuel_brierley]

Ye no Prob

on the chart I just need a reference line that shows rLev10 in the table Settings( in this version I havent named the table so its just called Sheet1), you can see that this isnt related if you look in table viewer you will see the standalone table.

also If you know how would it be possible to add a referene line that is Y=X?

https://www.dropbox.com/s/0r9kv1wo1jlq4wk/multidays.qvw

[maxgro]

load your excel and see image

[samuel_brierley]

thanks youve definalty sussed it but how did you specify to puse the value for RLev10?

[jfkinspari]

Just type RLev10 into the expression. It's where Massimo has written Value

[samuel_brierley]

Hi,

I have entered into the box (spelling and Case is correct) but no line appears?