PivotChart: Filter the Data

You can Filter the PivotChart and show specific Ratings if you wish.

 

In this example, instead of showing all Ratings, this PivotChart will display only four Ratings.

 

4. Try it: Add a Subform/Subreport

Click on the Rating Category at the bottom of the PivotChart.

 

First, uncheck All.

(None of the Ratings are selected.)

Select (check) the following Ratings:

G

PG

PG13

R

 

Click OK.

 

How did that change the PivotChart? There should be four columns in this graph- no blanks.

PivotChart Tools ->Design->Show/Hide->Field List

Exam 77-885: Microsoft Access 2010

5. Designing Reports

5.2. Apply Report Design options: Create a Graph