Microsoft Office Tutorials and References
In Depth Information
Analyze Cell Values with Data Bars
Analyze Cell Values
with Data Bars
You can analyze how the values in a range
relate to one another by applying data bars to
each cell in the range.
In some data analysis scenarios, you might be
more interested in the relative values within a
range than the absolute values. For example, if
you have a table of products that includes a
column showing unit sales, how do you
compare the relative sales of all the products?
This sort of analysis is often easiest if you
visualize the relative values. You can do that by
using data bars . Data bars are a data
visualization feature that applies colored,
horizontal bars to each cell in a range of
values, and these bars appear “behind” the
values in the range. Their key feature is that
the length of the data bar that appears in each
cell depends on the value in that cell: the larger
the value, the longer the data bar. The cell
with the highest value has the longest data bar,
and the data bars that appear in the other cells
have lengths that reflect their values.
1 Select the range you
want to work with.
2 Click the Home tab.
3 Click Conditional
4 Click Data Bars.