Search
Use Data Bars to Highlight Data Quickly
- Ketul Patel
- Jun 26, 2016
- 1 min read
Data bars in Excel are very useful to visualize values in a range of cells. A longer bar represents a higher value.
To add data bars, follow below steps.
1. Select a range.
2. From the Home tab, click Conditional Formatting, select Data Bars, and than select Gradient or Solid Fill.

Sample Results:

There are different options available under formatting rule options where you can even get rid of numbers and show only the bars.
