topic Re: Make vertical line on chart in Discussions

Make vertical line on chart

djhanson — Fri, 08 Apr 2011 13:41:39 GMT

Does anyone have an example of using Add Ref Line for making a vertical line on a chart (example Variability Chart, etc)? I've seen some examples in the JSL guide, but wanted to see another example as I'm trying to make it work. thx in advance. dj

Re: Make vertical line on chart

Sat, 09 Apr 2011 11:23:39 GMT

You can annotate a chart in any way you like by adding a graphics script to it as I've done below: the example adds three vertical lines to a control chart plus some comments. As an aside, I'd be interested to know a couple of things myself:

(a) How can I retrieve the control limits from a column in a data table without going through the rather tortuous parsing procedure that I've used below?

(b) There seems to be a difference between JMP 8 and JMP 9 in the "Dispatch" section of the control chart syntax: the frame size isn't correctly set in JMP 9 unless I change "IR Chart" to "IR Chart of IM" as shown below. Does anybody know why?

style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: green;">//
Start of program;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">clear
log
style="font-size: 9pt; font-family: "Courier New"; color: black;">()
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">dt

style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">open
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: purple;">"$SAMPLE_DATA/Quality
Control/Coating.jmp"
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">column
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">dt
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: purple;">"Weight"
style="font-size: 9pt; font-family: "Courier New"; color: black;">)[
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">4
style="font-size: 9pt; font-family: "Courier New"; color: black;">]
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">16
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: green;">//
Create an
outlier;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">column
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">dt
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: purple;">"Weight"
style="font-size: 9pt; font-family: "Courier New"; color: black;">)[
style="font-size: 9pt; font-family: "Courier New"; color: teal;">13
style="font-size: 9pt; font-family: "Courier New"; color: black;">]
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">25
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: green;">//
Create an
outlier;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">column
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">dt
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: purple;">"Weight"
style="font-size: 9pt; font-family: "Courier New"; color: black;">)[
style="font-size: 9pt; font-family: "Courier New"; color: teal;">23
style="font-size: 9pt; font-family: "Courier New"; color: black;">]
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">26
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: green;">//
Create an
outlier;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">JMP_Version

style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">substr
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">JMP
Version
style="font-size: 9pt; font-family: "Courier New"; color: black;">()
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">2
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">show
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">JMP_Version)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">if
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">JMP_Version
style="font-size: 9pt; font-family: "Courier New"; color: navy;">==
style="font-size: 9pt; font-family: "Courier New"; color: purple;">"9"
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
CC

style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">
Control Chart(

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
Group
Size(

style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: black;">
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
KSigma(

style="font-size: 9pt; font-family: "Courier New"; color: teal;">3
style="font-size: 9pt; font-family: "Courier New"; color: black;">
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
Chart
Col(

style="font-size: 9pt; font-family: "Courier New"; color: navy;">:
style="font-size: 9pt; font-family: "Courier New"; color: black;">Weight
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
Individual Measurement )
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
SendToReport(

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
Dispatch(

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
{
style="font-size: 9pt; font-family: "Courier New"; color: purple;">"Individual
Measurement of Weight"
style="font-size: 9pt; font-family: "Courier New"; color: black;">}
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: purple;">"IR
Chart
of IM"
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
FrameBox
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
{Frame
Size(

style="font-size: 9pt; font-family: "Courier New"; color: teal;">600
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">400
style="font-size: 9pt; font-family: "Courier New"; color: black;">
)}
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
)

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
SendToReport(

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
Dispatch(

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: purple;">"IR
Chart"
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
)

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">CC

style="font-size: 9pt; font-family: "Courier New"; color: navy;"><<
style="font-size: 9pt; font-family: "Courier New"; color: black;">
(
style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">column
style="font-size: 9pt; font-family: "Courier New"; color: black;">[
style="font-size: 9pt; font-family: "Courier New"; color: purple;">"Weight"
style="font-size: 9pt; font-family: "Courier New"; color: black;">]
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: navy;"><<
style="font-size: 9pt; font-family: "Courier New"; color: black;">
in column)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
style="font-size: 9pt; font-family: "Courier New"; color: green;">//
Store the control limits in
column(DT, "Weight");
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: green;">//
CC <<
(column["Weight"] << in new table); // Or store the
control
limits in a new table if you prefer;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">CharLims

style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">char
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">column
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">dt
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: purple;">"Weight"
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: navy;"><<
style="font-size: 9pt; font-family: "Courier New"; color: black;">
get property(
style="font-size: 9pt; font-family: "Courier New"; color: purple;">"Control
Limits"
style="font-size: 9pt; font-family: "Courier New"; color: black;">))
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">show
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">CharLims)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">LCLStart

style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">contains
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">CharLims
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: purple;">"LCL"
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: navy;">+
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">4
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">
UCLStart
style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">contains
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">CharLims
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: purple;">"UCL"
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: navy;">+
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">4
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">LCLFinal

style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">contains
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">substr
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">CharLims
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
LCLStart
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">99
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: purple;">")"
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: navy;">-
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">UCLFinal

style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">contains
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">substr
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">CharLims
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
UCLStart
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">99
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: purple;">")"
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: navy;">-
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">LCL

style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">parse
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">substr
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">CharLims
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
LCLStart
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
LCLFinal))
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">UCL

