how do i keep the formatting - colors and shading etc....

Loss of formatting is a known problem with pivot charts. There's
information in the following MSKB article, which suggests recording a
macro as you apply the formatting:

Changing a PivotChart removes series formatting in Excel
http://support.microsoft.com/?id=215904

To prevent colour loss, you can also set your preferred colours in
ToolsOptions, Color tab, by modifying the Chart Fills and Chart Lines
colors.

Excelqn wrote:
how do i keep the formatting - colors and shading etc....


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html