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.The finished Pivot Chart is shown in Figure 1.31.FIGURE 1.31
A completed PivotChart.Access 2007 reports have some interactivity, and PivotTables and PivotCharts have almost unlim-
ited 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.Part I The Office Components and What They Do Best