How to Aggregate Pie Chart Slices by Location in WPS Office Spreadsheets
Question details
The user needs a pie chart that aggregates values by location only, so selecting multiple job positions does not create a separate slice for each location-position combination.

- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is building a pie chart with Location and Job Position fields and wants one combined slice per location after filtering multiple positions.
- Observed behavior
- Selecting multiple positions creates a separate slice for every location-position combination instead of a combined total per location.
Make sure your source data has one numeric value column to aggregate, such as Total Employees or Opportunity Total, and separate columns for Location and Job Position. Confirm that Job Position can be used as a slicer or filter instead of a chart category.
Aggregate Pie Chart Slices with a PivotChart and Use Job Position as a Filter
Use this method when your raw data contains multiple Job Position rows per Location, because it prevents the pie chart from creating a separate slice for every location-position combination.
A pie chart creates one slice for each category value. If both Location and Job Position are used as categories, every combination becomes its own slice. Moving Job Position out of the chart and into a filter returns one combined slice per location.
Open the workbook in WPS Office Spreadsheets and click any cell inside the data range that contains Location, Job Position, and Total Employees.
Go to the Insert tab and click PivotChart. Confirm the data range and choose where to place the PivotChart in the workbook.
In the PivotChart Fields pane, drag Location to the Axis or Categories area and drag Total Employees to the Values area.
Drag Job Position to the Filters or Report Filter area. Then select multiple positions from the filter, and the pie chart will show one combined slice for each Location.
If the PivotChart does not already appear as a pie chart, click the chart, go to Chart Tools, and change the chart type to Pie.

Aggregate Pie Chart Slices by Location in WPS Office Spreadsheets
Build a PivotChart in WPS Office Spreadsheets with Location as the only category and Total Employees as the value, then keep Job Position as a chart filter so selected positions roll up into one slice per location.
- 1. Open your workbook in WPS Office Spreadsheets: Launch WPS Office Spreadsheets and open the workbook that contains the Location, Job Position, and Total Employees data.
- 2. Insert a PivotChart from the Insert tab: Click a cell in the data range, go to the Insert tab, and select PivotChart. Confirm the data range and placement.
- 3. Place Location and Total Employees in the correct areas: In the PivotChart Fields pane, drag Location to the Axis or Categories area and drag Total Employees to the Values area.
- 4. Filter by Job Position: Drag Job Position to the Filters area, select the desired positions, and the chart will aggregate their totals per Location.
- 5. Set the chart type to Pie: Select the chart, open Chart Tools, and change the type to Pie so one slice appears for each Location.

Frequently Asked Questions
Why does my pie chart create a slice for every location and position combination?
Because both Location and Job Position are being used as chart categories. Move Job Position out of the legend or category area and use it as a filter so only Location remains as the chart category.
How do I keep multiple selected positions but still get one slice per location?
Use Job Position as a report filter or slicer instead of a legend or category field. The chart then aggregates the numeric value column across all selected positions for each location.
Can I do this in WPS Office Spreadsheets without Power BI?
Yes. Insert a PivotChart in WPS Office Spreadsheets, put Location in the Axis or Categories area, Total Employees in Values, and Job Position in Filters. Then set the chart type to Pie.
What if my data already has one row per location and I still see separate slices?
Check whether a second field is still in the legend or category area, or whether the chart is using individual rows instead of an aggregated PivotChart. Replace it with a PivotChart that uses only Location as the category.
Will this method work when I open the file in Microsoft Excel?
Yes. WPS Office Spreadsheets saves PivotCharts in an .xlsx-compatible workbook format, so the aggregated Location pie chart and Job Position filter can be opened and edited in Microsoft Excel.




