Make Pivot Chart Only Show Top Information

I don't think you can do this with the data organized the way it is. You will have to transform it to look like:

This would be a lot simpler if the numbers were integers instead of decimals. You can't used ROUND in conjunction with COUNTIF in an array formula.

This is a limited implementation. It's only good for the top 5.

I have a whole bunch of helper columns. I had to used a lot of array formulas so I could use the ROUND formula.

The first set of formulas are:
=ROUND(LARGE(Table4[@[Beverage 1]:[Dessert 3]],1),0)
I get the 5 largest values and some of them may be ties.

The next set of columns to look at are AJ to AM. These determine which one of the ties to look at. For example, on the second row, there is a three-way tie for 2nd place with a total of 25. The countif formulas show that I want to find the 1st, 2nd and 3rd occurrences of 25 in that order.

Columns AE to AI find the columns in which these occurrences happen. The first one is easy. We're looking for the first occurrence of the biggest fish in the pond. So it's MATCH =MATCH([@[Large 1]],ROUND(A2:S2,0),0).

The next sets get either the second, third or whatever occurrence of the same number, or the first occurrence of the next lowest number. =MATCH([@[Large 1]],ROUND(A2:S2,0),0)

This is a modification of a general formula Nth occurrence =LARGE(((Range=Value)*COLUMN(Range)),COUNTIF(Range,Value)-N+DataStartColumn)

Substitute ROW for COLUMN if looking at a row array. This formula had to be modified since COUNTIF doesn't like to work with ROUND in an array formula. I replaced this with SUM(1 * (Round(Range,0) = Value)). For some reason, that worked.

Finally once I got the rows, I used them in INDEX / MATCH to get the menu items.

I could have combined all the helper formulas into one big formula, but I left it in pieces since it is easier to understand and debug that way.

Use the top 5 in your pie charts.