How to Use the Graphical Table


  1. Click the Graphical Table button on the toolbar, gt_new_graphical_table_button.png.

  2. Comment: You can also select Insert > Visualization > Graphical Table from the menu.

    Response: A graphical table showing one column is created. You can change which item type to be used as default under Tools > Options > Graphical Table.

  3. Adjust the table to display the items of your choice.

  1. Right-click the graphical table to display the pop-up menu.

  2. Select Add to view the submenu.

  3. Select the type of dynamic item you want to add: Sparkline, Calculated Value, Icon, or Bullet Graph.

  4. Response: A new column with the selected type of item is added to the graphical table. A first attempt to set up a suitable column is made by the application, but you probably want to adjust the settings.

  5. Right-click the new column to open the pop-up menu.

  6. Depending on the type of item you added, select either Sparkline Settings, Calculated Value Settings, Icon Settings, or Bullet Graph Settings.

  7. Comment: Note that each item added to a graphical table has its own settings.

  8. Make the necessary changes to the settings dialog so that the new column shows the information you want.

  9. When you are done, click Close.

  10. Comment: You can also add new columns by using drag-and-drop. See Drag-and-Drop to learn more.

  1. Click a column header and drag that column to the desired position. Note that the row header column cannot be moved.

  2. Comment: You can also right-click a column header and select Move First or Move Last from the pop-up menu.
    Comment: You can also go to the Axes page in the Graphical Table Properties dialog and click a column in the Columns list and then click Move Up or Move Down to change the order of the columns.

  1. Place the mouse pointer at the right edge of the column header you want to resize (indicated by a thin line).

  2. Response: The cursor changes into a double-arrow.

  3. Adjust the width by holding down the mouse button and moving the mouse horizontally.

  4. Comment: You can also right-click the column header and select Column Width... from the pop-up menu. Enter the width in pixels and click OK.

  1. Right-click a column header and select Remove.

  1. Click the header of the column you wish to sort the data by. You can sort by columns containing calculated values, icons (based on the underlying calculation), and bullet graphs (based on the underlying calculation of the values).

    Comment: Click again the column header to sort descending. Click once again to return to the original sort order.

  2. Comment: If a hierarchy is used on the graphical table row axis, then sorting will be performed within each category only.

  1. Right-click the graphical table to display the pop-up menu.

  2. Select Properties.

  3. Go to the Appearance page.

  4. Increase the Additional row spacing (in pixels).

  5. Comment: The row heights are automatically increased if the font size is increased. The Additional row spacing setting only needs adjustment if you want to add a few more pixels between the rows.

  6. Click Close.

  1. Mark the rows of interest in the graphical table.

  2. Right-click and select Copy from the pop-up menu.

  3. Response: Information about the marked rows is copied to the clipboard. For sparklines, the start point and end point Y-axis values are copied. For calculated values, the actual values are copied. For icons, any applied rules are displayed on the form of the shape and the specified HTML color code. For bullet graphs, the value representing the bar is copied, and if a comparative value exists this is also copied.

See also:

What is a Graphical Table?

Graphical Table Properties

How to Use Sparklines

How to Use Calculated Values

How to Use Icons

How to Use Bullet Graphs