October 5, 2018
July 16, 2010
I'd say that is a limitation of using filters on a Table that is the source for a chart. Are you able to provide a sample file that we can take a look at and see if there is a workaround. You might need to create the chart source table using formulas and dynamic named ranges.
June 25, 2019
hi, ive had this same problem and i believe i found a solution. see the thing is, preserve cell formating does not work in this case, or bugs out, idk to be honest. the way i 'fixed' it - delete all filters and slicers, start from the beginning - select all data that will be sliced (whole pivot table with all data and categories etc.) make a chart - format it as you want it to look (ignore that it is overfed with data) and then add a slicer to it.
tl;dr - format chart with all data before adding slicer
July 16, 2010
Welcome to our forum, Karlis and thanks for your contribution.
My understanding of Matthew's issue is that he's using an Excel Table to feed the chart, not a PivotTable. Your solution deals with the common problem where formatting is applied to a chart in a filtered state, then when different items are selected in the Slicer the chart appears to lose the formatting, when in actual fact, formatting was only applied to the items selected in the Slicer originally.
I hope that clarifies the cause of this common issue.