• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Problem with Pivot Chart when update the Pivot Table

Dillina

Member
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!:( :eek:
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!! :)
 

Attachments

  • Problem pivot chart.xlsx
    18.1 KB · Views: 1
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
 
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
:)
 
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...:rolleyes:

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 !!!;)
 
Back
Top