'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Create a QA, UAT, and Production Pie Chart in Excel PivotCharts
Question details
The user wants to build an interactive Excel PivotChart that displays QA, UAT, and Production phases as a 100-percent pie chart, using specific fields as filters and slicers.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Tracking project testing and deployment phases using a dynamic visual dashboard.
- Observed behavior
- The goal is to dynamically update a 100% pie chart displaying the distribution of QA, UAT, and Production phases based on selections made in Leader, Team, and Time Period controls.
Ensure your source dataset is formatted as a continuous table with no empty column headers, containing distinct columns for Phase, Leader, Team, and Time Period.
Build the PivotTable and Insert an Interactive Pie Chart
Generate a PivotTable from your source data to calculate phase distribution, then insert a Pie Chart and attach slicers for interactivity.
To achieve a 100% distribution for your three categories, the PivotTable needs to count the occurrences of each phase and display them as a percentage of the grand total. If you encounter issues matching the exact layout, sharing a sample workbook without sensitive data via OneDrive can help troubleshoot specific formatting errors.
Select your entire dataset, navigate to the 'Insert' tab on the Excel ribbon, and click 'PivotChart'. Choose where you want the chart to be placed and click OK.
In the PivotChart Fields pane, drag the 'Phase' column (containing QA, UAT, and Production) to the Axis (Categories) area. Drag the same 'Phase' column to the Values area to get a 'Count of Phase'.
Drag the 'Leader' and 'Team' columns into the Filters area of the PivotChart Fields pane. This allows you to filter the entire chart by specific leaders or teams.
Right-click the newly generated chart, select 'Change Chart Type', and choose the 'Pie' chart option. Click OK to apply.
Click anywhere on your PivotChart to reveal the 'PivotChart Analyze' tab. Click 'Insert Slicer', check the box for 'Time Period', and click OK. You can now use this slicer to visually filter the pie chart by time.
Create Interactive PivotCharts Seamlessly with WPS Spreadsheet
WPS Spreadsheet provides powerful PivotTable and PivotChart features out of the box. You can easily build dynamic dashboards tracking QA, UAT, and Production phases without complex configurations.
- 1. Open Your Data: Launch WPS Spreadsheet and open your project tracking dataset.
- 2. Insert PivotChart: Go to the Insert tab, select PivotChart, and define your data range.
- 3. Arrange Your Fields: Drag 'Leader' and 'Team' into Filters, and 'Phase' into both the Axis and Values areas.
- 4. Format as Pie Chart and Add Slicers: Change the chart type to Pie, then use the Analyze tab to insert a Slicer for 'Time Period'.
Frequently Asked Questions
Why doesn't my PivotChart pie chart show percentages?
To show percentages, right-click the data labels on your pie chart, select 'Format Data Labels', and check the 'Percentage' box while unchecking 'Value'.
Can I connect one Time Period slicer to multiple PivotCharts?
Yes. Right-click the slicer, select 'Report Connections', and check the boxes for all the PivotTables and charts you want that specific slicer to control.
How do I ensure QA, UAT, and Production are the only categories shown?
Click the filter dropdown icon on the Phase category directly within your PivotTable or PivotChart. Manually uncheck any other phases, errors, or '(blank)' values so only your three target phases remain visible.
