By adding a function plot or grid line to an existing axis, you can create a line of constant value to your graph.
- Click anywhere on the existing graph to select it.
- Click the Home | Add to Graph | Plot command ().
- In the Select Plot Type dialog, select Y=F(X) Function Plot and click OK.
- In the Choose Axes dialog, select the axes to use for the new constant value line and click OK. The plot is added using the default options.
- Click on the Function Plot in the Object Manager to select it.
- In the Property Manager, click on the Plot tab.
- For a horizontal line, highlight the cos(X) text in the Y = F(X) = field and enter the desired value for the horizontal line. For instance, you might type 30, if you want the line displayed at Y=30.
- For a vertical line,
- Change the Type from Y=F(X) to X=F(Y).
- Highlight the cos(Y) text in the X = F(Y) = field and enter the desired value for the vertical line. For instance, you might type 400 if you want the line displayed at X=400.
- In the Property Manager, click the Data Limits tab.
- Highlight the value 12 in the Last value field and enter the axis maximum value. For a horizontal line, this should be the X maximum value. For a vertical line, this should be the Y maximum value.
- Highlight the zero in the First value field and enter the axis minimum value. For a horizontal line, this should be the X minimum value. For a vertical line, this should be the Y minimum value.
The line now extends the full length of the plot at the specified value. The line style and color can be changed on the Line tab in the Property Manager.
Add a line of constant value using grid lines:
Axis grid lines may be easier to use if you have many horizontal or vertical lines that you want to display. This method may also be easier if the axis limits will change.
- Click on your existing worksheet or create a new worksheet.
- In one column, enter the Y value for each horizontal line.
- In another column, enter the X value for each vertical line.
- Save the data file by right-clicking anywhere on your worksheet. In the pop-up menu, click the File | Save or File | Save as command.
- Click File | Reload data from the menu ribbon to update your plot data.
- To add a horizontal line, click on the Y Axis for your plot in the Object Manager to select it. For a vertical line, click on the X Axis.
- In the Property Manager, click on the Line tab.
- Click the + next to the Grid Line Properties section, if needed.
- Check the box in the Worksheet grid lines field.
- Click the + next to the Worksheet Grid Line section.
- Click in the Worksheet field and select the worksheet file that was saved in step 4.
- Click in the Variable field and select the appropriate column. For horizontal lines, this is the column created in step 2. For vertical lines, this is the column created in step 3.
The line now extends the full length of the parallel axis. The line style and color can be changed in the Worksheet line properties section.
Updated May 2023
Please sign in to leave a comment.