Thread: 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