Slicer changing chart styles

[jmenche]

Howdy,

I am an expert in a lot of things Excel, and this is driving me nuts!

I create a chart and format it the way that I want. However, when I add a slicer, it changes the chart to a built-in style. I even save the chart as a template but that doesn't work.

Is there a way around this outside of writing vba code to change the chart format? Can I create a custom style?

Thanks

Jeff

 

[jmenche]

I think I have an answer to my own question (not sure if there are others). Do not create and format your chart with fields in the filter section! Create and format your chart first AND THEN add fields to the filter. Having fields in the filter section will only save the formatting for that particular view of data. Change the filter and Excel reverts back to built-in formatting.