D
darkwing_duck
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
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