Charts & pivot tables
Build, format and fix charts and pivot tables.
- Funnel Chart with Multiple Measures in Excel?Excel’s built-in funnel chart is designed to show one measure across a sequence of stages, so it does not create a standard,…
- Funnel Chart Creator in Excel: How to Build One EasilyExcel for Microsoft 365 includes a built-in funnel chart creator: put stage names in one column and their values in the next,…
- Free Excel Gantt Chart Timeline TemplatesYes. You can get a free Gantt chart timeline template by searching Excel’s template gallery or Microsoft Create, or build a simple…
- Free Excel Tree Chart Template: Options and SetupYes. You can make a tree chart in Microsoft Excel for Microsoft 365 without paying for a separate template: use Insert >…
- Free Pareto Chart Template in Excel: Build Your OwnYes. You can make a reusable Pareto chart template in Excel for Microsoft 365 by listing categories and counts, calculating a cumulative…
- Free Comparison Chart Template for Excel: How to Build OneYes. You can make a free comparison chart template in Microsoft Excel by listing the options in rows, the criteria in columns,…
- Excel Gantt Chart Formula: Build a Timeline Step by StepFor task names in column A, start dates in B, finish dates in C, and timeline dates across row 1 starting in…
- Excel Gantt Chart Bar Formula: Setup and Date TipsFor a date-grid Gantt chart in Excel, use the conditional-formatting formula =AND(H$1>=$B2,H$1<=$C2). With task start dates in column B, finish dates in…
- Format Chart Area in Excel: A Practical GuideTo format a chart area in Excel for Microsoft 365 on Windows, select the chart, right-click its outer background, and choose Format…
- Feature Comparison Chart Template in Excel: Build OneA feature comparison chart template in Excel is a worksheet that lists options side by side against the same features, so you…
- Excel Chart Not Showing? Causes and FixesIf an Excel chart is missing or blank, first check that Excel is set to show objects: in Microsoft 365 for Windows,…
- Exploded Doughnut Chart in Excel: How to Make OneTo make an exploded doughnut chart in Excel for Microsoft 365 on Windows, select your category-and-value data, choose Insert > Insert Pie…
- Excel X-Y Chart: How to Create and Read OneIn Excel, an x-y chart is usually an XY (scatter) chart: select paired numeric x and y values, then choose Insert >…
- Excel X-Axis Text Instead of Numbers: How to Fix ItTo show text instead of numeric values along an Excel chart’s horizontal axis, use a category chart such as a line or…
- Excel Vertical Stacked Bar Chart: Create and FormatTo make a vertical stacked bar chart in Excel for Microsoft 365 on Windows, arrange categories in the first column and each…
- Excel Pivot Table Data in Formulas: How to Use ItYes. In Excel for Microsoft 365, use GETPIVOTDATA to retrieve a value from a PivotTable by its field names and items, or…
- Excel Area Charts: How to Shade Selected SectionsYes. In Excel for Microsoft 365 on Windows, you can shade selected sections of an area chart by adding a helper data…
- Excel Unable to Insert Chart? Causes, Checks, and FixesIf Excel is unable to insert a chart, first press Esc to leave cell-edit mode, select a cell on an unprotected worksheet,…
- Excel Treemap Chart from a Pivot Table: What WorksYou can make a treemap from PivotTable results in Excel, but Excel does not offer Treemap as a PivotChart type. The reliable…
- Excel to Visio Org Chart: Import, Map, and TroubleshootYes. In Visio for Windows, choose File > New > Organization Chart > Create, select employee information stored in an Excel file,…
- Excel to Org Chart: Free Options and How to Build OneYes—if you already have access to desktop Excel, you can make an org chart at no extra charge using SmartArt. Excel itself…
- Excel to PowerPoint Org Chart: A Practical WorkflowYes—use your Excel employee and manager data as the source, then build the hierarchy in PowerPoint with SmartArt. Excel does not provide…
- Excel Pareto Chart Template: Build One Step by StepYes. In Excel for Microsoft 365 on Windows, a reusable Pareto chart template can be made from a category-and-count table, a cumulative-percentage…
- Excel Sunburst Pie Chart? What It Is and How to Make OneExcel does not have a chart type named Sunburst Pie: it has a Sunburst chart, which resembles a pie but displays several…
- Excel Sunburst Chart: How to Change Slice OrderTo change the order of slices in an Excel sunburst chart, reorder the chart’s source rows: in Excel for Microsoft 365 on…
- Excel Stacked Horizontal Bar Chart: Setup and TipsTo make a stacked horizontal bar chart in Excel for Microsoft 365 on Windows, arrange each category in a row and each…
- Excel Stacked Funnel Chart: How to Build OneExcel does not offer a built-in stacked funnel chart: its native Funnel chart displays one value series, not several colored components. To…
- Excel Stacked Column Chart: Show Totals ClearlyYes. Excel’s stacked column chart does not automatically show a label for each column’s total; its standard data labels show the individual…
- Excel Stacked Column Chart With Two Data Sets ExplainedYes. In Excel for Microsoft 365 on Windows, place the two data sets in adjacent columns beside the same category labels, select…
- Excel Stacked Column Chart: Set and Fix the X-AxisIn an Excel stacked column chart, the x-axis is the horizontal category axis along the bottom: it shows the categories being compared,…