Excel 2010 Data Bars makes it easier to observe that how data
values relate to each other. This feature represents data
graphically inside the cell, and helps user to compare data
cells more effectively and efficiently by adding bars, which
defines the data of the cell. It is better to represent the data
graphically rather then using orthodox Conditional Formatting
style. This post will cover how to make the most of Data Bars,
in a simple datasheet. Launch Excel 2010, create a new datasheet
or open an existing one to apply data bars over the desired
cells. For Instance, we have student record datasheet,
containing marks obtained in each course, there are 7 courses in
total, so we have seven columns with their names as column
headings and, a Total column which contains sum of marks
obtained by each student (out of 700). Now we want to apply Data
Bar on each cell, select the portion of the data on which you
want to apply it. Navigate to Home tab, click Conditional
Formatting, and from Data Bars menu, click more