We sometimes need to display our dataset utilizing the data bars percentage feature. With Excel’s conditional formatting feature, we can achieve it quickly. In this article, we are going to demonstrate 3 suitable examples of using data bars with percentages in Excel. If you are also curious about it, download our practice workbook and follow us.
How to Use Data Bars with Percentage in Excel: 3 Suitable Examples
To demonstrate the examples, we consider three different types of data. Each dataset is based on a different scenario.
📚 Note:
All the operations of this article are accomplished by using the Microsoft Office 365 application.
1. Using Data Bars with Percentage for Work Progress
In the first example, we consider a dataset of the working progress of 10 identical projects. The name of the projects is in column B, and their progress rate is in column C. So, our dataset is in the range of cells B5:C14.
The steps to complete this example are given below:
📌 Steps:
- First of all, select the range of cells C5:C14.
- Now, in the Home tab, click on the drop-down arrow of the Conditional Formatting option from the Styles group.
- Then, choose the More Rules option from the Data Bars section.
- As a result, a dialog box called New Formatting Rule will appear.
- After that, change the Type of Minimum option from Automatic to Number.
- Then, denote the Value of the Minimum field as 0.
- Similarly, set the Type and the Value option for the Maximum field.
- Afterward, in the Bar Appearance section, choose the bar style according to your desire. We choose the Solid Fill option in the Fill field and the Orange, Accent 2, Lighter 60% color in the Color field.
- Finally, click OK.
- You will notice the cells will get the data bar formatting according to the values.
Thus, we can say that our procedure works perfectly, and we are able to use data bar percentages in Excel.
Similar Readings
- How to Add Data Bars in Excel
- How to Add Solid Fill Data Bars in Excel
- How to Add Blue Data Bar in Excel
- How to Remove Data Bars in Excel
2. Applying Data Bars with Percentage for Marks
In this example, we are going to consider a dataset of the examination marks of 10 students. We mentioned the students’ names are in column B, and their examination marks are in column C. So, We can claim our dataset is in the range of cells B5:C14.
The steps to complete this example are given as follows:
📌 Steps:
- First, select the range of cells C5:C14.
- After that, in the Home tab, click on the drop-down arrow of the Conditional Formatting option from the Styles group.
- Now, choose the More Rules option from the Data Bars section.
- As a result, a dialog box called New Formatting Rule will appear.
- Then, change the Type of Minimum option from Automatic to Percent.
- Next, denote the Value of the Minimum field as 0.
- Similarly, set the Type as Percent and the Value option as 100 for the Maximum field.
- After that, in the Bar Appearance section, choose the bar style according to your desire. For our dataset, we choose the Solid Fill option in the Fill field and the Orange, Accent 2, Lighter 60% color in the Color field.
- Finally, click OK to close the dialog box.
- You will notice that all the cells will get the data bars percentage formatting according to the values.
Hence, we can say that our procedure works effectively, and we are able to use data bar percentages in Excel.
3. Utilizing Data Bars with Percentage for Income
In the last example, we will consider a dataset of 10 employees and their income for a particular month. The employees’ names are in column B, and their income is in column C. Thus, our dataset is in the range of cells B5:C14.
The steps to complete this example are shown as follows:
📌 Steps:
- First, select the range of cells C5:C14.
- Next, in the Home tab, click on the drop-down arrow of the Conditional Formatting option from the Styles group.
- Afterward, choose the More Rules option from the Data Bars section.
- As a result, a dialog box called New Formatting Rule will appear.
- After that, change the Type of Minimum option from Automatic to Percent.
- Then, denote the Value of the Minimum field as 0.
- Similarly, set the Type as Percent and the Value option as 100 for the Maximum field.
- Now, in the Bar Appearance section, choose the bar style according to your desire. For our dataset, we choose the Solid Fill option in the Fill field and the Orange, Accent 2, Lighter 60% color in the Color field.
- Finally, click OK to close the dialog box.
- You will see that all the cells will get the data bar percentage formatting according to the values.
Finally, we can say that our procedure works successfully, and we are able to use data bar percentages in Excel.
Download Practice Workbook
Download this practice workbook for practice while you are reading this article.
Conclusion
That’s the end of this article. I hope that this article will be helpful for you and you will be able to use data bars with the percentage in Excel. Please share any further queries or recommendations with us in the comments section below if you have any other questions or recommendations.