Data Label Issue

Hello all. Thanks so much for your time.

For the sake of simplicity, I'll use an analogy to pieces of fruit:

I created a pivot chart to show the number of good and bad pieces of fruit and the corresponding tree that produced each type of fruit. Because some trees are "used" more than others and thus will tend to produce more bad fruit, I inserted two calculated fields in place of the existing fields in order to show what percentage of total # of fruits produced by each tree are bad/good. So the formula looks something like % bad fruit = (# bad fruit / (# bad fruit + # good fruit))*100 .

Here's my issue: I would like to see the number of bad fruits (or maybe even number of total fruits) produced by each tree next to (preferably on top of) the bars that represent the percentage of bad fruit without graphing the number of bad fruits to add some sensibility to the data (i.e. if one tree has produced 100% bad fruit, but it has only produced a total of 5 fruits, the graph can be slightly misleading without closer inspection). Adding data labels doesn't accomplish this because it simply shows the percentages.

I am fairly inexperienced with Excel, so forgive me if this is obvious. I appreciate the help.

Here is a model of what I have (see attached file).

- Zoo