Excel : Change Chart from Count to Percent Using Options Button

Best Online Course : SAS Programming with 50+ Case Studies

- Explain Programming Concepts in Simple English
- Live Projects & Case Studies
- Job Placement Assistance
- Get 20% off till July 14, 2017

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
Steps
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
=IF($I$6=1,M6,ROUND(M10,2))
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 

Excel Tutorials : 100 Excel Tutorials

About Author:

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has close to 7 years of experience in data science and predictive modeling. During his tenure, he has worked with global clients in various domains like retail and commercial banking, Telecom, HR and Automotive.


While I love having friends who agree, I only learn from those who don't.

Let's Get Connected: Email | LinkedIn

Get Free Email Updates :
*Please confirm your email address by clicking on the link sent to your Email*

Related Posts:

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

Post a Comment

Next → ← Prev