style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">parse
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">substr
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">CharLims
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
UCLStart
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
UCLFinal))
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">show
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">LCL)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">show
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">UCL)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: green;">//
Finally annotate the control
chart with exceptions and a process change after time point 24;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">for
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">i
style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
i
style="font-size: 9pt; font-family: "Courier New"; color: navy;"><=
style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">nrow
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">dt)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
i
style="font-size: 9pt; font-family: "Courier New"; color: navy;">++,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">pen
color
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: purple;">"cyan"
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">line
style
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">vline
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">i)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">line
style
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: teal;">0
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">text
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">boxed
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
erased
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
{i
style="font-size: 9pt; font-family: "Courier New"; color: navy;">+
style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">column
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">dt
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: purple;">"Weight"
style="font-size: 9pt; font-family: "Courier New"; color: black;">)[
style="font-size: 9pt; font-family: "Courier New"; color: black;">i]}
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: purple;">"
Too Low!
"
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">line
style
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: teal;">0
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">text
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">boxed
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
erased
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
{i
style="font-size: 9pt; font-family: "Courier New"; color: navy;">+
style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">column
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">dt
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: purple;">"Weight"
style="font-size: 9pt; font-family: "Courier New"; color: black;">)[
style="font-size: 9pt; font-family: "Courier New"; color: black;">i]}
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: purple;">"
Too High!
"
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">if
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">i
style="font-size: 9pt; font-family: "Courier New"; color: navy;">==
style="font-size: 9pt; font-family: "Courier New"; color: teal;">24
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">pen
color
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: purple;">"purple"
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">line
style
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: teal;">0
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">vline
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">i
style="font-size: 9pt; font-family: "Courier New"; color: navy;">+
style="font-size: 9pt; font-family: "Courier New"; color: teal;">0.5
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">line
style
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: teal;">0
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">text
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">boxed
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
erased
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
{i
style="font-size: 9pt; font-family: "Courier New"; color: navy;">+
style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">column
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">dt
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: purple;">"Weight"
style="font-size: 9pt; font-family: "Courier New"; color: black;">)[
style="font-size: 9pt; font-family: "Courier New"; color: black;">i]}
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: purple;">"
Adjusted
Process Here "
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
)

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
)
style="">

style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: green;">//
End of program;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

Re: Make vertical line on chart

Sat, 09 Apr 2011 13:21:44 GMT

Incidentally, I know I haven't used the "Add Ref Line" syntax in any of the above, because I'm unfamiliar with it myself, but the following may help address a more general customization question. For any particular type of chart, I find the easiest way to customize it is to create a basic chart of the type I want via the main menu, then right-click on that chart, select "Customize...", and then click on the "+" symbol to get an empty script window, into which you can add anything you want - a line, text, polygon or whatever. In this example, if you then type "V Line(5)" in that window, you'll add a vertical line at X=5 to the chart. To see the script you've created by doing that, click on the red triangle above the chart, then select Script | Send to Script Window. It'll look something like the one underneath - after which you can continue editing that script until the resulting chart looks exactly the way you want it. You can then use your new script to generate your charts instead of going through the main menu.

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: black;">dt

