Sparkline chart

Sparklines are compact charts that show the trends and variations in the data, without taking up much space. They are widely used alongside pivot tables and help grasp trends and insights quickly. For instance, sparklines can be used to visualize the trend of sales figures, expenses, or other metrics across different categories or time periods.

Types of sparkline charts

  • Line
  • Bar
  • Area

Adding sparkline charts to pivot table

  1. Click the Sparkline option on the toolbar that is above the designer shelf.
  2. Choose any one of the below options from the drop-down:
    • Only Data: This is the default case, where only the data is generated according to the columns dropped in the designer shelf.
    • Only Sparkline: The data trends of the selected columns alone are shown in the report.

    • Sparkline with Data: The data trend and the data are also shown in the report.

  3. Click Generate Pivot Table.

Customizing sparkline chart

Follow the steps mentioned below to customize the sparkline chart:

  1. Access the Settings tab on the top right corner.
  2. Select the Format tab.
  3. In the Sparkline section:
    • Choose the Sparkline type. You can choose different Sparkline types for each column.
    • Choose the preferred Sparkline Color.
  4. Click Apply.

Note: The data values are grouped based on the dimensions of the column shelf. When multiple dimensions are dropped in the column shelf, a sparkline chart will be grouped and generated based on the last dimension in the column shelf. For instance, if Date(Year) and Date(Month) are dropped in the column shelf, then the sparkline chart is shown across Months for each Year.