Hi,

Known bug: See MSKB article, XL2000: Changing a PivotChart Removes
Series Formatting (Q215904) .
http://support.microsoft.com/default...;EN-US;Q215904

Cheers
Andy

larry garka wrote:
After setting custom pivotchart patterns the patterns are reset to default
after underlying pivottable is refreshed. How can we make the custom
patterns remain in place after pivottable refresh?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info