Keep pivotchart formatting when data is refreshed?

  • Thread starter Thread starter Pmxgs
  • Start date Start date
P

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
 
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.
 
Back
Top