How to Use WPS Sparklines on macOS

This how to use WPS Sparklines on macOS guide includes 5 topics that can all be completed in WPS Sheets for Mac; 5 are free and 0 are membership-related.

How-to Index

How-to Guide

1. Insert a Line Sparkline

Entry point: Insert → Sparklines drop-down button → Line

1. Select the target cell where you want to place the sparkline, such as H2.
2. Click the Insert tab.
3. Click the drop-down button below Sparklines.
4. Select Line.
5. In the Create Sparklines window, select the data range to analyze, such as B2:G2.
6. Confirm that the location range is the target cell you selected earlier.
7. Click OK to finish.

Success Criteria

• UI state: A Line sparkline appears in the target cell.
• Next actions: You can select the sparkline and continue with style changes or fill operations.

Tips While Using

• Common mistakes: If you do not select the target cell first, the location range may not match what you expect.
• Environment limits: The file must be in XLSX format.

2. Insert a Column Sparkline

Entry point: Insert → Sparklines drop-down button → Column

1. Select the target cell where you want to place the sparkline, such as H2.
2. Click the Insert tab.
3. Click the drop-down button below Sparklines.
4. Select Column.
5. In the Create Sparklines window, select the data range to analyze, such as B2:G2.
6. Confirm that the location range is the target cell you selected earlier.
7. Click OK to finish.

Success Criteria

• UI state: A Column sparkline appears in the target cell.
• Next actions: You can continue changing colors, styles, or marker display.

Tips While Using

• Common mistakes: If the data range and location range do not match in size, the sparkline may not be created correctly.
• Environment limits: The file must be in XLSX format.

3. Insert a Win/Loss Sparkline

Entry point: Insert → Sparklines drop-down button → Win/Loss

1. Select the target cell where you want to place the sparkline, such as H2.
2. Click the Insert tab.
3. Click the drop-down button below Sparklines.
4. Select Win/Loss.
5. In the Create Sparklines window, select the data range to analyze, such as B2:G2.
6. Confirm that the location range is the target cell you selected earlier.
7. Click OK to finish.

Success Criteria

• UI state: A Win/Loss sparkline appears in the target cell.
• Next actions: You can continue switching types or adjusting the display style.

Tips While Using

• Common mistakes: Using data that does not fit a win/loss view can make the result harder to read.
• Environment limits: The file must be in XLSX format.

4. Edit a Sparkline

Entry point: Select the sparkline → Sparkline tools

1. Select the cell that contains the sparkline.
2. Open the related Sparkline tools on the ribbon.
3. Change the sparkline type as needed between Line, Column, and Win/Loss.
4. Set display options such as high points, low points, negative points, or markers.
5. Adjust the sparkline color and style.

Success Criteria

• UI state: The sparkline style or type updates based on your settings.
• Next actions: You can copy it to other cells or save the file.

Tips While Using

• Common mistakes: If the sparkline cell is not selected first, the related tools may not appear.

5. Delete a Sparkline

Entry point: Right-click the cell → Clear Contents → All

1. Right-click the cell that contains the sparkline.
2. Select Clear Contents.
3. Select All to remove it.

Success Criteria

• UI state: The sparkline is removed from the cell.
• Next actions: You can insert a new sparkline or enter other content in the cell.

Tips While Using

• Common mistakes: Before clearing all contents, confirm whether the cell also contains data you want to keep.