Microsoft Office Tutorials and References
In Depth Information
Conditional Formats That Use Graphics
The length of the data bars is proportional to the track length in the cell in column D.
When you adjust the column width, the bar lengths adjust accordingly. The differences among the bar lengths are
more prominent when the column is wider.
Excel provides quick access to 12 data bar styles via Home
Formatting ➪ Data Bars. For additional choices, click the More Rules option, which displays
the New Formatting Rule dialog box. Use this dialog box to:
Show the bar only (hide the numbers).
Specify Minimum and Maximum values for the scaling.
Change the appearance of the bars.
Specify how negative values and the axis are handled.
Specify the direction of the bars.
Oddly, if you add data bars using one of the 12 data bar styles, the colors used for data bars are not theme colors. If
you apply a new document theme, the data bar colors do not change. However, if you add the data bars by using the
New Formatting Rule dialog box, the colors you choose are theme colors.
Using data bars in lieu of a chart
Using the data bars conditional formatting can sometimes serve as a quick alternative
to creating a chart. Figure 19.15 shows a three-column range (in B3:D14) with data bars