I reviewed the tutorial video and the section about how to use a slicer to lookup a picture is amazing. I was wondering if another picture can be used to display after the filter is cleared.
Hi Tyrone,
You could add an IF formula in say, cell H2 that says if there is data in cell G3 i.e. the slicer is either filtered for more than one stage, or in an unfiltered state, then return the name of the other picture you want displayed, otherwise return the name of the picture for the selected stage:
=IF(G3<>"","image cell name for other picture", G2)
Then, the Profile_Slicer name would reference cell H2.
Hope that makes sense, but if you're stuck, come back and share your file so we can see where things went wrong.
Mynda
Mynda,
Hi, I attach my spreadsheet. I attempted the formula in B11 on the "Gender Selection Images" sheet; however, I'm doing something wrong. The slicer works great with changing images on the "VA 8G Employees Dashboard". My vision is when the filter is cleared the "FEMALE_MALE" image populates. When I clear the slicer the "FEMALE" image remains.
Thank you
Hi Tyrone,
Thanks for sharing your file. Your formula is referencing the wrong cells. It should be as follows:
On the Gender Selection Images sheet, in cell B11: =IF(A9<>"","FEMALE_MALE",A8)
In the name manager change the Image_Slicer formula to: =INDIRECT('Gender Selection Images'!$B$11)
Mynda
Mynda,
Hi, it works so SWEET!!! Your knowledge of Excel is a gift and thank you for sharing it will novices like me.
