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.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.
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:
To hide sparklines, open the drop-down menu of the Sparklines button on the Table ribbon tab:
Select the Reset item.
NOTE. If the By Rows and By Columns, Show For Totals checkboxes are selected at the same time, the By Rows and By Column checkboxes are deselected, the Show For Totals checkbox is disabled but sparklines for totals are also hidden. If one of the checkboxes By Rows or By Columns is selected again, the Show For Totals checkbox is enabled and the table automatically displays sparklines for totals by rows and by columns. The Show For Totals checkbox can be deselected only if one of the checkboxes By Rows or By Columns is selected.
Deselect the By Rows or By Columns or Show For Totals checkbox.
See also: