Skip to main content


Adaptive Insights LLC.

Show Sparklines in Sheets

Describes how to add and show line  or bar charts, also known as sparklines, in standard and cube sheets.

Sparklines offer a quick view of the trends associated with account values on standard and cube sheets. When turned on, they appear in the first column of the sheet. Click the sparkline cell to see a larger, more detailed version. For editable sheet values, users can drag and drop points on the trend line as a way of doing visual data entry.

Before You Begin

You must use a cube or standard sheet to show sparklines.

How You Get There

Compass.png From the nav menu select Sheets, Assumptions, or Processes. Once you open a sheet, select a version and choose a level. You must choose a leaf level to edit cells.

See Open Sheets and Get to Editable Cells.

Show Sparklines

To turn sparklines on:

  1. Click Display Options displayOptions.png.
  2. Click the Sparklines tab.
  3. Select line chart format or bar chart format.
  4. Click OK.
  5. Click the cell with the chart to open an expanded view of the sparkline.

Edit Data with Sparklines

  1. Click the cell with the sparkline to open the expanded view. 
  2. Click any point on the chart and drag it up or down. The value appears in the corresponding cells. 

Edit data with sparklines

  • Was this article helpful?