How to remove an unnecessary value Pie of Pie chart in Excel ?

Avian Richardson 0 Reputation points
2024-03-14T14:51:41.5333333+00:00

Screenshot 2024-03-14 at 9.45.41 AM

This piechart added a value of 17, (4% in purple) in the chart but 17 was not apart of the data set. How do I remove that value and why is the pie chart doing this ?

PowerPoint
PowerPoint
A family of Microsoft presentation graphics products that offer tools for creating presentations and adding graphic effects like multimedia objects and special effects with text.
245 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Michael Taylor 50,586 Reputation points
    2024-03-14T15:20:19.57+00:00

    The 4% is the "of Pie" portion of the "Pie of Pie" chart you're using. As the description states, it breaks out the smallest slice into a subpie so it is easier to see values that otherwise would have been too small to see in the larger pie.

    If you don't want the subpie then select the chart and change the type to Pie. This shows you a traditional, single pie with all the slices.

    1 person found this answer helpful.
    0 comments
  2. Jiajing Hua-MFST 7,315 Reputation points Microsoft Vendor
    2024-03-15T04:28:35.5166667+00:00

    Hi @Avian Richardson

    Please checkout Michael Taylor's explanation. The value of 17, (4% in purple) is the sum of smaller slices ('Total of Good to Have' and 'SQL and Metaload ')from the main pie chart and display them in a secondary pie.

    For more about "Pie of Pie", you may refer to link: Draw attention to small slices in a pie-of-pie or bar-of-pie chart.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.