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, then right-click and select Edit Range in the context menu. This opens the Range dialog box.
    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 (X must be monotonic); 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

Open the Range dialog box right-clicking on a 3D plot and selecting Edit Range.

  • Matrix or virtual matrix data: If monotonic in both X and Y dimensions, the user can edit range By Value. Otherwise, limit editing of range to row index values (By Index).
Matrix-edit-range-haha.png
  • XYZ data: If monotonic in the X dimension, allow editing range by X values (By X); if monotonic in the Y dimension, allow editing range by Y values (By Y). Otherwise, limit editing of range to row index values (By Index).
Workbook-edit-range-haha.png
  • XYY data: If monotonic in the X dimension, allow editing range by X values (By X). Otherwise, limit editing of range to row index values (By Index).
Workbook-edit-range-xyy.png