10.1.3 Data Highlighter: Selecting Points in both Graph and Source Worksheet

Use the Data Highlighter tool Button Data Highlighter.png (Tools toolbar) to select plotted data points in your 2D graph and simultaneously highlight the corresponding data rows in the source sheet; or you can select rows of data in the worksheet and highlight corresponding points in plots of that data.

Tools toolbar split button data highlighter.png

For 2D line/symbol/column plots with multiple plots in the layer, clicking on a plot in the graph window or Object Manager will simultaneously dim other plots in the layer and highlight (select) the source data in the worksheet. If you prefer not to have the worksheet data highlighted when you select a plot, set the LabTalk system variable @PS = 0. See FAQ-708 How do I permanently change the value of a system variable?

Highlighting Points in the Graph

  1. Activate the graph window, then pick the Data Highlighter tool Button Data Highlighter.png from the Tools toolbar.
  2. Click on a point in your graph window. Unselected data points in the graph window will be dimmed. The corresponding row of worksheet data will be highlighted while corresponding rows of unselected data points will be dimmed.
  • While in selection mode on the graph, you can use the left and right arrow keys to move the selection to the previous or next point, by row index.
  • To select multiple random points in the graph, press CTRL + while clicking with the mouse.
  • To select group of points in the graph, drag out an area with the mouse. While the Data Highlighter tool is active, use the spacebar to toggle between rectangular and free-form selection modes.
Data highlighter rectangle vs freeform.png

Highlighting Points in the Worksheet

  1. Activate the workbook window, then pick the Data Highlighter tool Button Data Highlighter.png from the Tools toolbar.
  2. Click on a row in the worksheet to highlight all data plots of row data (can be multiple graph windows). Unselected data points in the graph window(s) and worksheet will be dimmed.
  3. While in selection mode in the worksheet, press the left and right arrow keys to move the selection to the previous or next row; simultaneously, you will move the selection to the corresponding data point in the graph window(s).
  4. To select multiple random rows in the worksheet, press CTRL while clicking on desired rows with the mouse; to select multiple contiguous rows, press SHIFT while clicking on the first and last desired rows or drag rows with your mouse.

Further Operations

Note that highlighted worksheet data rows remains selected even after exiting Data Highlighter mode (press ESC or click on the Pointer tool Button Pointer.png). This allows you to further operate on the data. The following actions are supported:

  • Clearing Cells: Right-click on the worksheet selection and choose Clear from the shortcut menu; or press the DELETE key. Leaves worksheet cells.
  • Deleting Rows: Right-click on the worksheet selection and choose Delete Rows. Removes worksheet cells.
  • Masking Data: Click Column: Mask or click the Mask button Button Mask Range.png on the Mask toolbar. Other masking-related operations are also supported.
  • Copying Data: To copy only data in the data rows of the worksheet, press CTRL + C or right-click on the selection and choose Copy. To copy the worksheet column label row information along with the data row selection, open the Script Window (Window: Script Window) and type the following:
wcopy -d
In the wcopy dialog that opens, make sure that the Copy Data check box is selected, then specify the Output Worksheet and click OK.