Pie Chart Conditional Graphing

[Quiz]

I am trying to set up a pie chart so that it only graphs data that
represent more than 1% of the total pie.

For instance, say I have the following data in cells A1:C7,

Fruit Units % of Total
Apples 45 22%
Bananas 55 27%
Pears 1 0%
Kiwi 50 25%
Plum 1 0%
Grapes 50 25%

I only want the pie to include Apples, Bannas, Kiwi, and Grapes. I
have tried everything I can to get this done, but with no luck. I've
creating a formula that has the end result of... "Apples", "Bananas",
"Kiwi", "Grapes" ... as labels and another that has... "45", "55",
"50", "50" ... as the values, graphing those cells, and that didn't
work. I've tried creating a formula that has the cell addresses...
A2, A3, A5, A7 ... for the labels and another with... B2, B3, B5,
B7... for the values and using the indirect formula and that didn't
work either. I've tried using defined names and nothing.

I could do this with VBA, but unfortunately no macros can be included
in the workbook. I'm at a loss, and any help is much appreciated.
I'm interested in seeing an answer.

TIA

 

[Steve]

I know this is not the answer to your question but they are
Kiwifruit. "Kiwi" are birds. "Kiwifruit" are small green fleshed
fruit with a fury skin.

Graph a second column which has a formula in it which only includes
a value if it is over your threshold. You either need an "other" category
or your graph will show slightly increased percentages for all remaining
categories - that is a decision you need to make.

Steve.

Quiz wrote