When using WPS Scatter Chart, users often ask about 3 areas: suitable scenarios, data format, and collaboration display; this section includes 3 common questions and answers.
FAQ
What scenarios are scatter charts suitable for?
- Use a scatter chart when you need to review the relationship between two variables.
- Common examples include advertising spend and sales, height and weight, or experiment variables and results.
- If you want to review distribution, clusters, or outliers, a scatter chart is often more readable than a plain data table.
What data format does a scatter chart need?
- Prepare two or more columns of numeric data that can be used for chart plotting.
- A scatter chart usually uses numeric values to map X-axis and Y-axis points.
- Before inserting the chart, check that the selected range is complete and does not include unrelated blank content.
Can other collaborators see a scatter chart inserted in collaboration mode?
- After the chart is inserted in collaboration mode, it is saved in the current worksheet.
- Other collaborators who open the same worksheet can usually see the updated chart.
- If the chart does not appear right away, check the network connection and document sync status.
Glossary
| Term | Definition |
|---|---|
| Scatter Chart | A chart type that uses points to show the relationship between two sets of numeric values and helps review distribution and correlation. |
| Subtype | A specific display style within the same chart category, such as a standard scatter chart or a scatter chart with lines. |
| Collaboration Mode | A working mode in which multiple users can view and edit the same worksheet together. |