Keep pivotchart formatting when data is refreshed?

[Pmxgs]

Hi!

Is it possible to keep all the formatting in a pivotchart after i refresh
the data.
Although i check the preserve formatting option, every time i refresh tha
data, i loose all the changes i made in the chart, and it allways goes back
to the default excel formatting.

Thanks

 

[Debra Dalgleish]

Turn on Enable selection (From the Pivot toolbar, choose
PivotTable>Select, and click on Enable Selection)

Before formatting cells, use the selection feature to select the cells.
For example, move the pointer to the top of a column in the pivot table
(just above the column's heading cell). When the black arrow appears
(like the one that appears when the pointer is over a column button),
click to select the column in the pivot table. Then apply the formatting.