I am working with Pivot Chart excel 2007. You can preserve cell formatting in the pivot table. How can it be done in the pivot charting?