Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Pivot Table Filter by Year: Steps and FixesTo filter an Excel PivotTable by year, group its date field by years, then use the resulting Years field’s dropdown to select…
- Excel Pivot Table Filter Contains: How to Filter TextTo filter an Excel PivotTable for labels containing particular text, open the dropdown for the row or column field, choose Label Filters…
- Excel Pivot Table Filter by Unique ValuesYes. In Excel, a PivotTable field already lists each distinct label once, even when that value appears in many source rows; use…
- Excel Pivot Table Filter After a Date: Steps and FixesTo show PivotTable records later than a chosen date, open the date field’s dropdown, choose Date Filters > After, enter the cutoff…
- Excel Pivot Table Filters Based on FormulasExcel PivotTable filters cannot directly run a custom worksheet formula as a condition on each source row. To filter rows by a…
- Excel Pivot Table Date Range Filters: How to Use ThemTo filter an Excel PivotTable to a date range, open the dropdown for the date field in the PivotTable and choose Date…
- Excel Pivot Table Data Source Not Valid? Fix ItThe Excel message “The data source reference is not valid” usually means Excel cannot resolve the range, table, or connection selected for…
- Excel Pivot Table Error Message: Causes, Checks, and FixesAn Excel PivotTable error is usually caused by a blank or invalid source-data header, an incorrect source range, a refresh problem, or…
- Excel Pivot Table Fields in Filters and Rows ExplainedIn Excel for Microsoft 365 on Windows, a PivotTable field normally cannot occupy the Filters and Rows areas at the same time:…
- Excel Pivot Table Won’t Group Dates? Fixes That WorkIf an Excel PivotTable will not group dates, first check that every value in the source date column is a real Excel…
- Excel Pivot Table Errors: Causes and FixesMost Excel PivotTable errors come from a blank or invalid source-data header, a changed data source, values that cannot be grouped, or…
- Excel Pivot Table Divide by Zero Error: Causes and FixesAn Excel PivotTable’s #DIV/0! usually comes from a division formula in its source data or a calculated field whose denominator is zero;…
- Excel Pivot Table Date Filter by Month: Steps and FixesTo filter an Excel PivotTable by month, place a real date field in Rows, open its field dropdown, and choose Date Filters…
- Excel Pivot Table Date Filter by Week: Setup and FixesTo filter an Excel PivotTable by week, right-click a date in the PivotTable, choose Group, select Days, enter 7 for Number of…
- Excel Pivot Table Date Filter: Last 30 DaysTo filter an Excel PivotTable to the last 30 calendar days, add a helper column to the source data with a formula…
- Excel Pivot Table Custom Filters: How to Use ThemTo add a custom filter to an Excel PivotTable, open the drop-down beside a row or column field, choose Label Filters or…
- Excel Pivot Table Data Source Reference Error?If Excel reports that a PivotTable data source reference is not valid, check that the source is a real, contiguous range or…
- Excel Pivot Table Custom Sort Order: How to Set ItTo give an Excel PivotTable a custom item order, either drag its row or column labels into the sequence you want, or…
- Excel Pivot Table Sort Order: How to Change ItTo change an Excel PivotTable’s sort order in Microsoft 365 for Windows, right-click a row or column label and choose Sort, then…
- Excel Pivot Table: Change the Grand Total CalculationTo change a PivotTable’s grand-total calculation in Excel for Microsoft 365 on Windows, right-click a value in the field, choose Summarize Values…
- Excel Pivot Table Count vs Count Numbers ExplainedIn an Excel PivotTable, Count counts nonblank entries, including text and numbers, while Count Numbers counts numeric entries only. Choose Count when…
- Excel Pivot Table Calculated Field: How to Change ItTo change an existing Excel PivotTable calculated field in Microsoft 365 for Windows, click inside the PivotTable, choose PivotTable Analyze > Fields,…
- Excel Pivot Table Can’t Group Dates? Fixes That WorkYes—Excel can group dates in a PivotTable, but it needs the source column to contain valid date values and the PivotTable must…
- Excel Pivot Table IFERROR: Calculated Field GuideYes. In a regular Excel PivotTable, you can use IFERROR in a calculated field formula to replace an error result with a…
- Excel Pivot Table Auto Refresh on Data Change?No—an Excel PivotTable does not normally refresh automatically whenever its source data changes. To update it, use PivotTable Analyze > Refresh, set…
- Excel Pivot Table Calculated Field Filter ExplainedYes, you can filter a PivotTable based on a calculated field’s results, but usually you do it with a Value Filter on…
- Excel Pivot Table: Add Filters to Every ColumnExcel does not have one command that adds a single filter to every PivotTable column. To filter across the table, place the…
- Excel Pivot Table Auto Group Dates: How It Works and FixesYes. In Excel for Microsoft 365 on Windows, a PivotTable can automatically group a date field into calendar levels such as years,…
- Excel Pivot Table Filters: Add, Change, and Use ThemTo add a filter to an Excel PivotTable, click inside the PivotTable, open the PivotTable Fields pane, and drag the field you…
- Excel Pie Chart From One Column: What You Need to KnowYes. In Excel for Microsoft 365 on Windows, select a column of numeric values, then choose Insert > Insert Pie or Doughnut…