Microsoft Office Tutorials and References
In Depth Information
Displaying Information with Charts
Making bubble and XY scatter plots
An XY scatter plot needs two numeric fields because it plots one field against
the other. For each record, you see a point with the horizontal and
vertical positions determined by the numbers in the fields. A bubble chart works
the same way, except that Access draws a circle instead of a point, and the
numeric value of a third field determines the size of the circle.
You can try making these graphs in the Chart Wizard, but we haven’t had
much luck. (Consider exporting the data to Microsoft Excel and charting it
there.) If you want to try the Chart Wizard, drag the numeric field you want
to graph along the horizontal (X) axis to the Series setting, and drag the field
you want to graph along the vertical (Y) axis to the Data setting. If the wizard
decides to aggregate either of the fields (in which case you see “Sum Of” —
the field name) , double-click the field name, and change the aggregation
setting to None.
Making charts the old-fashioned way
By far the easiest way to create a chart is to
use the Chart Wizard. If you want to create one
without a wizard, however, here’s how to do it.
Follow these steps:
1. Open a report or form in Design view.
2. Click the Unbound Object Frame
button in the Controls group on the
Design tab of the Ribbon.
3. Click the place in the Design View window
where you want your chart to appear.
You see the Microsoft Access dialog box
(which really ought to be called something
like the Insert Object dialog box).
4. Do one of the following:
✓ If you’ve created a graph in some other
program (perhaps in Excel or Word),
choose the Create from File option, click
the Browse button, and choose the file.
✓ If you’re making a new chart, choose the
Create New option, choose Microsoft
Graph Chart in the Object Type list, and
Yes, Microsoft Graph Chart sounds
redundant, but you’re creating a chart by using
the Microsoft Graph program. Makes
Access creates a sample bar chart based
on sample data that appears in a Datasheet
window. To replace the data with your own
data, type your own headings and numbers in
the Datasheet window. To change the type of
chart, see the nearby section “Changing Your