Charts & pivot tables
Build, format and fix charts and pivot tables.
- Power Pivot Troubleshooting: Fix Common Excel IssuesTo troubleshoot Power Pivot in Excel for Microsoft 365 on Windows, first confirm the Power Pivot add-in is enabled, then check the…
- Power Pivot Not Working? Fix Common Excel ProblemsIf Power Pivot is not working in Excel for Microsoft 365 on Windows, first enable its COM add-in: go to File >…
- Power Pivot Sort Order: Sort Labels and MonthsTo control label order in Power Pivot, select the label column in the Power Pivot window, choose Home > Sort by Column,…
- Excel Pivot Table Field Name Not Valid? Fix ItThe Excel “PivotTable field name is not valid” error usually means the selected source range has a missing column heading, or Excel…
- Excel Pivot Table Using Two Data Tables: How It WorksYes. In Excel for Microsoft 365 on Windows, add both Excel tables to the Data Model, create a relationship between their matching…
- Excel Pivot Tables With Multiple Data Sources: How-ToYes. In Excel for Microsoft 365 on Windows, you can build one PivotTable from multiple tables by adding them to the Data…
- Excel Pivot Table Totals at Top? Show SubtotalsYes. To put category subtotals above their detail rows in Excel for Microsoft 365 on Windows, click inside the PivotTable, then choose…
- Excel Pivot Table: How to Use the Same Field TwiceYes. In Excel for Microsoft 365 on Windows, you can add the same source field to a PivotTable’s Values area more than…
- Excel Pivot Tables: Summarize Dates by MonthYes. In Excel for Microsoft 365 on Windows, put your dates in a PivotTable, right-click a date in the table, choose Group,…
- Excel Pivot Table Rows Side by Side: Layout, Steps, and TipsTo put PivotTable row fields side by side in Excel for Microsoft 365 on Windows, click inside the PivotTable and choose PivotTable…
- Excel Pivot Table: Remove Old Filter Values After RefreshTo remove deleted items from an Excel PivotTable filter, open PivotTable Options, set Number of items to retain per field to None,…
- Excel Pivot Table Spill Error: Causes and FixesAn Excel PivotTable spill error usually means a dynamic-array formula cannot place all its results because the PivotTable output or other occupied…
- Excel Pivot Table Not Updating? Fix the Source DataIf an Excel PivotTable is not showing new rows, refresh it and check whether its source includes those rows. Use PivotTable Analyze…
- Excel Pivot Table Order Columns: Sort and RearrangeIn Excel for Microsoft 365 on Windows, reorder PivotTable columns by dragging fields within the Columns area of the PivotTable Fields pane;…
- Excel Pivot Table Not Showing Dates Correctly?If an Excel PivotTable is showing dates as numbers, text, individual days, or unexpected months, first check that the source column contains…
- Excel Pivot Table: How to Keep Formatting on RefreshTo keep formatting when an Excel PivotTable refreshes, select the PivotTable, open PivotTable Analyze > Options, and on the Layout & Format…
- Excel Pivot Table Row Limit: What You Need to KnowIn Excel for Microsoft 365 on Windows, a PivotTable displayed on a worksheet is limited by the worksheet grid: 1,048,576 rows in…
- Excel Pivot Table Months Not in Order? Fix the DatesIf Excel PivotTable months are out of order, first check whether the source column contains real dates or month names stored as…
- Excel Pivot Table: How to Find the Original Source DataTo find an Excel PivotTable’s source, click any cell in the PivotTable, then choose PivotTable Analyze > Change Data Source. The dialog…
- Excel Pivot Table: How to Group Dates by MonthIn Excel for Microsoft 365 on Windows, click a date in the PivotTable, right-click, choose Group, select Months, and click OK. If…
- Excel Pivot Table Grand Total at Top: What WorksYou cannot move a PivotTable’s built-in grand total row to the top in Excel for Microsoft 365 on Windows; Excel keeps that…
- Excel Pivot Table: Filter Out Zero ValuesTo filter zero values out of an Excel PivotTable, open the drop-down for the row or column field you want to filter,…
- Excel Pivot Table: How to Delete a Calculated FieldTo delete a calculated field in an Excel PivotTable, select the PivotTable, then choose PivotTable Analyze > Fields, Items, & Sets >…
- Excel Pivot Table Field List Not Showing? Fixes in ExcelIf the PivotTable Field List is missing in Excel for Microsoft 365 on Windows, click any cell inside the PivotTable, then select…
- Excel Pivot Table Date Filters: How to Use Them WellTo filter dates in an Excel PivotTable, open the drop-down beside the date field in the Rows or Columns area, choose Date…
- Excel Pivot Table: Add a Field to Filters and RowsTo add a PivotTable field to both a filter and a row, open the PivotTable Fields pane and drag the field from…
- Excel Pivot Table Columns Side by Side: How to ShowTo show PivotTable categories side by side, select the PivotTable, open the PivotTable Fields pane, and drag the field you want across…
- Excel Dashboard Inspiration: Practical Ideas and Design TipsExcel dashboard inspiration starts with a clear question: what should someone understand or decide after looking at the page? For Microsoft Excel…
- Excel Dashboard Styles: Layouts, Uses, and Design TipsExcel dashboard styles are the visual and structural approaches used to present important measures, trends, and comparisons on a compact worksheet. Common…
- Excel Graph With Drop-Down Selection: Build a Dynamic ChartYes. In Excel for Microsoft 365 on Windows, create a drop-down with Data Validation, then connect a chart to a helper range…