chart formating disappears when i refresh pivot table data

[Guest]

hi,
i have lots of pivot tables and charts based on those table.
1. i apply formatting to a particular chart like colors,shadow etc
2 then later when new data is added to pivot table i refresh the pivot table
3. after the above the chart refreshes but the formatting dissapears

how should i correct the problem?

thx
tols

 

[robert111]

replace the pivot table with a sumproduct table, then formatting is
fixed forever.

 

[Guest]

Would it be possible to elaborate a little on this process using the
sumproduct table. I checked out the sumproduct funtion and understand it but
I don't see how I proceed to used this to "replace" the pivot table.
Any additional info would be greatly appreciated.
thanks!
Jugglertwo

 

[robert111]

To help you further I would need to see a simplifed set of data and what
your pivot table was analysing. I would then suggest how to use the
sumproduct table. To save time you can e-mail the simplified
spreadsheet to (e-mail address removed), as I don't visit the forum
every day.