What is data bars in excel?

What is data bars and how to add data bars in excel?

In Excel Conditional Formatting Data bars, color scales, are formats that create visual effects in your data. Data bars option can help you mark larger and smaller numbers in color scale. A larger color scale bar represents a larger value, and a small color scale bar represents smaller values.

In short, these conditional formats make it easier to compare the values of a range of cells on a worksheet.

Please follow the below images for better understanding.

Click on conditional formatting > Data Bars > Color Option.

how to add data bars in excel

You can create your own rules to apply on your worksheet by click on More Rule. When you click on more rules here you can see an option and have a right to customization.

how to edit data bars in excel