Hi,

This is a know bug.
http://support.microsoft.com/default...;EN-US;Q215904

Cheers
Andy

chiefage wrote:
How do I keep the format of the plot area in a pivot chart when selecting
different pivot items or refreshing the data.

--

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