How to Use WPS Pivot Chart on macOS

Last updated:July 16, 2026

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.TopicMembership Requirement
11. Create a Pivot ChartFree
22. Create a Chart from a PivotTableFree

How-to Guide

1. Create a Pivot Chart

Entry: Insert tab → Pivot Chart

  1. Select any cell in the source data range.
  2. Click Pivot Chart on the Insert tab to open the setup dialog.
  3. Confirm the data range and chart type.
  4. 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

  1. Select an existing PivotTable.
  2. Click Pivot Chart on the Analyze tab.
  3. Select the chart type you want.
  4. 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.