style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">Open
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: purple;">"$SAMPLE_DATA/Quality
Control/Coating.jmp"
style="font-size: 9pt; font-family: "Courier New"; color: black;">
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: green;">/*
Create a basic variability
chart */
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: black;">Variability
Chart(

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
Y(

style="font-size: 9pt; font-family: "Courier New"; color: navy;">:
style="font-size: 9pt; font-family: "Courier New"; color: black;">Weight
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
X(

style="font-size: 9pt; font-family: "Courier New"; color: navy;">:
style="font-size: 9pt; font-family: "Courier New"; color: black;">Sample
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: green;">/*

style="font-size: 9pt; font-family: "Courier New"; color: green;">
style="">
After
you've finished customizing it as described above,

style="font-size: 9pt; font-family: "Courier New"; color: green;">
style="">
the
script might look something like the following, which

style="font-size: 9pt; font-family: "Courier New"; color: green;">
style="">
you
can carry on editing until you get the effects you want.

style="font-size: 9pt; font-family: "Courier New"; color: green;">*/
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: black;">Variability
Chart(

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
Std
Dev Chart(

style="font-size: 9pt; font-family: "Courier New"; color: teal;">0
style="font-size: 9pt; font-family: "Courier New"; color: black;">
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
SendToReport(

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
Dispatch(

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
{
style="font-size: 9pt; font-family: "Courier New"; color: purple;">"Variability
Chart for Weight"
style="font-size: 9pt; font-family: "Courier New"; color: black;">}
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: purple;">"Variability
Chart"
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
Add
Graphics Script(

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">2
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
Description(

style="font-size: 9pt; font-family: "Courier New"; color: purple;">"Script"
style="font-size: 9pt; font-family: "Courier New"; color: black;">
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">Pen
Color
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: purple;">"red"
style="font-size: 9pt; font-family: "Courier New"; color: black;">
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">Pen
Size
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: black;">
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">V
Line
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">5
style="font-size: 9pt; font-family: "Courier New"; color: black;">
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">Pen
Color
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: purple;">"blue"
style="font-size: 9pt; font-family: "Courier New"; color: black;">
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">V
Line
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">7
style="font-size: 9pt; font-family: "Courier New"; color: black;">
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
)

style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: green;">//
End of program;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

Re: Make vertical line on chart

anneg — Mon, 11 Apr 2011 10:07:48 GMT

Hello,

I'm still using JMP8 and have also a question about vertical line.

I've a plot and the x-Axis is the date (for example between 2011/01/01 - 2011/04/08 and the Y-Axis is something like height or weight...(or Pmpp - solar technology)

I've got also dates about changes in chemical charges we use, so the are specific dates, when we chance it - for example 2011/01/14; 2011/02/05.... there are in a different table.

So the question is, how can I draw in my plot vertical ref lines at the dates with the change of the chemical charge?

Any suggestions?

Re: Make vertical line on chart

Mon, 11 Apr 2011 11:20:16 GMT

Would something like the following do what you need? I've created the data and the dates for the lines from scratch, but obviously you'd have these set up already:

style="font-size: 9pt; font-family: "Courier New"; color: green;">

style="font-size: 9pt; font-family: "Courier New"; color: green;">

style="font-size: 9pt; font-family: "Courier New"; color: green;">//
Make a list of every day
between 1st Jan 2010 and 31st Dec 2011 inclusive;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: black;">SecondsPerDay

style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">Date
DMY
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: teal;">2
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">2010
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: navy;">-
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">Date
DMY
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">2010
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">TwoYears

style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">
(
style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">Date
DMY
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: teal;">31
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">12
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">2011
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: navy;">-
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">Date
DMY
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">2010
style="font-size: 9pt; font-family: "Courier New"; color: black;">))
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: navy;">/
style="font-size: 9pt; font-family: "Courier New"; color: black;">
SecondsPerDay
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">Dates

style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">Date
DMY
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">2010
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: navy;">+
style="font-size: 9pt; font-family: "Courier New"; color: black;">
SecondsPerDay
style="font-size: 9pt; font-family: "Courier New"; color: navy;">*
style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">index
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: teal;">0
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
TwoYears)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: green;">//
Plot some random numbers with
an underlying pattern;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: black;">SomeNumbers

style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">
{}
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">for
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">i
style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
i
style="font-size: 9pt; font-family: "Courier New"; color: navy;"><=
style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">ncol
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">Dates)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
i
style="font-size: 9pt; font-family: "Courier New"; color: navy;">++,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">insert
into
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">SomeNumbers
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">2
style="font-size: 9pt; font-family: "Courier New"; color: navy;">*
style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">sin
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">i
style="font-size: 9pt; font-family: "Courier New"; color: navy;">/
style="font-size: 9pt; font-family: "Courier New"; color: teal;">100
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">+
style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">random
normal
style="font-size: 9pt; font-family: "Courier New"; color: black;">()))
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: green;">//
Put them both into a table;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: black;">dt

style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">new
table
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: purple;">"Chemicals"
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">new
column
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: purple;">"Date"
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
Numeric
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">format
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: purple;">"d/m/y"
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
values(Dates))
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: green;">//
Create a plot from the original
table;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: black;">OP

style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">
Overlay Plot(

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
X(

style="font-size: 9pt; font-family: "Courier New"; color: navy;">:
style="font-size: 9pt; font-family: "Courier New"; color: black;">Date
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
Y(

style="font-size: 9pt; font-family: "Courier New"; color: navy;">:
style="font-size: 9pt; font-family: "Courier New"; color: black;">Value
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
Separate Axes(

style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: black;">
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
SendToReport(
Dispatch(
{}
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: purple;">"101"
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
ScaleBox
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
{Interval(

style="font-size: 9pt; font-family: "Courier New"; color: purple;">"Month"
style="font-size: 9pt; font-family: "Courier New"; color: black;">
)}
)
)

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: green;">//
Make a matrix of dates at which
a vertical line is needed;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: black;">ChangeMat
style="">
style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">matrix
style="font-size: 9pt; font-family: "Courier New"; color: black;">({
style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">Date
DMY
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: teal;">4
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">7
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">2010
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">Date
DMY
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: teal;">25
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">12
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">2010
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">Date
DMY
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">6
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: teal;">2011
style="font-size: 9pt; font-family: "Courier New"; color: black;">)})
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: green;">//
Enter these into a table called
DTC, which I'll then assume already exists for editing the chart;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: black;">dtc

style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">new
table
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: purple;">"Change
Table"
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">new
column
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: purple;">"Changes"
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
Numeric
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">Format
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: purple;">"d/m/y"
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
values(ChangeMat))

style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">dtc

style="font-size: 9pt; font-family: "Courier New"; color: navy;"><<
style="font-size: 9pt; font-family: "Courier New"; color: black;">
minimize window
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: green;">//
Find out where the chart is
within the report, and add a graphics script to it;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: black;">OPR

style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">
OP
style="font-size: 9pt; font-family: "Courier New"; color: navy;"><<
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">report
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: green;">//
It's in FrameBox(1), so add a
script to that;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: black;">OPR[FrameBox(
style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: black;">)]
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: navy;"><<
style="font-size: 9pt; font-family: "Courier New"; color: black;">
add graphics
script(

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">pen
color
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: purple;">"blue"
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">vline
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">column
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">dtc
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: purple;">"Changes"
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: navy;"><<
style="font-size: 9pt; font-family: "Courier New"; color: black;">
get values ))
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">

style="font-size: 9pt; font-family: "Courier New"; color: green;">//
End of program;
style="font-size: 9pt; font-family: "Courier New"; color: black;">

style="font-size: 9pt; font-family: "Courier New"; color: black;">

Re: Make vertical line on chart

Mon, 11 Apr 2011 11:30:19 GMT

Sorry - I forgot to add that to work out where the chart is in the report, you'll need to see the tree structure of the chart. To get that, just type "OP << show tree structure" after the basic chart has been created.

Re: Make vertical line on chart

anneg — Mon, 11 Apr 2011 13:13:45 GMT

Thanks so much, it works like a charm.

Re: Make vertical line on chart

djhanson — Tue, 12 Apr 2011 15:35:08 GMT

Thanks much! I will try some of these approaches. dj

Re: Make vertical line on chart

mpb — Fri, 15 Apr 2011 01:27:40 GMT

> As an aside, I'd be
> interested to know a couple of things myself:
>
> ) How can I retrieve the control limits from a column
> in a data table without going through the rather
> tortuous parsing procedure that I've used below?

Example assuming spec limits have been entered for Oxy in the Fitness data: