Box connected to a slicer in excel

New Contributor

Hi community,

 

I need help about connected a box to a slicer. I created a table with some diameter intervals. For each intervals, a number is corresponding (like 7 for diameters from 5 to 10 mm).

I created a Slicer for the diameter table, and I want when I click on a diameter interval in the slicer ; the green box "corresponding of the diameter selection" display the corresponding number.

 

For exemple, if I click in the slicer on "10 to 15 mm" , the green box would display "12".

NicoF06ppt_0-1657716447886.png

 

Thanks for your support !

 

1 Reply
You have posted on the Microsoft Learn community board which is all about exams, certification and training.
You might get a better response on the Excel community board https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral