Pivot Charts

Making a PivotChart is even easier: select the data source query or table and click the PivotChart button in the Forms group in the Create tab of the Ribbon. Figure 1.27 shows the new, blank PivotChart with drop zones at the top and right sides of the form.

FIGURE 1.27

A new, blank PivotChart.

FIGURE 1.27

A new, blank PivotChart.

As with a PivotTable, you simply drag fields from the field list to the appropriate drop zones. I dragged the OrderQuarter field to the Category field drop zone, the Supplier field to the Series drop zone, the CategoryName to the Filter drop zone, and the Price field to the Data drop zone, and I selected the Dairy Products category for filtering the data. Figure 1.28 shows the PivotChart at this point.

FIGURE 1.28

The PivotChart with fields assigned to its drop zones.

FIGURE 1.28

The PivotChart with fields assigned to its drop zones.

Vba Chart Axis

The next step is to give names to the charts vertical and horizontal axes. To name the axes, select an Axis Title label, open the property sheet, and select its Format tab; enter the name you want to display for that axis in the Caption property, as shown in Figure 1.29. Repeat for the other axis label.

FIGURE 1.29

Naming the vertical axis of a PivotChart.

FIGURE 1.29

Naming the vertical axis of a PivotChart.

To make the chart's Legend visible (generally a good idea), click the Legend button in the Show/Hide group of the Design tab of the Ribbon, as shown in Figure 1.30.

FIGURE 1.30

Making the PivotChart's Legend visible.

FIGURE 1.30

Making the PivotChart's Legend visible.

The finished Pivot Chart is shown in Figure 1.31.

FIGURE 1.31

A completed PivotChart.

FIGURE 1.31

A completed PivotChart.

Access 2007 reports have some interactivity, and PivotTables and PivotCharts have almost unlimited interactivity, but both have a serious limitation: the interactivity is available only when you are working in the Access database; when you send an Access report, PivotTable, or PivotChart to someone else who doesn't have Access, say as a PDF file, the recipient gets a read-only image of the report, PivotTable, or PivotChart, with no interactivity. This may be what you want in some cases; but if you need to deliver data in a worksheet or chart format that users can interact with, you need to create an Excel worksheet or chart from your Access data, rather than a report, PivotTable, or PivotChart.

0 0

Post a comment