What are the steps to create a PIVOT Table in Excel?

Data Science, AI and ML
,
1

Create a PivotChart:

  1. Select a cell in your table.
  2. Select Insert > PivotChart .
  3. Select OK.

Create a Chart from a PivotTable:

  1. Select a cell in your table.
  2. Select PivotTable Tools > Analyze > PivotChart .
  3. Select a chart.
  4. Select OK.

After you change the setting, the pivot table on the worksheet shows a blue border around each region.

You can now drag the pivot fields from the PivotTable Field List onto the worksheet, or drag the fields to a different part of the pivot table.

  1. Point to a field label in the pivot table layout
  2. When the pointer changes to a four-headed arrow, drag the field label to a different area

You can use the same technique to drag fields into the pivot table layout from the PivotTable Field List, or drag field labels out of the pivot table layout.