Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Pivot Table: Remove Column Labels or Filter?To hide the PivotTable’s column headings and their drop-down buttons in Excel for Microsoft 365 on Windows, click inside the PivotTable and…
- Excel Pivot Table: Hide Filter Buttons, Keep FiltersTo hide the filter buttons in an Excel PivotTable without clearing its current filter selections, click anywhere in the PivotTable and choose…
- Excel Pivot Table Percent Difference: How to Show ChangeTo show percent change in an Excel PivotTable, select a value cell, choose Show Values As > % Difference From, then set…
- Excel Pivot Table Percent Change: How to Show ItTo show percent change in an Excel PivotTable, add the value field to the Values area twice, then right-click the second value…
- Excel Pivot Table Refresh All Not Working? Try These FixesIf Excel’s Refresh All command is not updating a PivotTable, first check whether the PivotTable’s source includes the new or changed data.…
- Excel Pivot Table: Move a Filter to Another AreaTo move a filter field in an Excel PivotTable, open the PivotTable Fields pane and drag the field from its current box—such…
- Excel Pivot Table Won’t Group Dates? How to Fix ItIf an Excel PivotTable will not group dates, first check that every value in the source date column is a real Excel…
- Excel Pivot Table Org Chart: Options and WorkaroundsAn Excel PivotTable cannot turn employee records into a graphical organization chart with connected boxes. It can summarize reporting data in a…
- Excel Pivot Table Group Error: Causes and FixesWhen Excel shows “Cannot group that selection” in a PivotTable, the selected field usually contains blanks, errors, or values stored in inconsistent…
- Excel Pivot Table Hide Filter: What You Can RemoveTo hide Excel PivotTable filter arrows without removing the current filter, select the PivotTable and choose PivotTable Analyze > Show > Field…
- Excel Pivot Table: Group Dates into Months and YearsYes. In Excel for Microsoft 365 on Windows, right-click any date in the PivotTable, choose Group, select Months, and click OK; if…
- Excel Pivot Table: Group Dates by YearTo group dates by year in an Excel PivotTable, right-click any date in the PivotTable, choose Group, select Years in the Grouping…
- Excel Pivot Table: Filter Values Greater Than a NumberTo show PivotTable items whose summarized value exceeds a threshold, open the drop-down for the row or column field, choose Value Filters…
- Excel Pivot Table Filters: Sum Values the Right WayYes. In an Excel PivotTable, choose a filter to show the records or categories you want, and set the numeric field to…
- Excel Pivot Table Filter Showing Old Data? Fix ItYes. An Excel PivotTable filter can keep showing old item names after the source data has changed because the PivotTable cache may…
- Excel Pivot Table Filter Showing Old Values? Fix ItIf an Excel PivotTable filter still lists values that have been removed from the source, refresh the PivotTable and set its cache…
- Excel Pivot Table: Filter and Sort AlphabeticallyYes. In Excel for Microsoft 365 on Windows, click a PivotTable row or column label, open its drop-down arrow, and choose Sort…
- Excel Pivot Table Filter on Grand Total: How It WorksYou cannot apply a filter to the PivotTable’s Grand Total row or column as if it were a regular field item. To…
- Excel Pivot Table Filter: Show Multiple Items at OnceYes. In Excel for Microsoft 365 on Windows, open the PivotTable field’s filter dropdown, turn on Select Multiple Items when it appears,…
- Excel Pivot Table Filter Not Working? Fixes That HelpIf an Excel PivotTable filter is not working, first refresh the PivotTable and check that its source data includes the rows you…
- Excel Pivot Table Filter: Less Than an Amount?To filter a PivotTable to amounts less than a threshold in Excel for Microsoft 365 on Windows, open the drop-down for a…
- Excel Pivot Table Filter Multiple Values: Quick GuideTo filter a PivotTable to several values in Excel for Microsoft 365 on Windows, open the drop-down for the field, clear Select…
- Excel Pivot Table Filter Not Refreshing? Fixes That WorkIf an Excel pivot table filter is not refreshing, first select the PivotTable and choose PivotTable Analyze > Refresh; then confirm that…
- Excel Pivot Table Filter: How to Invert SelectionExcel PivotTables do not have a dedicated Invert Selection command for filters. To show everything except a few items, open the field’s…
- Excel Pivot Table Filter Greater Than: How to Set ItTo filter an Excel PivotTable for values greater than a threshold, open the drop-down for a Row or Column field, choose Value…
- Excel Pivot Table Filter by Month: Step-by-StepTo filter an Excel PivotTable by month, place the date field in Rows or Columns, right-click a date in the PivotTable, choose…
- Excel Pivot Table Filters: How to Exclude Matching ItemsTo exclude PivotTable items containing particular text, open the dropdown for a row or column field, choose Label Filters > Does Not…
- Excel Pivot Table Filter: Count Greater Than a ValueTo show only PivotTable items whose count exceeds a number, apply a value filter: open the dropdown for the row or column…
- Excel Pivot Table: Filter Dates by YearTo filter an Excel PivotTable by year, group its date field: right-click any date in the PivotTable, choose Group, select Years, and…
- Excel Pivot Table Dates Not Grouping? How to Fix ItIf dates in an Excel PivotTable will not group, first check that every cell in the source date column contains a real…