Microsoft Office Tutorials and References
In Depth Information
Modifying a Data Bar Rule
Figure 4-41
Edit Formatting Rule dialog box
hides the cell
value, showing
only the data bar
defines the value
used for the
shortest data bar
defines the value
used for the
longest data bar
sets the fill and
border colors of
the data bars
click to define how
negative values
will be presented
in the data bars
7. Click the OK button in each dialog box, and then click cell . The lengths of the A2
data bars are reduced so that the longest bar covers less than half the cell width.
See Figure 4-42.
Figure 4-42
Revised data bars
data bar lengths are
expressed relativ e
to a maximum
value of 40%
the longest data
bar covers less than
half of the cell and
doesn't overlap the
cell value
Search JabSto ::




Custom Search