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

Launching Conditional Formatting option to use data bars percentage for work progress

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

Changing Minimum option type and value

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

Choosing a suitable color visible the data bar percentage for work progress

  • You will notice the cells will get the data bar formatting according to the values.

Using Data Bars with Percentage for Work Progress

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


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.

Opening Conditional Formatting option to use data bars percentage for examination marks

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

Changing Minimum option type to percent and value to 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.

Choosing a suitable color visible the data bar percentage in the Excel cell

  • You will notice that all the cells will get the data bars percentage formatting according to the values.

Applying Data Bars with Percentage for Marks

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.

Launching Conditional Formatting dialog box to use data bars with percentage for employees' income

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

Changing Minimum option type to percent and value to 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.

Choosing a suitable color visible the data bar percentage in the Excel cell

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

Utilizing Data Bars with Percentage for Income

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

Soumik Dutta

Soumik Dutta

Hi! I am Soumik. I have completed my Bachelor of Science in Naval Architecture and Marine Engineering. I have found my calling in Machine Learning and Data Science, and in pursuing so, I have realized the importance of Data Analysis. Excel is one excellent tool to fulfill the purpose. I am always trying to learn every day about different features of Excel and trying to share here what I am learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo