I have a pivot chart from a group of data, and I need to show it in a specific type of different charts (combo charts) and giving every bar and lines a specific color. The problem is that every time a filter my pivot table on a different way or if I close my excel and open it again, all the format disappears.
I have tried making a regular chart from the table and although it does keep the format, it wont work or show what I want when filtering my pivot table (since the cells position may vary). I've also tried duplicating the data of the pivot table to a normal table but the result is the same as the mentioned above.
Does anybody have a trick for this? a different way to try? Maybe a VBA code that locks the format of the chart?