Data Bars
Data Bars are charts that appear within cells to provide a sense of proportionate scale within a column of numbers. As you’ll see, numbers can appear in the cell with the charts, or you can hide the numbers. Cells D3:D22 of the Data Bars worksheet in the example workbook for this chapter show how numbers and Data Bars can coexist in the same cell. To create this type of formatting, do the following:
- Select a range of cells that contain numbers, such as K3:K22 of the Data Bars worksheet.
- Choose Home | Conditional Formatting | Data Bars and select from the Gradient Fill or Solid Fill sections.
Tip
Most Conditional Formatting rules in the desktop versions of Excel offer live previews as you craft a rule, or when you hover your mouse over a particular data bar, color scale, or icon set.
- As shown in Figure 4.10, the Data Bars are commensurate with the size of the numbers in a cell in comparison to the other numbers in the list. Thus, the largest...
