How to Use WPS PivotChart on Windows

Use WPS PivotChart with 2 how-to topics, both available directly in WPS Sheets; choose a topic from the index and follow the steps in order.

How-to Index

How-to Guide

1. Create a PivotChart

Entry point: Insert tab → PivotChart button

1. Select any cell in the source data range.
2. Click the PivotChart button on the Insert tab.
3. In the dialog box, confirm the data range and chart type.
4. Click OK.

Success Criteria

• UI state: A PivotChart is inserted successfully and opens in a chart view that can be used for further analysis.
• Next actions: You can continue adjusting the chart type, fields, or filter conditions.

Tips While Using

• Common mistakes: If a valid data range is not selected first, you may need to confirm the range again.
• Environment limits: The source data should have clear field headers for later summarization and display.

2. Create a Chart from a PivotTable

Entry point: Analyze tab → PivotChart button

1. Select an existing PivotTable.
2. Click the PivotChart button on the Analyze tab.
3. Choose a chart type.
4. Click OK.

Success Criteria

• UI state: A chart is created from the current PivotTable.
• Next actions: After the PivotTable changes, the chart can reflect the updated results.

Tips While Using

• Common mistakes: If the PivotTable area is not selected, the related creation flow may not open directly.
• Environment limits: This method requires an existing PivotTable first.