Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Pivot Table Repeat Row Labels: How to Do It EasilyTo repeat row labels in an Excel PivotTable, select the PivotTable, choose PivotTable Design > Report Layout > Show in Tabular Form,…
- Excel Pivot Table: Remove Row TotalsTo remove the bottom grand-total row in an Excel PivotTable, select the table and choose PivotTable Design > Grand Totals > On…
- Excel Pivot Table: Remove Subtotals in Every LayoutTo remove every subtotal from an Excel PivotTable, select a cell in the table and choose PivotTable Design > Layout > Subtotals…
- Excel Pivot Table: How to Remove Grand Totals and SubtotalsTo remove grand totals from an Excel PivotTable in Microsoft 365 for Windows, click inside the PivotTable, open Design on the ribbon,…
- Excel Pivot Table Relationships: How to Link DataExcel PivotTable relationships connect separate tables through matching columns in the workbook’s Data Model, so you can summarize related information in one…
- Excel Pivot Table: How to Remove Zero ValuesTo remove zero-valued results from an Excel PivotTable, open the drop-down for the row or column field, choose Value Filters, then set…
- Excel Pivot Table Range: How to Set, Change, and Fix RangesAn Excel PivotTable range is the set of source cells the PivotTable reads, including the column headers and all rows of data.…
- Excel Pivot Table: Put Row Fields Side by SideTo put PivotTable row fields next to each other in separate columns, select the PivotTable and choose Design > Report Layout >…
- Excel Pivot Table Percentage of Total: How to Show ItTo show Excel PivotTable values as a percentage, right-click a value in the PivotTable and choose Show Values As, then select %…
- Excel Pivot Table: Percentage of Two ColumnsTo show one PivotTable column as a percentage of another in Excel for Microsoft 365 on Windows, add the value field to…
- Excel Pivot Table Options: Settings, Layouts, and AnalysisExcel PivotTable options let you control how a summary is arranged, calculated, filtered, refreshed, and displayed. In Microsoft 365 for Windows, select…
- Excel Pivot Table Not Updating? Fix It Step by StepIf an Excel PivotTable is not updating, click inside it and select PivotTable Analyze > Refresh; to refresh all PivotTables and workbook…
- Excel Pivot Table: Show Unique Values Without RepeatsYes. To show each distinct item once in an Excel PivotTable, drag its field into the Rows area; Excel groups matching labels…
- Excel Pivot Table Not Sorting Correctly? Fix ItIf an Excel PivotTable is not sorting correctly, first choose the field and sort direction you actually want: right-click a row label…
- Excel Pivot Table Not Showing All Data? Causes and FixesIf an Excel PivotTable is missing data, first check that its source range includes every record, then refresh it and clear any…
- Excel Pivot Table Not Refreshing? Fix the Source and CacheIf an Excel PivotTable is not refreshing, select a cell inside it and choose PivotTable Analyze > Refresh; for every PivotTable and…
- Excel Pivot Table Not Recognizing Dates? How to Fix ItIf an Excel PivotTable is not recognizing dates, first check whether the source cells contain real Excel date values rather than text;…
- Excel Pivot Table Not Pulling All Data? Fix ItIf an Excel PivotTable is missing rows, first refresh it, then check whether its data source includes those rows and whether a…
- Excel Pivot Table: Move a Row Field to Column LabelsTo move a row field to columns in an Excel PivotTable, click inside the PivotTable, open PivotTable Analyze > Field List, then…
- Excel Pivot Table Min and Max Values: How to Show ThemTo show a minimum or maximum in an Excel PivotTable, put a numeric or date field in the Values area, right-click one…
- Excel Pivot Table Manual Sort: Drag Items into OrderTo manually sort items in an Excel PivotTable, right-click an item label, choose Sort > More Sort Options, select Manual, and click…
- Excel Pivot Table Layout: Rows, Columns, Values & FiltersAn Excel PivotTable layout is the arrangement of fields in four areas—Rows, Columns, Values, and Filters—that determines how source data is grouped…
- Excel Pivot Table Calculated Field: How to Add OneTo insert a calculated field in an Excel PivotTable, select the PivotTable, then choose PivotTable Analyze > Fields, Items, & Sets >…
- Excel Pivot Table Instructions for Building Clear ReportsTo create a PivotTable in Excel for Microsoft 365 on Windows, select a cell in a clean data range, choose Insert >…
- Excel Pivot Table: How to Hide Rows With Zero ValuesTo hide rows whose PivotTable result is zero in Excel for Microsoft 365 on Windows, open the drop-down for the field in…
- Excel Pivot Table Fields Not Showing? How to Fix ItIf Excel PivotTable fields are not showing, click inside the PivotTable and select PivotTable Analyze > Show > Field List. If the…
- Excel Pivot Table Group by Value Range: How It WorksYes. In Excel for Microsoft 365 on Windows, put a numeric field in a PivotTable’s Rows or Columns area, right-click one of…
- Excel Pivot Table Data Range: How to Extend It SafelyTo extend an Excel PivotTable’s source range, select the PivotTable, choose PivotTable Analyze > Change Data Source, enter or select the larger…
- Excel Pivot Table: How to Expand All GroupsTo expand a PivotTable field across all its items in Excel for Microsoft 365 on Windows, right-click an item in that field…
- Excel Pivot Table: How to Exclude Specific ValuesTo exclude values from an Excel PivotTable, open the drop-down for the field containing them, clear the checkboxes beside the items you…