When I refresh my data in the dashboard from my table and filter with a slicer, some charts reformat from a clustered column to area? I have area, line and clustered column all on one chart but for some reason the dashboard cannot keep this format option?
Hi Matthew,
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.
Mynda
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
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.
