When using WPS Sparklines on macOS, common questions usually focus on chart types, cell limits, and usage scenarios; this FAQ includes 3 common questions and 3 glossary terms.
FAQ
What is the difference between a sparkline and a regular chart?
- A sparkline is embedded inside a worksheet cell and is mainly used for quick trend display.
- A regular chart is a separate chart object that usually includes axes, legends, and other full chart elements.
- If you want a compact trend view inside a table, use sparklines. If you need more detailed analysis, use a regular chart.
Can one cell contain multiple sparklines?
- One cell usually displays only one sparkline.
- If you need to show multiple trends, place the sparklines in separate target cells.
- You can also select multiple target cells to generate corresponding sparklines for multiple rows or columns of data.
Which sparkline types are supported?
- Line sparklines are supported for showing continuous trends.
- Column sparklines are supported for showing value comparisons.
- Win/loss sparklines are supported for showing positive and negative outcomes or result distribution.
Glossary
| Term | Definition |
|---|---|
| Sparkline | A miniature chart embedded in a worksheet cell to show the trend or distribution of a data series quickly. |
| Data Range | The source cell range referenced when creating a sparkline. |
| Placement Location | The target cell or target range where the sparkline is displayed. |