Feature Summary

Sparklines can generate small charts within a single cell to visually display data trends, supporting three types: Line, Column, and Win/Loss.

Feature Description

Feature Dimension Description
Membership Restriction No version restriction
Version Restriction File must be in XLSX format (XLS format does not support sparklines)

Operation Steps

Insert a Line Sparkline

Feature Entry
"Insert" tab → Drop-down button below the "Sparklines" button → "Line" option

  1. Select the target cell where you want to insert the sparkline (e.g., H2)
  2. Click the Insert tab
  3. Click the drop-down button below the "Sparklines" button
  4. Click the "Line" option again
  5. In the pop-up "Create Sparklines" window, select the data range to be analyzed (e.g., B2:G2)
  6. Confirm the location range is the pre-selected target cell
  7. Click OK to complete the insertion

【EN】WPS Sheets Sparklines Feature User Guide_截图01

Insert a Column Sparkline

Feature Entry
"Insert" tab → Drop-down button below the "Sparklines" button → "Column" option

  1. Select the target cell where you want to insert the sparkline (e.g., H2)
  2. Click the Insert tab
  3. Click the drop-down button below the "Sparklines" button
  4. Click the "Column" option again
  5. In the pop-up "Create Sparklines" window, select the data range to be analyzed (e.g., B2:G2)
  6. Confirm the location range is the pre-selected target cell
  7. Click OK to complete the insertion

【EN】WPS Sheets Sparklines Feature User Guide_截图02

Insert a Win/Loss Sparkline

Feature Entry
"Insert" tab → Drop-down button below the "Sparklines" button → "Win/Loss" option

  1. Select the target cell where you want to insert the sparkline (e.g., H2)
  2. Click the Insert tab
  3. Click the drop-down button below the "Sparklines" button
  4. Click the "Win/Loss" option again
  5. In the pop-up "Create Sparklines" window, select the data range to be analyzed (e.g., B2:G2)
  6. Confirm the location range is the pre-selected target cell
  7. Click OK to complete the insertion

【EN】WPS Sheets Sparklines Feature User Guide_截图03

Edit Sparklines

Feature Entry
Select the sparkline → "Sparkline Tools" tab

  1. Select the cell containing the sparkline, and the "Sparkline Tools" tab will appear on the ribbon
  2. You can modify the sparkline type (Line/Column/Win/Loss)
  3. You can set the display of high points, low points, negative points, markers, etc.
  4. You can adjust the color and style of the sparkline

【EN】WPS Sheets Sparklines Feature User Guide_截图04

Delete Sparklines

  1. Right-click the cell containing the sparkline
  2. Select "Clear Contents" → "All" to delete it

【EN】WPS Sheets Sparklines Feature User Guide_截图05

Frequently Asked Questions

Question 1: What should I do if the Sparklines option is grayed out?

  • Solution: Sparklines do not support the XLS format. Save the file in XLSX format and reopen it to use the feature.

Question 2: What is the difference between sparklines and regular charts?

  • Solution: Sparklines are embedded within a single cell, are compact and lightweight, and are suitable for displaying data trends; regular charts occupy a separate area, have more complete functionality, and are suitable for detailed data visualization.

Question 3: Can sparklines be generated in batches?

  • Solution: Yes. After inserting one sparkline, drag the fill handle at the bottom-right corner of the cell downward to fill, and corresponding sparklines will be generated in batches for each row of data.

Notes

  • The data source for a sparkline supports a maximum of 128 data points
  • Each sparkline displays the trend of only one data series