Log in
x
or
x
x
Register
x

or

Excel Tips: Insert > PivotTable and PivotChart

PivotTable

Data Source of PivotTable

How to combine multiple sheets into a pivot table in Excel?

How to consolidate multiple ranges into one pivot table in Excel?

How to create a Pivot Table from Text file in Excel?

How to update pivot table range in Excel?

Add or Remove Fields

How to add calculated field to pivot table?

How to add multiple fields into pivot table?

How to remove calculated field from pivot table?

Grand Total or Subtotal

How to add percentage of grand total/subtotal column in an Excel Pivot Table?

How to display grand total at top in pivot table?

How to hide grand total in an Excel pivot table?

How to hide subtotals in pivot table?

How to show grand total as percentage in Excel PivotTable?

How to show multiple grand totals in pivot table?

Filter in PivotTable

How to apply the same filter to multiple pivot tables?

How to create and filter a pivot table in Excel 2007/2010/2013?

How to filter Pivot table based on a specific cell value in Excel?

How to filter top 10 items in pivot table?

How to hide blank rows in PivotTable in Excel?

How to hide selected items in pivot table?

How to hide zero value rows in pivot table?

How to link Pivot Table filter to a certain cell in Excel?

Sort in PivotTable

How to sort by sum in Pivot Table in Excel?

How to sort data from left to right in pivot table?

How to sort field list in pivot table?

How to sort with custom list order in pivot table?

Group in PivotTable

How to group a pivot table by day of week in Excel?

How to group by age in pivot table?

How to group by fiscal year in an Excel pivot table?

How to group by range in an Excel Pivot Table?

How to group by week in pivot table?

How to group data by half a year in Excel PivotTable?

How to group data by half an hour or 15 minutes in Excel PivotTable?

How to group date by month/year/quarter in pivot table in Excel?

How to group time by hour in an Excel pivot table?

How to group time by minutes or hours intervals in Excel?

How to rename group or row labels in Excel PivotTable?

How to ungroup dates in an Excel pivot table?

Format PivotTable

How to alternate row color in an Excel Pivot Table?

How to conditional formatting pivot table in Excel?

How to hide error values in pivot table?

How to lock column width in pivot table?

How to make row labels on same line in pivot table?

How to preserve formatting after refreshing pivot table?

How to remove bold font of pivot table in Excel?

How to show zero in empty cells in pivot table in Excel?

Refresh PivotTable

How to automatically refresh a Pivot Table in Excel?

How to refresh pivot table on file open in Excel?

How to refresh pivot table on protected sheet?

How to refresh pivot table when data changes in Excel?

Others

How to average per day/month/quarter/hour with pivot table in Excel?

How to calculate median in an Excel pivot table?

How to calculate weighted average in an Excel Pivot Table?

How to change multiple field settings in pivot table?

How to check if a pivot table exists in a workbook?

How to clear filter cache (old items) from Pivot Table in Excel?

How to clear old items in pivot table?

How to convert PivotTable to list in Excel

How to create clickable hyperlinks in pivot table?

How to delete one or all pivot tables in Excel?

How to disable select multiple items in pivot table?

How to display table or pivot table name in a cell in Excel?

How to enable show details in PivotTable in Excel?

How to hide expand collapse buttons in pivot table?

How to hide/show pivot table field list in Excel?

How to insert page break into pivot table?

How to keep slicer of Pivot Table moving with worksheet scrolling in Excel?

How to list all pivot tables from a workbook?

How to protect pivot table in Excel?

How to repeat row labels for group in pivot table?

How to reverse a pivot table in Excel?

How to set classic pivot table layout in Excel?

How to set the Sum function as the default function in Pivot table?

PivotChart

How to add average/grand total line in a pivot chart in Excel?

How to add secondary axis to pivot chart in Excel?

How to change date format in axis of chart/Pivotchart in Excel?

How to change/edit Pivot Chart's data source/axis/legends in Excel?

How to create pivot chart in Excel 2007/2010/2013?

How to create stacked column chart from a pivot table in Excel?

How to filter by month in a pivot chart in Excel?

How to filter date range in an Excel Pivot Table?

How to show or hide filed buttons in pivot chart in Excel?