Data: Switch Row/Column

4. What Else Do You See? When you switched the Rows and Columns, the PivotChart was updated as well. This PivotChart uses color and position to display the sales data. Each product listed on the Axis can have up to four columns of data. The Sum of Amount is displayed on the left, formatted as currency.  What Do You Think? Can you read and understand this PivotChart? Keep going...!

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.4. Apply and manipulate PivotCharts: Switch Row/Column Data

PivotChart Tools ->Design ->Data->Switch Row/Column