This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am trying to create a pivot pie chart that shows me the breakdown of bugs found in QA, UAT and Production. I have a pivot chart that is using Filters for Leader and Team and Axis is set to Time Period. I am using a slicer for each of those three fields and want to be able to see "X" Leader for "X" Time Period and have the three fields for QA, UAT, and Prod show in a pie chart totaling 100. Right now it is showing the chart broken down by Time Period and not by QA/UAT/Prod at all. Not sure how I can get it to show what I want.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Could you share a test file without sensitive information? Then I will have a try.
For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.
Why a sample file is important for troubleshooting. How to do it. - Microsoft Community
Dear Johanna,
Thank you for posting to Microsoft Community. We are glad to assist. We are looking into your situation and we will update the thread shortly.
Appreciate your patience and understanding and thank for your time and cooperation.
Sincerely,
Hailey | Microsoft Community Moderator