Does anyone know how I can rename the data labels on my pivot piechart so that they do not say "Sum of....." etc.

also, while I am here I was wondering if anyone knows if it is possible to put VBA behind charts with which to implement drill downs on particular sections?