Database Reference
In-Depth Information
10.
Under X-Axis, type
Date
into the Title field
.
11.
Click the square button to the right of the X-Axis Data field and then select Spe-
cify Field Name. In the Specify Field dialog box that appears, set pop-up menu to
Attendance
.
12.
From the field list, select Visit Date and then click OK
.
13.
Under Y-Axis, type
Visitors
into the Title field. Because this will be a two-series
chart, click the “Add a Y Series” button
.
14.
In the box on the left, click “Series 1.” In the Series Name box, type
Repeat
.
15.
Click the button next to the Data box and choose Specify Field Name. In the Spe-
cify Field dialog box that appears, set the pop-up menu to Attendance, select the
ReentryCount field and then click OK
.
16.
In the box on the left, click “Series 2.” In the Series Name box, type
Unique
.
17.
Click the button next to the Data box and then choose Specify Field Name. In the
Specify Field dialog box that appears, set the pop-up menu to Attendance, select
the VisitorCount field and then click OK
.
18.
Turn on Show Legend. Under Axis Options, select X-Axis and set the Label
Angle to 45
.
This option prevents the labels that run along the bottom of the chart from overlap-
ping one another.
Your Chart Setup should resemble the one in
Figure 15-30
.
Optionally, you may
change the legend formatting.