When using WPS PivotChart, common questions usually focus on feature differences, setup requirements, and linked updates; this section includes 3 common questions and a glossary.
FAQ
What is the difference between a PivotChart and a regular chart?
- A PivotChart is created from a PivotTable or a related summary workflow.
- It can update along with changes made to the PivotTable.
- A regular chart is more suitable for displaying raw data or standard summaries, with a different interaction model.
Why can’t I create the chart I want directly from the current range?
- First, confirm that the selected range is valid and that the field headers are complete.
- Then check whether you entered the feature from the PivotChart command on the Insert tab.
- If you want to create a chart from a PivotTable, select an existing PivotTable first.
What happens to the chart after I change the PivotTable?
- The PivotChart updates along with changes to the PivotTable.
- You can continue changing fields, categories, or filters to review different results.
- If the result is not what you expected, check the current summary method and filter state in the PivotTable first.
Glossary
| Term | Definition |
|---|---|
| PivotChart | A chart created from a PivotTable or pivot-based analysis result to display summarized data more visually. |
| PivotTable | A worksheet analysis structure used to categorize, summarize, filter, and calculate source data. |
| Chart type | The display form of a chart, such as a column chart or line chart, with different types suited to different kinds of data presentation. |