How We Create Pivot Table in Spreadsheet

How We Create Pivot Table in Spreadsheet

@seema.kothari1 Kindly help Jayshree solve her query. Thanks.

Hi! Jayshree,

To create a pivot table:

  1. Select a cell in your data table.
  2. Select Insert > PivotChart !
  3. Select the cell where you want the PivotChart to appear; in the same sheet or another sheet.
  4. Select OK.
  5. Select the fields from the data table to display in the menu.

You can use Windows Automation.