WPS Spreadsheet · Charts and visualization · Beginner
Create and compare in-cell sparklines in WPS Spreadsheet
Build line, column and win/loss mini charts without confusing trend shape with magnitude.
Documentation-based procedure; synthetic checks independently verified; no native application execution · Editorial standards
Quick answer: In an XLSX workbook, select an empty destination cell and choose Insert > Sparklines, then a chart type. Supply the source row and confirm the location. Use line or column sparklines for values; use win/loss when only positive versus negative direction matters.
Prerequisites
This guide follows the Windows Sheet Editing controls in the WPS Docs Center. The source does not name a numeric application build. Use an XLSX practice workbook: WPS documents that XLS does not support sparklines. No browser, mobile or other desktop-platform parity is implied.
A sparkline belongs inside a cell. A floating pie chart resized until it covers a cell is not the same feature and is outside this tutorial. Reserve empty destination cells so clearing a practice visual cannot erase a value you need.
Set up comparable source rows
Enter these values in A1:E4:
| Team | Week 1 | Week 2 | Week 3 | Week 4 |
|---|---|---|---|---|
| North | 10 | 20 | 15 | 30 |
| South | 100 | 200 | 150 | 300 |
| Balance | -2 | 3 | -1 | 4 |
Put Trend in F1, Values in G1 and Direction in H1. Leave F2:H4 empty. North and South have the same proportional pattern but very different magnitudes. Balance is a signed series for testing direction, not a sales total.
Before inserting visuals, read the numbers aloud or calculate their totals: North is 75, South is 750, and Balance is 4. A sparkline is a compact explanation of sequence, not a replacement for those underlying numbers.
Create and inspect the visuals
- Select F2 and choose Insert > Sparklines > Line.
- In Create Sparklines, set the data range to B2:E2. Confirm the location is F2 and click OK.
- Repeat for F3 with data B3:E3. Create each separately here so the source-to-destination mapping is unambiguous.
- Select G2 and use Insert > Sparklines > Column with B2:E2. Confirm the destination is G2.
- Select H4 and use Insert > Sparklines > Win/Loss with B4:E4. Confirm H4 as the location.
- Select F2 and open Sparkline Tools. Turn on useful point markers, such as the high or low point, and choose a readable style. Apply the same visual treatment to F3 if you want to compare the two trends.
The North line should rise, dip, then rise to its highest point. The North column sparkline should have four bars, with the last tallest and the first shortest. Balance should show a negative, positive, negative, positive sequence in its win/loss view.
Compare without overstating the result
North and South may look very similar despite their tenfold difference in values. Do not infer equal totals from similar mini-chart heights: the source numbers remain the authority. This guide does not assume an undocumented shared-axis setting. Keep values visible, and use a full chart with an explicit scale when cross-row magnitude is the main question.
Change E2 from 30 to 5. North’s line and column visuals should now end at the lowest value, and its total becomes 50. South should remain unchanged. Next, change C4 from 3 to 30. The Balance series total becomes 31, but the win/loss sequence still has the same signs. That is precisely why win/loss is unsuitable for comparing magnitude.
Troubleshooting and saving
If a mini chart appears in the wrong row, inspect its data and location choices. If a command is unavailable, check the file format and whether you are in the documented Windows editing interface. Do not convert your only original file merely to experiment.
Save the completed main workbook as XLSX, reopen it, and verify all four sparklines in F2, F3, G2 and H4 alongside the changed source values. Keep this intact workbook as your result.
For an optional removal test, first use Save As to create a separately named experimental copy. In that copy only, right-click F2 and choose Clear Contents > All, as documented by the Windows guide. F2 should lose its line sparkline; F3, G2 and H4 should retain their visuals, and B2:E4 should remain unchanged. Check that F2 contains no other content you need before clearing it. Close the experiment and return to the intact main workbook before exporting your report.
Related guides
Review numeric inputs with number and date formatting. Use printing and PDF output to check that small visuals remain legible in a final report.
Official references
- WPS Docs Center: sparklines requirements on Windows (source captured 2026-10-20).
- WPS Docs Center: insert and edit sparklines on Windows (source captured 2026-10-20).