How to Effortlessly Use the Excel Option Button to keep Finance and Operation Executives Happy at The Same Time

In business, I often see disputes between the finance and operations departments on which metric is a more important indicator of performance. Operational leaders (more often than not) like to see their numbers in terms of units/quantities and the finance executives/leaders want to see everything in dollars or currency. This is where the Excel option button form control comes in handy (note that if you are part of a finance team, you can also use this logic to switch between local currency versus your company's global standard currency). I'm going to show you how you can use the option button to switch between quantity/units and currency all in one graph.