Microsoft Office Tutorials and References
In Depth Information
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 that 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-5 shows a three-column range (in B3:D14) with data bars conditional formatting to the data in column D
(column D contains references to the values in the second column). The conditional formatting in the third
column uses the Show Bars Only option, so the values are not displayed.