Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Polynomial Trendline: Add, Interpret, and Use ItTo add a polynomial trendline in Excel for Microsoft 365 on Windows, select a chart series, then choose Chart Design > Add…
- Excel Pivot Table Slicer Greyed Out? How to Fix ItIf Excel’s Insert Slicer command is greyed out, first click a cell inside the PivotTable you want to filter; the command is…
- Excel Pivot Table Slicer Search: Options and WorkaroundsNo: a standard Excel PivotTable slicer does not have a built-in search field you can add or turn on. To find an…
- Excel Pivot Table Not Refreshing? Fix the Data SourceIf an Excel PivotTable is not showing your latest data, select a cell in it and choose PivotTable Analyze > Refresh, or…
- Excel Pivot Table: Show Values Without CalculatingYes—set the value field’s Show Values As option to No Calculation to display its normal result instead of a percentage, running total,…
- Excel Pivot Table: Group Dates by Month, Quarter, YearIn an Excel PivotTable, you can group a date field by month, quarter, year, or several of those levels at once. Add…
- Excel Pivot Table: How to Ignore Blank Rows and ValuesYes. In Excel for Microsoft 365 on Windows, open the pivot field’s drop-down and clear the (blank) item to hide records with…
- Excel Pivot Table Histogram: Create Bins and CountsYes. In Excel for Microsoft 365 on Windows, create a PivotTable from your numeric data, place the measured field in both Rows…
- Excel Pivot Table: Hide Columns Without Losing DataIn Excel for Microsoft 365 on Windows, select the worksheet column letter above the PivotTable and choose Home > Format > Hide…
- Excel Pivot Table: How to Hide Blank Rows and ValuesTo hide a blank category in an Excel PivotTable, open the filter arrow for its Row Labels or Column Labels field, clear…
- Excel Pivot Table Help: Create, Fix, and Analyze DataTo create a PivotTable in Excel for Microsoft 365 on Windows, select a cell in a clean data range, choose Insert >…
- Excel Pivot Table Grouping: Dates, Numbers, and LabelsIn Excel for Microsoft 365 on Windows, group PivotTable items by selecting a date, number, or label in the table, then choose…
- Excel Pivot Table Formatting: A Practical GuideTo format an Excel PivotTable in Microsoft 365 for Windows, click inside it, open the contextual Design tab, and choose a style…
- Excel Pivot Table Format Keeps Changing? Fix ItIf your Excel PivotTable formatting keeps changing after a refresh, open PivotTable Options and check Preserve cell formatting on update. Right-click a…
- Excel Pivot Tables for Beginners: Build Your First SummaryAn Excel PivotTable quickly summarizes a list of records without changing the original data. In Microsoft 365 for Windows, select a cell…
- Excel Pivot Table Fiscal Year: How to Group Dates CorrectlyExcel PivotTables do not automatically group dates by your organization’s fiscal year: built-in date grouping uses calendar years. For fiscal-year reporting, add…
- Excel Pivot Table Exercises: Guided Practice Tasks and AnswersExcel PivotTable exercises help you practise summarizing and exploring data without writing formulas. Start with the sample sales records below, create a…
- Excel Pivot Table Not Showing Blank Values? How to Fix ItIf an Excel PivotTable does not show blank values, first check the field’s filter for a hidden (blank) item, then refresh the…
- Excel Pivot Tables: Display Data in Separate ColumnsTo display a PivotTable’s row fields in separate columns in Excel for Microsoft 365 on Windows, select the PivotTable and choose PivotTable…
- Excel Pivot Table: Group Dates by Year, Quarter & MonthYes. In Excel for Microsoft 365 on Windows, put a real date field in a PivotTable, right-click one of its dates, choose…
- Excel Pivot Table Data Source Not Valid? How to FixIf Excel says “Data source reference is not valid” when you create or change a PivotTable, check that the source is one…
- Excel Pivot Table Data Source: Setup and TroubleshootingAn Excel PivotTable data source is the table, cell range, workbook data model, or external connection that supplies the records summarized in…
- How to Make a Timeline Graph in PowerPoint: Step by StepTo make a timeline graph in PowerPoint, choose Insert > SmartArt > Process > Basic Timeline, then enter your dates and events…
- Excel Pivot Table Course: What to Learn and How to ChooseAn Excel pivot table course teaches you to summarize, compare, and explore spreadsheet data without writing formulas for every report. Choose a…
- Excel Pivot Table: How to Collapse All Rows at OnceTo collapse all items in an Excel PivotTable row field at once, right-click any item in that field and choose Expand/Collapse >…
- Excel Pivot Table Blank as Empty? How to Display BlanksIn Excel for Microsoft 365 on Windows, a PivotTable can show empty value cells as blank: right-click inside it, choose PivotTable Options,…
- Excel Pivot Slicers: What They Do and How to Use ThemIn Excel, a PivotTable slicer is a set of clickable buttons that filters a PivotTable, and often its associated PivotChart, by a…
- Excel Pivot Table Remove Duplicates: What WorksA PivotTable does not delete duplicate rows from its source data: it groups matching field values into one displayed item and summarizes…
- Excel Pivot Group Rows: Dates, Numbers, and CategoriesTo group rows in an Excel PivotTable, right-click a row label or value and choose Group; for dates or numbers, set the…
- Excel One Slicer for Multiple Pivot Tables: How to ConnectYes. In Excel for Microsoft 365 on Windows, one slicer can filter multiple PivotTables when they share a compatible data source—normally the…