Pivot Table Issues

Create a WPS Spreadsheet Pivot Chart With Totals for All Years

Kushani Nimanthika Nov 12, 2026 869 views

Question details

Create a pie PivotChart that displays category or product totals combined across every year in the source data.

Create a WPS Spreadsheet Pivot Chart Showing Totals for All Years

Product: WPS Spreadsheets
Device & OS: not provided
Scenario: A PivotTable includes years as column labels, and the user wants a chart that summarizes each category across the full date range.
Observed behavior: A pie chart based on the PivotTable may display data for only one year instead of totals for all years.

Before you start

Confirm that your source data includes a category or product field and a numeric amount, sales, or profit field. Keep the original PivotTable if you still need its year-by-year breakdown; the chart requires a separate summary PivotTable.

Solution 1Recommended

Create a separate PivotTable without the Year field

Use this method when a pie chart should show one slice per category or product, with values totaled across all years.

A pie chart works best with one category field and one total value field. Removing Year from the chart source PivotTable lets WPS Spreadsheets aggregate the values for every available year.

Insert a second PivotTable

Select any cell in the original source data, then go to Insert > PivotTable and choose where to place the new PivotTable.

Add the category field to Rows

In the PivotTable Fields pane, drag Product, Category, or the field you want to compare into the Rows area.

Add the numeric field to Values

Drag Profit, Amount, Sales, or another numeric field into the Values area, and confirm that its calculation is set to Sum if needed.

Leave Year out of the PivotTable

Do not drag Year into Rows, Columns, Filters, or Values. The PivotTable will now calculate one combined total for each category across all years.

Create the pie PivotChart

Click inside the new PivotTable, then select Insert > Chart > Pie. Use the category labels and summed values from this second PivotTable as the chart source.

Create a separate PivotTable without the Year field

All-year totals are displayed: Each pie slice now represents the total for one category or product across every year included in the source data.

Create summary charts in WPS Spreadsheets

Build an All-Years PivotChart in WPS Spreadsheets

WPS Spreadsheets lets you create a separate PivotTable for a clean all-years summary, then turn the totals into a pie chart. Keep Year out of the summary layout so WPS combines the values before charting them.

1. Open the source workbook: Open your data file in WPS Spreadsheets and click a cell within the source data range.
2. Create a PivotTable: Select Insert > PivotTable and insert a new PivotTable on a new worksheet or an empty area.
3. Set up all-years totals: Place Category or Product in Rows and place the numeric measure in Values; do not add Year to the PivotTable fields.
4. Insert a pie chart: Select the summary PivotTable, then choose Insert > Chart > Pie to create a chart of the combined totals.

Create PivotTables that total categories across all yearsBuild pie charts from concise PivotTable summariesOpen and edit Microsoft Excel .xlsx and .xls PivotTable filesUse a familiar spreadsheet interface for data analysis and charts

microsoft office alternative - wps office

Frequently Asked Questions

Why does my pie PivotChart show only one year?

If Year is placed in the Columns, Rows, or Filters area of the PivotTable, the chart can use a single year series or selection. Create a separate PivotTable without Year to chart combined totals.

Can I keep my original year-by-year PivotTable?

Yes. Leave the original PivotTable unchanged and insert a second PivotTable from the same source data. Use the second one only for the all-years chart summary.

Which fields should I use for an all-years pie chart?

Place the item you want to compare, such as Product or Category, in Rows. Place a numeric field such as Sales, Amount, or Profit in Values, usually summarized by Sum.

How do I change the PivotTable value calculation to Sum in WPS Spreadsheets?

In the PivotTable Fields pane, open the options for the field in the Values area and choose Value Field Settings or Summarize Values By, then select Sum.

Can I use a column chart instead of a pie chart for all-year totals?

Yes. Select the summary PivotTable and choose Insert > Chart, then select Column, Bar, or another chart type. The key requirement is still to exclude Year from the summary PivotTable.

Excel & Data Problems