Excel – How to connect existing slicers to new pivot charts

microsoft excelpivot tablepivot-chart

I had 6 existing slicers connected to 4 pivot charts. I created a new pivot pie chart and want to connect 5 of the 6 existing slicers to it but I can't do so. The only thing I can do is create 5 new slicers which I don't want to do. enter image description here

As can be seen, there's no option to filter connections. I am doing a course on EdX "Introduction to data analysis using Excel" and this is a part of the lab exercises.

Best Answer

That is because we are using different sources of data. Check the other pivots and see the data source, then connect it to the same data sheet

PS: The data may be the same but sheets may be different

Related Question