익명 05:42

How to connect existing slicers to new pivot charts?

How to connect existing slicers to new pivot charts?

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.



Top Answer/Comment:

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

상단 광고의 [X] 버튼을 누르면 내용이 보입니다