Highlight units (rows) selected from Graph

Select menu: Spread | Select | Highlight Rows Selected from Graph

You can highlight cells or rows within a spreadsheet using a selection of points made in a graph.

In the Graphics Viewer, select the points in the graph and copy them to the clipboard using the Data Information mode. In the spreadsheet you can then highlight the cells that correspond to these data points.


Graph with data points selected using Data Information mode	Source spreadsheet with corresponding values highlighted

To select the data points, from the Graphics Viewer select Tools | Data Information Mode (shortcut keys Ctrl+D).
Click the Point Selection button.
Click the data points of interest then from the Graphics Viewer menu select Edit | Copy Data Information.
Re-display your spreadsheet then select Spread | Select | Highlight Rows Selected From Graph.
Set options as required then click OK.

The menu items Next Selected Cell or Next Coloured Cell in the Spread | Select menu can be used to move to the next coloured or selected cell within your spreadsheet.

Highlighting method

Specifies the method used to highlight the points within the spreadsheet.

Colour cells – Colours the background of cells containing the points using a predefined colour. You can change this colour using the cell colours dialog.
Select cells – Selects the cells containing the points using the cell selection mode. In cell selection mode the background colour of selected cells is light blue by default. You can change this background colour by selecting Tools | Options | Fonts and Colours tab. From the dropdown list select Spreadsheets then in the Display items list select Cell selection background and change the colour as required.

Using

Specifies how the cells are to be selected or coloured.

Whole row – Highlight the cells in all the columns in a row.
Cells in 1 column – Highlight a single cell in just the column chosen from the dropdown list of columns (the list will become visible after you select this option).

Keep current coloured cells

Any existing cell colouring made using the colour cells method will be retained when new points are highlighted in the spreadsheet.

Highlight units (rows) selected from Graph

See also

Was this article helpful?