pivot chart formatting
 

Hi there,
I've a sheet with a cake pivot chart. I customized
different parts of the chart (colour of characters,
data format in perc.,etc). When I update the
pivot table connected, the chart loses my
previous setting. Is there any trick to solve this
problem?
Thank you in advance.
Renato

Hi,

This is a known problem. See KB article.
Changing a PivotChart Removes Series Formatting
http://support.microsoft.com/default...;EN-US;Q215904

Cheers
Andy

Renato wrote:
Hi there,
I've a sheet with a cake pivot chart. I customized
different parts of the chart (colour of characters,
data format in perc.,etc). When I update the
pivot table connected, the chart loses my
previous setting. Is there any trick to solve this
problem?
Thank you in advance.
Renato


--

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