I have a very simple spreadsheet that has a column of serial numbers
and next to it a column with a yes/no tracking whether a serial number
has been registered or not.  I want my sales team calling into an
account once 50% of the serials are registered so I created a pivot
table that simply has the yes/no field on the top and a count of each
in the data.  Then I created a pivot chart with the yes and no next to
each other and the data labels displayed.  So far so good and this
does accomplish what I want at it's most simple level.

What I would love to do though is:

1) change the count (and therefore the data label) to a percentage of
the total - so right now my test spreadsheet has 5671 in the yes
column and 4329 in the no column.  I'd like to have those reflect
56.7% and 43.3%

2) display "something bold" across the chart when the yes column
exceeds 50%.  For instance, a big bold "CALL IN" across the chart or
perhaps a macro that inserts a pic on top of the chart when the yes
column hits 50%.

TIA,
Robert