K Kudo179 New Member Jan 27, 2020 #1 Hi Guys, I'm new in excel, would need your advice. attached file, when I click on 2018, 2019 on slicer, it would change the pivot chart types and both years turn into the same colors and same type of chart. I appreciate your help! Attachments Top 10.xlsx 168.8 KB · Views: 4
Hi Guys, I'm new in excel, would need your advice. attached file, when I click on 2018, 2019 on slicer, it would change the pivot chart types and both years turn into the same colors and same type of chart. I appreciate your help!
Chihiro Excel Ninja Jan 28, 2020 #2 I don't see a pivot chart in your sample... By chance, did you have combo chart? Combo chart requires that you have at least two series. So, if you filter for 2018, then it would default to column chart as there is no second series to show.
I don't see a pivot chart in your sample... By chance, did you have combo chart? Combo chart requires that you have at least two series. So, if you filter for 2018, then it would default to column chart as there is no second series to show.
