How to Create Data Bars in Excel?

Data bars are a simple yet effective way to represent data in a cell in Excel. This blog shares a simple method of creating a data bar.

Consider, you’re building a report on employee performance in Excel. For an employee, this data ranges anywhere from 1 to 100. With data bars, this can be visually represented.

Consider an employee’s performance score of 36.

Enter this value in a cell in your report.

To include a data bar, (1) go to Conditional Formatting and (2) Create a New Rule

Format based on values and choose the Data bar option with the minimum being 0 and maximum applicable value being 100 (denoting the maximum possible score of 100), assign a color to the bars as shown here:

Apply a border to the cell and, this includes a data bar in the cell containing the value as shown:

For metrics that have a singular value, using data bars is a great way to visually include them to a dashboard or report.

Check our video on creating an interactive report incorporating the databars:

If you have any feedback or suggestions, please post them in the comments below.

Leave a Reply

Your email address will not be published. Required fields are marked *