ActiveX Toggle Button - Only ONE at a time

Hey everyone,

I am trying to figure out a way of using Toggle Buttons to change chart data. I can do this through the use of a INDEX/MATCH (easy part) but I have multiple criteria, so I need 3 buttons. Total, Inbound and Outbound.

Does anyone know of a way to force a toggle button to unselect when the end user presses another? I know this can be done with VBA but I am trying to keep this workbook NON VBA.

Thanks in advance!

Never mind, I used options buttons each linking them to their own cell, 'Admin'!C9, 'Admin'!C10, and 'Admin'!C11. Then in 'Admin'!C8, I have a a simple formula

Formula:

Please Login or Register  to view this content.

Then I used a CHOOSE off of that IF statement to drive the MATCH which drives the INDEX xD