How to Create Multiple Regular Charts from One PivotTable in WPS Office Spreadsheets
Question details
The user wants to create several customized charts from one Excel-compatible PivotTable without duplicating the PivotTable for each chart, while keeping source data and queries automated.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- Product-specific sales comparison charts must be generated from a single PivotTable and continue updating when the PivotTable refreshes.
- Observed behavior
- The goal is for multiple charts to link to a stable data range instead of breaking when PivotTable columns change, and for chart titles and labels to update dynamically.
Before creating multiple charts, review the PivotTable layout and identify the rows or columns that are stable enough to use as chart source data. If the PivotTable structure may move, prepare a small helper table or named range to hold the chart ranges.
Link Each Chart to a Stable Helper Range or Table
Use this method when you need multiple charts from one PivotTable and want to prevent them from breaking when the PivotTable layout changes.
Charting directly from a PivotTable can cause series to shift when fields are rearranged. A helper range or table creates a stable middle layer between the PivotTable and your charts, so each chart keeps a consistent source.
In WPS Office Spreadsheets, add a new worksheet or use an empty area and build a small table that references the PivotTable cells you need with formulas such as =PivotSheet!B5.
Select the helper range, click Insert > Chart, choose a suitable chart type, and size the chart as needed.
Create additional charts by selecting the corresponding helper columns or rows, then choose Insert > Chart again and customize each chart for its product-specific comparison.
After updating the source PivotTable, refresh the data connection or recalculate formulas so the helper range and charts reflect the latest values.
Link Chart Titles and Labels to Worksheet Cells
Use this technique when you want chart titles, notes, and labels to update automatically from a cell value instead of editing each chart manually.
Use a Query or Helper Table for Frequently Changing PivotTable Columns
Choose this approach when the PivotTable structure changes often and direct chart ranges would become unreliable.
Create Multiple Stable Charts from One PivotTable in WPS Office Spreadsheets
WPS Office Spreadsheets lets you build several Excel-compatible charts from a single PivotTable by linking each chart to a helper range or table, and by connecting titles and labels to worksheet cells. This keeps your product comparison charts automatically updated while preserving the familiar Excel workflow.
- 1. Open your PivotTable workbook: Launch WPS Office Spreadsheets and open the workbook containing the PivotTable you want to chart.
- 2. Create a stable helper range: On a new sheet, reference the required PivotTable cells into a fixed helper table.
- 3. Insert multiple charts: Select each helper range and go to Insert > Chart to create product-specific comparison charts.
- 4. Link dynamic titles: Select a chart title, click the formula bar, type =, and select the cell containing the dynamic title text.
- 5. Save and refresh: Save the workbook as an Excel-compatible file and refresh data after PivotTable changes to update every chart.
Frequently Asked Questions
Can I create multiple charts from one PivotTable without making a new PivotTable for each chart?
Yes. Link each chart to a stable helper range or table that references the PivotTable. Then insert as many charts as needed from the helper range using Insert > Chart.
How do I make a chart title automatically update from a cell in WPS Office?
Select the chart title, click in the formula bar, type =, and then click the worksheet cell containing the title. The title will update whenever that cell changes.
Why do my charts break when I change the PivotTable layout?
Charts fail when they reference PivotTable cells directly because the series range can shift. Use a fixed helper table or query output as the chart range to keep series stable.
Can I use dynamic labels or notes on charts in WPS Office?
Yes. Select the shape or text label placed on the chart, click the formula bar, type =, and select a cell. This creates a dynamic label linked to that cell.
Will these charts remain compatible with Microsoft Excel?
Yes. WPS Office Spreadsheets supports Excel file formats, so workbooks containing PivotTables, helper ranges, and charts can be saved as XLSX and opened in Microsoft Excel.
