Exam 77-420 Microsoft Excel 2013 5. Create Charts and Objects 5.1 Create a Chart: Switch Between Rows and Columns in Source Data

PivotTable Tools ->Analyze Pivot the Table What is a PivotTable, anyways? To Pivot means to move the data from the Rows into the Columns. This is cool. Before You Begin: Select the PivotTable. The PivotTable Tools should be available.   3. You Gotta Try This: Pivot the Table! Go to the Field List Drag and Drop the Category Field from the Columns to the Rows.   Please make sure that Category is ABOVE the Product field.   Really, keep going...