chart formating disappears when i refresh pivot table data

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

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

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" wrote:

>
> replace the pivot table with a sumproduct table, then formatting is
> fixed forever.
>
>
> --
> robert111
> ------------------------------------------------------------------------
> robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
> View this thread: http://www.excelforum.com/showthread...hreadid=569780
>
>

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 [email protected], as I don't visit the forum every day.