How to Use the Graphical Table

To create a new graphical table:

1. On the authoring bar, click    to open the Visualization types flyout.

2. Drag the Graphical table visualization to the wanted position on the analysis page.

   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 graphical table to display the items of your choice.

To add columns to a graphical table:

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.

   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.

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

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

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

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

7. When you are done, click Close.

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

To change column order:

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

   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.

To change the column width:

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

   Response: The cursor changes into a double-arrow.

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

   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.

To change row height:

1. Place the mouse pointer between two rows in the graphical table, press and hold the mouse button.

2. Adjust the height by dragging the red line to the desired row height, then release the mouse button.

Response: The rows in the graphical table adjust to the new height.

Note: The height of the header row is adjusted separately.

To remove a column:

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

To sort the rows:

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.

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

To copy marked rows:

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

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

   Response: Information about the marked rows is copied to the clipboard. For sparklines, the starting 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.