# How to Use Data Bars with Percentage in Excel (3 Ideal Examples)

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.

### 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.

## 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.

## Related Articles

<< Go Back to Data Bars | Conditional Formatting | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Soumik Dutta

Soumik Dutta, having earned a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a key role as an Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Soumik not only skillfully addresses complex challenges but also demonstrates enthusiasm and expertise in gracefully navigating tough situations, underscoring his unwavering commitment to consistently deliver exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF