Charts & pivot tables
Build, format and fix charts and pivot tables.
- 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…
- Excel Pivot Table: How to Exclude Blank Rows and ItemsTo exclude blanks from an Excel PivotTable in Microsoft 365 for Windows, open the dropdown for the row, column, or report-filter field…
- Excel Pivot Table Calculated Field: How to Edit ItTo edit a calculated field in an Excel PivotTable, select the PivotTable, then choose PivotTable Analyze > Fields, Items, & Sets >…
- Excel Pivot Table Date Grouping: Months, Years & FixesTo group dates in an Excel PivotTable, put the date field in Rows or Columns, right-click any date in the PivotTable, choose…
- Excel Pivot Table: Group Dates by Month and Year in ExcelTo group an Excel PivotTable date column by month, place the date field in the Rows or Columns area, right-click any date…
- Excel Pivot Table Dashboard: How to Build OneAn Excel pivot table dashboard is a summary view built from one or more PivotTables, charts, and interactive filters. To make one…
- Excel Pivot Table Collapse All: Steps, Limits, and TipsTo collapse the detail in an Excel PivotTable, right-click an item in the row or column field you want to hide, then…
- Excel Pivot Table: Clear Old Items and Cached ValuesTo clear old values from an Excel PivotTable, open PivotTable Options, choose the Data tab, set Number of items to retain per…
- Excel Pivot Table by Month: Group Dates the Right WayTo make an Excel PivotTable by month, put a genuine date field in the Rows area, put the measure you want to…
- Excel Pivot Table by Week: Group Dates or Add a Week FieldYes. In Excel for Microsoft 365 on Windows, put a real date field in a PivotTable’s Rows area, right-click a date, choose…
- Excel Pivot Table Blank? Causes, Checks, and Fixes That WorkIf an Excel PivotTable is blank, first check its filters and source data, then refresh it and confirm that a field is…
- Excel Pivot Tables: Analyze Data with Examples and InsightsYes—an Excel PivotTable analyzes a list by summarizing its values and letting you rearrange, filter, group, and compare them without changing the…
- Excel Pivot Table Add to Data Model: A Practical GuideTo add data to the Excel Data Model, select a cell in your source range, choose Insert > PivotTable, and select Add…
- Excel School Dashboard: What It Shows and How to BuildAn Excel school dashboard is a visual summary of school data—such as attendance, grades, enrollment, or staffing—organized so that administrators and teachers…
- Excel Pivot Table Grand Total Column: Add or Fix ItTo add a grand total column in an Excel PivotTable, click anywhere inside it and choose PivotTable Design > Grand Totals >…
- Excel Dashboard Sample: A Practical Sales TemplateAn Excel dashboard sample is a one-page summary that turns a structured data table into a quick view of performance. A practical…
- Excel Graph Two Y-Axes: How to Add a Secondary AxisYes. In Excel for Microsoft 365 on Windows, select the chart, then go to Chart Design > Change Chart Type > Combo,…
- Excel Graph Y-Axis Not Starting at Zero? How to Fix ItTo make an Excel graph’s vertical axis start at zero, right-click the value axis, choose Format Axis, and under Axis Options >…
- Interactive Excel Dashboard: How to Build OneYes. An interactive Excel dashboard is a worksheet that lets people explore key figures by changing filters or selections, rather than viewing…
- Excel Graph Secondary Axis: How to Add and Use OneTo add a secondary axis to an Excel graph, select the chart, choose Chart Design > Change Chart Type, select Combo, and…
- Excel Graph: How to Switch the X and Y Axes in a ChartTo switch the X and Y values in an Excel chart, use an XY (Scatter) chart, then go to Chart Design >…
- Excel Graph Paper: Create a Grid in a WorksheetYes. You can make graph paper in Excel by setting worksheet columns and rows to small, consistent sizes, then printing the gridlines…
- Excel Graph Not Updating? Fix Charts That Won’t RefreshIf an Excel graph is not updating when its data changes, first check that the chart points to the cells you edited…
- Excel Pivot Table: Add a Calculated Column or FieldYes—but the right method depends on what you mean by a calculated column. In Excel for Microsoft 365 on Windows, add a…
- Excel Pivot Table Average: Add a Column and Set It UpTo add an average column to an Excel PivotTable, drag the numeric field into the Values area a second time, then right-click…
- Excel Dashboard Inspo: Ideas, Layouts, and Design TipsFor Excel dashboard inspo, start with one clear question your dashboard should answer, then build a compact view around a few useful…
- Excel Dashboard GitHub: Find and Use Templates SafelyTo find an Excel dashboard on GitHub, search GitHub for terms such as “Excel dashboard xlsx” or “Excel dashboard template,” then review…
- Excel Dashboard Images: Add, Format, and Keep Them ClearTo add an image to an Excel dashboard in Microsoft 365 for Windows, select Insert > Pictures > This Device, choose a…
- Excel Graph Not Showing 0 Values? Fix the ChartExcel normally plots a numeric zero as a value, but it may be hard to see: it can sit on the horizontal…
- Excel Graph: How to Move the X-Axis to the BottomTo move an Excel chart’s x-axis to the bottom, select the vertical (y) axis, open Format Axis, and under Axis Options change…