9.3.5 Editing the Plots Display Range

You can alter the display range of a data plot without masking or otherwise altering the worksheet's display range. This is particularly handy when you have other plots in the project that use the same worksheet data. By altering only the plot display range, you can be sure that you are altering only the plot of interest.

There are three ways to alter the data plot's display range:Plot Setup dialog box, Layer Content dialog box and the context menu of the graph. We begin with the assumption that you have created a graph window with one or more plots and you want to alter the display range of one or more of the plots.

Display Range Setting in Plot Setup

  1. ALT+Double-click on the layer n icon in the upper left corner of the graph window. This opens the Plot Setup dialog box.
  2. Use the buttons to open all three panels in this dialog box.
  3. Highlight the graph window's source worksheet in the top panel.
  4. Click to the right side of the data plot's listed range, under the Range heading in the bottom panel. This produces a button which, when clicked on, opens the Range dialog box.
    Editing the Plot's Display Range 01.png
  5. Clear the Auto check boxes (if selected) and edit the From and To values, as needed.
  6. Click OK (in the Range dialog box).
  7. Edit the Range for each plot, as needed.
  8. If you do not wish to have the graph axes rescaled to accommodate the changes to the plot display, clear the Rescale check box under the Range heading.
  9. Click OK. The plot is redrawn with new From and To values. If you checked Rescale, the axes are rescaled to reflect the changes to the plot range.
Notes: After you have customized the range for a plot, you can apply the range to other plots in the same group/layer/page by right-clicking on this plot and then selecting Apply Range to Group/Apply Range to Layer/Apply Range to Page.

Display Range Setting in Layer Content

  1. With the graphs active, right-click on the layer icon in the upper-left corner of the graph window.
  2. Select Layer Content from main menu.
  3. Right-click the Layer icon to select Layer Contents from the context menu.
  4. In the layer content list box of the right panel, go to the Range column and click the button to open the Range dialog box. If the Range is not included, right click on the column header area of this list to view a context menu, and then check the Range .
  5. The following range setting steps are identical with Step 5 to Step 9 in the Display Range setting in Plot Setup session.
    Layer content-edit range.png

Display Range Setting from Context Menu

  1. With the graphs active, click the target plot to select it(need click twice for the plot in a group), then right-click to open the context menu. Select Edit Range in the context menu to open the Range dialog.
    Edit Range from Context Menu 01.png
  2. Here, you have two approaches to edit the display range for the selected plot: 1) By X Values(Only available for monotonic plot); 2) By Row Index. Select By X radio box, uncheck Auto box for From and To items, and then enter the start and end X values for each. Click Apply to check the effect and then OK button to close the dialog.
    Edit Range from Context Menu 02.png

Display Range Setting of 3D Graphs

The methods of opening range setting box are identical for both 2D and 3D graphs. But in 3D graphs, the display range forms are different according to different 3D source data formats.

  • XYZ/XYY Columns in Worksheet

When the source data format is XYZ/XYY Columns in Worksheet, the display range form can be X value range or row index, specifying the x data range or number of data rows to be displayed. Please note, if the X is not monotonic, the By X option will not be available.


  • Matrix Window/Virtual Matrix in Worksheet

When the source data format is Matrix Window or Virtual Matrix in Worksheet, the display range form is column index and row index, specifying the dimension of the datasets to be displayed.