Excel : Change Chart from Count to Percent Using Options Button

This tutorial explains how to change chart from count to percent using Options Button.

Options Button
Like drop down, the Option Button form Control allows the selection of a single item from a list of items. When one item is selected, the other remaining options would be unchecked.

Change Chart from Count to Percent
1. Prepare Data for Count and Percent
Count and Percent Data
2. Create two Options Button
Create Options Button
3. Right click on Options Button and go to Control tab and give cell reference (say, $I$6) to Cell link.
Options Button :  Reference to Cell Link
4. Add Group Box
Add Group Box
It is used for grouping similar controls so that functional groups of controls can be maintained and the users flow is directed around a form.
Group Options Buttons and Group Box
Select Options Buttons and Group Box by using CTRL SHIFT shortcut keys and then right click and click on Group.
Put Options Button Inside Group Box

5. Create Chart Range
Create Chart Range

6. Add Custom Format to Chart Range
[>=1] #,##0;[>0] 0%;0
If a cell value is whole number, then add number format. Otherwise, use % format.

7. Create Chart
Select chart range and then press ALT N C and select column chart.
Download Excel Chart 
Spread the Word!
Related Posts
About Author:

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 10 years of experience in data science. During his tenure, he has worked with global clients in various domains like Banking, Insurance, Private Equity, Telecom and Human Resource.

0 Response to "Excel : Change Chart from Count to Percent Using Options Button"

Post a Comment

Next → ← Prev

Looks like you are using an ad blocker!

To continue reading you need to turnoff adblocker and refresh the page. We rely on advertising to help fund our site. Please whitelist us if you enjoy our content.