graphic2
graphic1

Exam 77-427 Microsoft Excel 2013 Expert
4. Create Advanced Charts and Tables
4.2 Create and Manage PivotTables: Use PowerPivot

Create a PivotTable

9. Try This: Find the PivotTable Formatting
Go to Home->Formatting->PivotTable.

What Did You see? The options include:
PivotTable
PivotChart
Chart and Table (Horizontal)
Chart and Table (Vertical)
Two Charts (Horizontal)
Two Charts (Vertical)
Four Charts
Flattened PivotTable

And Try This: Format the PowerTable
Select: PivotChart.
At the prompt select a New Worksheet.
Click OK.

What Do You See? A new PivotChart will be created in Excel. It will be blank.

We will edit the Fields in a minute.


Keeep going...

Home ->Formatting-> PivotTable

pic1