Pivot Table Issues

How to Create Multiple Pivot Charts from the Same Excel Data

Ayan Masood Oct 12, 2026 868 views

Question details

The user wants to generate multiple independent Pivot Charts from a single data source without their filters and fields being linked to one another.

How to Create Multiple Pivot Charts from the Same Excel Data

Product: Spreadsheet
Device & OS: not provided
Scenario: Creating distinct dashboard visualizations or reports where different charts need to display different metrics and filters from the same underlying dataset.
Observed behavior: When copying and pasting an existing PivotChart, it remains linked to the original PivotTable, meaning any changes to fields or filters automatically update all copied charts.

Before you start

Ensure your source data is organized in a proper tabular format with distinct column headers, no blank rows, and no empty columns before inserting any PivotTables.

Solution 1Recommended

Create Separate PivotTables for Each Chart

The most straightforward and reliable method is to generate independent Pivot Charts by basing each chart on its own distinct PivotTable.

By default, Excel and WPS Spreadsheet link a PivotChart directly to the PivotTable it was created from. To have charts with different filters, you must separate their underlying data structures by creating multiple PivotTables.

Insert the first PivotTable

Select your source data range, go to the 'Insert' tab, and click 'PivotTable'. Choose a destination (like a new worksheet) and click 'OK'.

Duplicate the PivotTable

Highlight the entire first PivotTable you just created, press Ctrl+C to copy it, select a new empty cell area, and press Ctrl+V to paste a completely independent copy.

Insert the first PivotChart

Click anywhere inside your first PivotTable, navigate to the 'Insert' tab, and select 'PivotChart' to generate your first visualization.

Insert the second PivotChart

Click inside the second (copied) PivotTable, insert another PivotChart, and use the Field List to adjust fields and filters independently without affecting the first chart.

Create Separate PivotTables for Each Chart

Data Cache Optimization: Copying and pasting an existing PivotTable shares the underlying data cache, which keeps your spreadsheet file size optimized while allowing independent chart filters.

Solution 2

Use the Data Model (Power Pivot)

Load your data into the Data Model to create multiple Pivot Charts directly without cluttering your worksheet with multiple visible PivotTables.

Advanced Data Visualization

Easily Create and Manage Pivot Charts with WPS Spreadsheet

WPS Spreadsheet provides a highly intuitive and powerful interface for analyzing complex datasets. You can quickly duplicate PivotTables to create dynamic, independent charts and build professional dashboards in minutes.

1. Open Data: Launch WPS Spreadsheet and open the document containing your raw source data.
2. Insert PivotTable: Highlight your data, navigate to the 'Insert' tab, and click 'PivotTable' to generate the initial summary table.
3. Duplicate the Table: Select the newly created PivotTable, copy it, and paste it into a separate blank area on the same or a new worksheet.
4. Create Charts: Select each PivotTable individually, click 'Chart' under the 'Insert' tab, and customize your independent visualizations.

100% compatibility with Microsoft Excel formats (.xls, .xlsx, .csv)Intuitive drag-and-drop PivotTable and PivotChart Field ListLightweight application with exceptionally fast data processing speedsRich library of built-in chart templates for professional reporting

microsoft office alternative - wps office

Frequently Asked Questions

Why do my Pivot Charts change together when I apply a filter?

This happens because both charts are connected to the exact same underlying PivotTable. Any layout or filter changes applied to the PivotTable (or one of the charts) will reflect across all linked charts. You must create separate PivotTables for each chart to isolate their filters.

Can I use the same data cache for multiple PivotTables to save file size?

Yes. When you copy and paste an existing PivotTable to a new location in your spreadsheet, the application automatically shares the underlying data cache. This allows you to have multiple independent tables and charts without unnecessarily increasing the file size.

Is it possible to connect multiple independent Pivot Charts to a single Slicer?

Yes. Once you have created separate PivotTables (from the same data source) for your independent charts, you can insert a Slicer. Right-click the Slicer, select 'Report Connections', and check the boxes for all the PivotTables you want the slicer to control simultaneously.

Excel & Data Problems