top of page
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.

 
 
 
Featured Posts
Recent Posts
bottom of page