Problem with Pivot Chart when update the Pivot Table

[Dillina]

Hola chicos
I had prepared my Pivot charts (combinate) with all the beautiful colors .... and when I updated the Pivot Table .... puff .... everything is lost!
I've read here that is a bug, but this article was in 2007.
Can any of you know if the problem is solved ... 10 years later?
Tell me YES please ....
I don't know VBA so if this is the only solution I can not continue my big project ...
Sorry for my bad English ...

I did not attach the file because my file is very large. If it is necessary I can invent a simple one.

Thanks, you are the best!!

 

[SirJB7]

Hi, Dillina!
Does this help?
https://excelribbon.tips.net/T008731_Maintaining_Formatting_when_Refreshing_PivotTables.html
Regards!

 

[Dillina]

Hi, Dillina!
Does this help?
https://excelribbon.tips.net/T008731_Maintaining_Formatting_when_Refreshing_PivotTables.html
Regards!

Thanks for reply SirJB7
but I have a problem with the Pivot Chart. The Pivot chart change....
The function you told me I know it
I attach this file so you can understand it better.

Add to the existing chart the value called "UVA" ...
Refresh .... and you will see that the chart changes formatting

 

[NARAYANK991]

Hi ,

Can you try this , and see if it helps ?

1. With all formatting in place , select your chart , and click on Save As Template.

2. When ever you make any change to your chart , click on Change Chart Type , and select Templates , and click on the icon which is displayed there against your saved template.

See if the saved formatting is restored.

Narayan

 

[Dillina]

Hola Narayank991
I had already tried this method and change the color.
My problem is that I work with 50 charts.
If I worked with only one chart would not be a problem, but in that case I would have to change 50 charts all the time
Can you tell me if it's an Excel bug?
Thanks for reply

 

[NARAYANK991]

Hi ,

Have you read this ?

https://peltiertech.com/pivot-chart-formatting-changes/

Narayan

 

[Dillina]

Hi ,

Have you read this ?

https://peltiertech.com/pivot-chart-formatting-changes/

Narayan

Wow Narayan !!!!
Now I translate it in my language with the translator and study well .... then I tell you !!! Thanks so much

 

[Dillina]

Narayan...
I read the article well and I think this is the only solution ... use formulas by recreating the Pivot Table and using a "normal" Chart (no Pivot Chart)
It seems a palliative and still think it is an Excel bug...

I'm ready for any other solution (not VBA). For the moment I will use this.
Thank you very much for how you always help me !!!