assigned spec limits from limits column

[#1]

Hi,
I have a data table with the following columns, how can I assign the limits to the value column as property?
meaning when I plot value by date ill see those limits automatically

I tried 

:value << set property(
"spec limits",
{LSL( : LCL ) , USL( : UCL ), Target( : Target ), Show Limits( 1 )}
);

thanks!

[#2]

Hello @txnelson ,

I am somewhat new to JMP. Where would I put this code? The following is the script in the Source. 

Open(
	"Data.xlsx",
	Worksheets( {"Sheet2"} ),
	Use for all sheets( 1 ),
	Concatenate Worksheets( 1 ),
	Create Concatenation Column( 1 ),
	Worksheet Settings(
		1,
		Has Column Headers( 1 ),
		Number of Rows in Headers( 1 ),
		Headers Start on Row( 1 ),
		Data Starts on Row( 2 ),
		Data Starts on Column( 1 ),
		Data Ends on Row( 0 ),
		Data Ends on Column( 0 ),
		Replicated Spanned Rows( 1 ),
		Replicated Spanned Headers( 0 ),
		Suppress Hidden Rows( 1 ),
		Suppress Hidden Columns( 1 ),
		Suppress Empty Columns( 1 ),
		Treat as Hierarchy( 0 ),
		Multiple Series Stack( 0 ),
		Import Cell Colors( 0 ),
		Limit Column Detect( 0 ),
		Column Separator String( "-" ),
		Eval(
			Substitute(
					Expr(
						:value << set property(
							"spec limits",
							{LSL( __LSL__ ), USL( __USL__ ), ., Show Limits( 1 )}
						)
					),
				Expr( __LSL__ ), :LSL[10],
				Expr( __USL__ ), :USL[7],

			)
		)
	)
)

This isn't working for me. Trying to debug the script causing a break, no matter where I put a breakpoint. Any help would be appreciated. 

[#3]

The information from this track is assuminging 2 data tables are open in your JMP session.  A data table containing the measurement data, and a second table containing Spec LImits.  Your Open() function is opening an Excel file called "Data.xlsx.  Is this your measurement data or your limits data?  In either case, you can not interject into the Open() function, the JSL that modifies the Spec Limits.  Both the measurement table and the table that has the limits in it, has to be completly read in, and then the limits update code needs to be applied.