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:
Accepted Solutions
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
Here is one way to handle this
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
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