Microsoft Office Tutorials and References
In Depth Information
Figure 19-4: 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 Styles Conditional 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.
Search JabSto ::

Custom Search