Expand Active Field

4. What Do You See? There should be a new filter on the PivotChart legend.

 

The example on this page shows which sales rep sold what products.

 

This is an interactive PivotChart. You can filter the information by Category (Corporate, Educational, Government, Private), Product and Sales Rep.

 

But wait, there really is more....

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.4. Apply and manipulate PivotCharts: Analyze Data with the Active Field

PivotChart Tools ->Analyze ->Active Field