Analysis: Active Field Start with the simple tools: You can select any field and show additional data.  The field that you select is called the Active Field.   You can use the Active Field to Expand (show) or Collapse (hide) more details. Say you wanted to see who sold the Fruit and Veggie products. Here are the steps.   2. Try it: Select a Field in the PivotChart Click on the PivotChart Legend. Click on a Field: Fruit and Veggies. Keep going...     Memo to Self: Expanding or Collapsing a field is easy. Selecting the correct place on the PivotChart can be frustrating!   What should you look for?  When you select a Field, the Analysis Tools will display this field as well as any other that you have enhanced. Exam 77-888: Microsoft Excel Expert 2010 3. Presenting Data Visually 3.4. Apply and manipulate PivotCharts: Analyze PivotChart Tools ->Analyze ->Active Field