cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
EDM1
Level I

How to plot both measurement points and target/control lines on same chart

Hi I am looking for a way to plot my old measured data alongside my target/upper/lower lines on the same chart. The target occasionally changes which is why I am not just using a Axis reference line.

 

Simplified, my data table has the below columns:

Measured ValueDate & time of measurementTarget (at time of measurement)Upper limit (at time of measurement)Lower Limit (at time of measurement)

 

I have made a paint rendition of roughly what i hope my output will look like when plotted:

Goal JMP output.png

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: How to plot both measurement points and target/control lines on same chart

Using mockup data: add your value and time to graph builder

jthi_0-1728447996170.png

add target and limits to same y-axis as value

jthi_1-1728448016817.png

while holding shift click on the line chart to add that with points

jthi_2-1728448044242.png

From the variables, disable limits from points and value from line

jthi_3-1728448073850.png

 

-Jarmo

View solution in original post

2 REPLIES 2
txnelson
Super User

Re: How to plot both measurement points and target/control lines on same chart

Here is one way to handle this

txnelson_0-1728447717992.png

txnelson_2-1728447785369.png

Set up your data as shown above

Go to Graph=>Graph Builder

Drag the Date column to the X axis drop area

Select Measured Value, Target, Upper, Lower columns and drag them to the Y axis drop area

Right click on the graph and select Smoother=>Remove

Right click on the Y axis values and select Move Right

Move the Target, Upper and Lower to the right axis

Right click on the chart and select Points Right =>Change to Line

Jim
jthi
Super User

Re: How to plot both measurement points and target/control lines on same chart

Using mockup data: add your value and time to graph builder

jthi_0-1728447996170.png

add target and limits to same y-axis as value

jthi_1-1728448016817.png

while holding shift click on the line chart to add that with points

jthi_2-1728448044242.png

From the variables, disable limits from points and value from line

jthi_3-1728448073850.png

 

-Jarmo