Microsoft Office Tutorials and References
In Depth Information
Displaying Information with Charts
Book V
Chapter 3
Figure 3-2:
To format a
text box to
appear as
data bars,
set the
control’s
conditional
formatting.
Your options are as follows:
• Ifyoudon’twantavaluetoappearattherightendofthecontrol,
click the Show Bar Only check box.
• Setthenumberthatwillberepresentedbytheshortestbar.The
default is for it to represent the lowest value in the field to be
graphed. You can set Shortest Bar to Number and enter a specific
number for the shortest bar to represent (0 may be a good choice for
many charts), or you can set Shortest Bar to Percent and enter a
percentage ( for 50 percent, for example). .5
• Setthenumberthatwillberepresentedbythelongestbar.The
default value is for it to represent the highest value. In Figure 3-2, the
default settings are selected.
7. Click OK to save your new formatting rule and close the New
Formatting Rule dialog box.
You return to the Conditional Formatting Rules Manager dialog box.
8. Click OK to dismiss the Conditional Formatting Rules Manager
dialog box.
In Layout view, you see your data bars right away. If you’re using Design
view, switch to Layout view or Print Preview to see them. (Right-click the
tab for the report and choose Layout View or Print Preview from the
contextual menu.)
Displaying Information with Charts
Access databases contain different types of objects: tables, queries, forms,
reports, and the rest. But what about charts? Where are they stored?
Access stores charts as controls on forms or reports because they’re meant
to be viewed (such as forms) or printed (such as reports). Before you make
Search JabSto ::




Custom Search