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 to use data bars percentage in Excel. If you are also curious about it, download our practice workbook and follow us.

## Download Practice Workbook

Download this practice workbook for practice while you are reading this article.

## 3 Suitable Examples to Use Data Bars with Percentage in Excel

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 bars percentage in Excel.

**Read More: ****Calculate Percentage Based on Conditional Formatting (6 Ways)**

**Similar Readings**

**Calculate Percentage Difference Between Two Numbers in Excel****How to Calculate Percentage for Multiple Rows in Excel****Calculate Percentage in Excel VBA (Involving Macro, UDF, and UserForm)****Show One Number as a Percentage of Another in Excel (2 Ways)****Calculate Percentage in Excel Based on Cell Color (4 Methods)**

### 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:**

- At 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 bars percentage in Excel.

**Read More: ****How to Calculate Grade Percentage in Excel (2 Suitable Ways)**

### 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. - At last, click
**OK**to close the dialog box.

- You will see that all the cells will get the data bars percentage formatting according to the values.

Finally, we can say that our procedure works successfully, and we are able to use data bars percentage in Excel.

**Read More: ****How to Apply Percentage Formula for Multiple Cells in Excel (5 Methods)**

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

Don’t forget to check our website, **ExcelDemy**, for several Excel-related problems and solutions. Keep learning new methods and keep growing!

## Related Articles

**Calculate Percentage Using Absolute Cell Reference in Excel (4 Methods)****How to Calculate Average Percentage in Excel (3 Easy Methods)****Excel Formula to Add Percentage Markup (3 Suitable Examples)****Use Excel Formula to Calculate Percentage of Grand Total****How to Calculate Percentage of a Number in Excel (5 Easy Ways)****Use IF and Percentage Formula in Excel (2 Easy Ways)****Percentage Formula in Excel (6 Examples)**