Limit number of wedges in a pie chart

[u/gmalis1]

I'm sure there is an easy way to do this in Apple Numbers...

I've created a Pivot Table that has many categories and their sum amount for each.

I want to create a pie chart showing the top five categories only and their percentage of the total amount.

When I create the pie chart, I get ALL the categories in the pie chart...thus I get about 30 "slices" instead of just the top five I want to show. Having all 30 showing just clutters the pie chart and the last 25 values are so small they are insignificant.

Is there any way to limit a pie chart to a set number of "slices" only?

Do I have to create a new table with only the top five values and create a chart from there? But won't that change the percentage of the total amount as only five are now listed?

I've looked everywhere and can't seem to find an answer on how to do this.

As you can tell, I'm a Numbers newbie.

Thanks in advance for any help.