Skip to content
- 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…Charts & pivot tables
- 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…Charts & pivot tables
- 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…Charts & pivot tables
- 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,…Charts & pivot tables
- 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…Charts & pivot tables
- 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,…Charts & pivot tables
- 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…Charts & pivot tables
- 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;…Charts & pivot tables
- 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…Charts & pivot tables
- 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…Charts & pivot tables
- 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…Charts & pivot tables
- 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…Charts & pivot tables
- 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…Charts & pivot tables
- 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…Charts & pivot tables
- 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…Charts & pivot tables
- 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…Charts & pivot tables
- 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,…Charts & pivot tables
- 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…Charts & pivot tables
- 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 >…Charts & pivot tables
- 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…Charts & pivot tables
- 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…Charts & pivot tables
- 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…Charts & pivot tables
- 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…Charts & pivot tables
- 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…Charts & pivot tables
- Excel Dashboard Color Schemes That Make Data ClearAn effective Excel dashboard color scheme uses a small, consistent palette: neutral backgrounds, one or two colors for emphasis, and distinct colors…Charts & pivot tables
- 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…Charts & pivot tables
- Excel Graph With Dates on the X-Axis: Setup and FixesTo make an Excel graph with dates on the x-axis, put real Excel dates in one column and the values to chart…Charts & pivot tables
- Excel Stacked Bar Total Labels: Show the Full Sum EasilyTo show a total at the end of each stacked bar in Excel for Microsoft 365 on Windows, calculate the totals in…How-to basics
- Excel Graph Reverse Data Order: Flip an Axis or SeriesTo reverse the order of categories in an Excel graph, select the chart, right-click its category axis, choose Format Axis, and turn…Charts & pivot tables
- Excel Graph Only Shows Some Data Labels? Fix ItIf an Excel graph shows only some data labels, first check whether labels were added to every data point in the series;…Charts & pivot tables