Forum Discussion

NicoF06ppt's avatar
NicoF06ppt
Copper Contributor
Jul 13, 2022

Box connected to a slicer in excel

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".

 

Thanks for your support !

 

Resources