Use WPS Pivot Chart with 2 how-to topics, both available without membership, and follow the index below to complete each task.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Create a Pivot Chart | Free |
| 2 | 2. Create a Chart from a PivotTable | Free |
How-to Guide
1. Create a Pivot Chart
Entry: Insert tab → Pivot Chart
- Select any cell in the source data range.
- Click Pivot Chart on the Insert tab to open the setup dialog.
- Confirm the data range and chart type.
- Click OK to create the chart.
Success Criteria
- Interface result: A new Pivot Chart is inserted.
- What you can do next: You can continue reviewing the chart type, fields, or analysis result.
Tips While Using
- Common mistake: If you do not select a valid data range first, the chart may not be created correctly.
- Environment note: The source data should have clear field headers for summary analysis.
2. Create a Chart from a PivotTable
Entry: Analyze tab → Pivot Chart
- Select an existing PivotTable.
- Click Pivot Chart on the Analyze tab.
- Select the chart type you want.
- Click OK to finish.
Success Criteria
- Interface result: A chart is created from the current PivotTable.
- What you can do next: When the PivotTable changes, the chart can reflect the updated result.
Tips While Using
- Common mistake: If the PivotTable itself is not selected, you may enter a regular chart workflow instead.
- Environment note: An available PivotTable is required before starting this task.