Option Button Archives - PK: An Excel Expert

Excel Form Controls: Combo Box, Spin Button and Option Buttons (3 Real Business Examples)

September 29, 2026October 10, 2026 PKComments Off

Excel form controls turn a static sheet into an interactive tool that anyone can use with a click. In this tutorial we solve three real business problems with the three

Charts and Visualization

Stylish and Dynamic Comparison Chart

August 30, 2020March 2, 2025 PKComments Off

In the article, we have created a stylish and dynamic comparison chart in Microsoft Excel. This chart can be used to compare the metric like -Sales, Revenue, profit, etc. between

Charts and Visualization Dashboard

Top/Bottom Analysis dashboard in Excel

May 24, 2020September 19, 2026 PKComments Off

The Top/Bottom Analysis dashboard in Excel ranks employees and locations using a sample sales dataset. It combines slicers, Form Control option buttons and a scrollbar to change the ranking view

Charts and Visualization

Dynamic Performance Chart in Excel with Doughnut Charts

November 7, 2019October 9, 2026 PKComments Off

A dynamic performance chart in Excel turns a dull table of KPIs into four stylish circle charts that change the moment you click a different location. In this tutorial you

Charts and Visualization

Dynamic Conditional Formatting in Excel with Option Buttons

October 10, 2019October 9, 2026 PKComments Off

Dynamic conditional formatting in Excel lets one table switch between a heat map, data bars and traffic-light icons with a single click. In this tutorial you build it with four