To create a new graphical table:
Click on the New Graphical Table button on the toolbar, .
Comment: You can also select Insert > New 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.
Adjust the table to display the items of your choice.
To add columns to a graphical table:
Right-click on the graphical table to display the pop-up menu.
Select Add to view the submenu.
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.
Right-click on the new column to open the pop-up menu.
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.
Make the necessary changes to the settings dialog so that the new column shows the information you want.
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:
Click on 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 on 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 on 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:
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.
Adjust the width by holding down the mouse button and moving the mouse horizontally.
Comment: You can also right-click on the column header and select Column Width... from the menu that appears. Enter the width in pixels and click OK.
To remove a column:
Right-click on a column header and select Remove.
To sort the rows:
Click on 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 on 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 change row height:
Right-click on the graphical table to display the pop-up menu.
Select Properties.
Go to the Appearance page.
Increase the Additional row spacing (in pixels).
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.
Click Close.
To copy marked rows:
Mark the rows of interest in the graphical table.
Right-click and select Copy from the pop-up menu.
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: