Microsoft Office Tutorials and References
In Depth Information
Displaying Information with Charts
13. Link the chart to the report by specifying a common field to link them;
then click Next.
In the example in Figure 3-6, we formed the link with the OrderID field.
You may have to try more than one field before you find the one that
14. Enter a title.
The title appears at the top of the report. The wizard suggests the name
of the table or query you chose as the record source.
15. Specify whether to display legends.
Legends show what the colors of the bars, lines, or pie sections mean.
Usually, including them is a good idea.
16. Click Finish.
The wizard creates a new chart control in your new or existing report.
In Design view, Access shows a sample chart, not the actual chart. The
chart is of the type that you select, but with sample data. Don’t worry;
your real chart is on the report. Switch to Print Preview to see the actual
chart, as shown in Figure 3-7.
you can see
it in Print
17. Drag and resize the chart control as needed.
After the Chart Wizard creates your chart control, you can move the
control around your report by dragging it. You can also resize the chart
by selecting the control and then dragging the black handles on the
edges of the control. (If you double-click the chart control, you find
yourself in a strange new editing mode, described in “Formatting charts
with colors, legends, and titles,” later in this chapter.)
A report can contain more than one chart control. You may want to make a
report that contains three chart controls that display three different charts.
Just make the additional controls in Design view by clicking the Chart button
in the Controls group on the Design tab of the Ribbon and specifying where
you want the new control to appear.