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

EDM1

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 Value

Date & time of measurement

Target (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:

jthi

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

add target and limits to same y-axis as value

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

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