Sparklines

Sparklines are small charts located inside separate cells. Sparklines can be used to show trends in data series.

NOTE. Sparklines are available in all tools, except for the Reports tool.

Sparklines are used to visually present large datasets. Sparklines can be displayed for table columns, rows, and totals.

Displaying Sparklines

To display sparklines by rows or columns, select the By Rows/By Columns checkbox in the drop-down menu of the Sparklines button in the Elements group on the Table ribbon tab. If the By Rows/By Columns checkbox is selected, sparklines can be displayed for totals. To display sparklines for totals, select the Show for Totals checkbox.

NOTE. Row or column totals must be displayed to be able to display sparklines for totals.

Example of using sparklines for rows and columns:

Hiding Sparklines

To hide sparklines:

Select the Reset item in the drop-down menu of the Lines button on the Table ribbon tab.

NOTE. The Reset item deselects the By Rows and By Columns checkboxes, but does not affect the Show for Totals checkbox.

Deselect the By Rows/By Columns/Show for Totals checkbox in the drop-down menu of the Sparklines button on the Table ribbon tab.