Visualize the Data:
Create a PivotChart
A Crosstab
Query can be packed with information, but many people find it
helpful to see that data in a Chart. The following pages show how
to create a PivotChart.
Everything
in Access starts with the data. PivotCharts do, too. This lesson
will use the Movie table as the Record Source.
The
PivotChart will be a Form that is added to a Report. It really works
well!
1.
Try it: Create a PivotChart
Go to
All Access Objects->Tables.
Open a
Table: tblMovies.
Go to
Create ->Forms->More Forms.
Click on
PivotChart.
Keep
going...