Microsoft Office Tutorials and References
In Depth Information
Chapter 3: Creating Charts and Graphs from Your Data
The data bar is actually a text box that contains a numeric value. To make
the text box look like a horizontal bar, Access strangely uses conditional
formatting to apply the format. Here’s how:
1. Create a new report, or open an existing report in Design or
To make a new report, click the Report Design button in the Reports
group on the Create tab of the Ribbon. To open an existing report in
Design view, right-click the report and choose Design View from the
contextual menu. (See Book V, Chapter 1 for details on editing reports in
Design and Layout views.) For this example, we created a new report
based on the Product Sales by Month_Crosstab query. The report opens
in Layout view.
2. In the new report, select a value in the Total of ExtPrice column.
Access encloses the selected value in an orange box.
3. Click the Conditional Formatting button in the Control Formatting
group on the Format tab of the Ribbon.
The Conditional Formatting Rules Manager dialog box opens, with Total
of ExtPrice selected after the Show Formatting Rules For prompt.
4. Click the New Rule button to display the New Formatting Rule dialog
box, shown in Figure 3-2.
5. Set the Select a Rule Type drop-down menu to Compare to Other
Now the dialog box shows settings for data bars, and it looks a lot more
like Figure 3-2.
6. Configure your data bars.