Charts & pivot tables
Build, format and fix charts and pivot tables.
- Add a Pie Chart in Excel: Labels, Slices, and TipsTo add a pie chart in Excel for Microsoft 365 on Windows, arrange category names in one column and their values in…
- Add a Filter to an Excel Line Chart: How It Really WorksTo add a filter to an Excel line chart in Microsoft 365 for Windows, select the chart, click the funnel-shaped Chart Filters…
- Gantt Chart in Excel: How to Add One and Format ItTo add a Gantt chart in Excel for Microsoft 365 on Windows, arrange each task with a start date and duration, select…
- Add a Goal Line to an Excel Chart: Steps That WorkTo add a goal line to an Excel chart, add a second data series containing the goal value for every category, then…
- Add a Data Table to an Excel Chart: Steps and TipsTo add a data table beneath a chart in Excel for Microsoft 365 on Windows, select the chart, then choose Chart Design…
- Add a Bar Chart in Excel: Steps and TipsTo add a bar chart in Excel for Microsoft 365 on Windows, select the category labels and numeric values, then choose Insert…
- 24-Hour Gantt Chart Excel: 24 Setup Ideas That WorkTo make a 24-hour Gantt chart in Excel, put 24 hourly time values across the columns, list tasks with start and end…
- Pivot Table Value Filter Not Working? Fix the CauseA PivotTable value filter usually seems broken because it is filtering a different summary than you expect, the source values are not…
- Pivot Table Sort by Value Not Working? Fixes in ExcelTo sort an Excel PivotTable by its numbers, click a value in the column you want to rank, then right-click and choose…
- Pivot Table Value Filter Not Working? Fix It in ExcelIf a PivotTable value filter is not working, first confirm that you applied it to a field in the Rows or Columns…
- Pivot Table Average Not Working? Fix the Source DataIf a PivotTable average is missing, showing Count, or giving an unexpected result, check the value field’s summary setting first: right-click a…
- Pivot Table Max Not Working? Causes, Checks, and FixesIf Max is not working in an Excel PivotTable, open the value field’s settings and choose Summarize Values By > Max; then…
- Excel Pivot Table Filter Not Working? Fixes That HelpIf a filter in an Excel PivotTable is not working, first clear the filter, refresh the PivotTable, and confirm that the source…
- Excel Pivot Table Value Filter Not Working? FixesIf an Excel PivotTable value filter is not working, first confirm you applied it to a row or column field and selected…
- Excel Map Chart Not Working? Fix the Common CausesIf an Excel map chart is blank, missing, or showing the wrong places, first check that your chart has recognizable geographic names…
- Excel Half-Moon Chart: Add Red, Yellow, and Green ZonesTo create a red, yellow, and green half-moon chart in Excel, make a doughnut chart from three equal zone values plus a…
- Custom Column Chart in Excel: How to Build and FormatTo make a custom column chart in Excel for Microsoft 365 on Windows, select your category labels and values, choose Insert >…
- Half Circle Graph in Excel: How to Make OneTo make a half-circle graph in Excel, create a doughnut chart with three values: the amount reached, the amount remaining, and a…
- Half-Circle Charts in Excel: Create a Semi-DoughnutExcel does not have a dedicated half-circle chart button, but you can make one with a doughnut chart: add a final data…
- Black Bullseye Chart in Excel: How to Create OneA black bullseye chart is usually a custom target graphic made from concentric circles; it is not a named, built-in Excel chart…
- Traffic Light Chart in Excel: Build a Status DashboardA traffic light chart in Excel is a visual status indicator that uses green, yellow, and red symbols to show whether values…
- Spider Web Chart in Excel: How to Create and Read ItA spider web chart—usually called a radar chart in Microsoft Excel—plots several categories around a circle so you can compare the shape…
- Step Progress Chart in Excel: Build a Clear TrackerA step progress chart is a visual way to show how far a project, process, or checklist has advanced through defined steps.…
- How to Make a Half-Round Chart in ExcelIn Excel for Microsoft 365, make a half-round chart by inserting a doughnut chart from your values plus a final spacer value…
- Excel to PowerPoint Org Chart: Build and Update ItTo make an Excel org chart in PowerPoint, organize the people and reporting relationships in Excel, then create a hierarchy SmartArt graphic…
- Cash Flow Chart in Excel: Build and Read OneTo make a cash flow chart in Excel, put periods and cash figures in a table, calculate net cash flow and closing…
- Blank Bullseye Chart: Make a Target Template in ExcelA blank bullseye chart is an unlabeled target diagram made of concentric circles, ready for you to add scores, priorities, goals, or…
- Excel to PowerPoint Gantt Chart: Create and Share ItTo put an Excel Gantt chart in PowerPoint, build it in Excel as a stacked bar chart, select the chart, and copy…
- Excel Gantt Chart With Dependencies: How to Build OneYes. In Excel for Microsoft 365 on Windows, you can build a Gantt chart whose task dates update when predecessor tasks change:…
- Excel Gantt Chart Start and End Dates ExplainedIn an Excel Gantt chart, each task’s start date sets the bar’s position on the timeline, and its end date determines when…