Charts & pivot tables
Build, format and fix charts and pivot tables.
- Pivot Table Error Messages: Causes and FixesA PivotTable error message in Excel is not one single error: the wording points to the cause, such as a blank source-column…
- Pareto Chart in Excel: Cumulative Percentage GuideYes. In Excel, a Pareto chart displays categories from largest to smallest and plots their running total as a cumulative-percentage line; for…
- Pareto Chart Not Working in Excel? Fix Data and Chart IssuesIf a Pareto chart is not working in Excel, first check whether the chart is getting the kind of data it expects:…
- Pareto Chart in Excel: How to Create and Read the ResultsIn Excel for Microsoft 365 on Windows, select your category labels and counts, then choose Insert > Insert Statistic Chart > Pareto.…
- Pareto Chart in Excel: Use Word Labels and CountsYes—an Excel Pareto chart can use words such as “Late delivery” or “Damaged item” as category labels, with a numeric count for…
- Pareto Chart in Excel: Create and Format a Clear AnalysisIn Microsoft Excel for Microsoft 365 on Windows, select raw category observations and choose Insert > Insert Statistic Chart > Pareto to…
- Pareto Chart Formula in Excel: Build It Step by StepWith categories in A2:A6 and their counts in B2:B6, enter =SUM($B$2:B2) in C2 for the running total and =C2/SUM($B$2:$B$6) in D2 for…
- Pareto Chart in Excel: How to Create and Interpret ItTo make a Pareto chart in Excel for Microsoft 365 on Windows, put one category per row in a single column, select…
- Pareto Chart in Excel: A Step-by-Step Tutorial and TipsTo make a Pareto chart in Excel for Microsoft 365 on Windows, first put each issue or category beside its count, sort…
- Pareto Chart Data in Excel: Examples, Setup, and TipsA Pareto chart in Excel uses categories and their counts or costs, sorted from largest to smallest, to show which causes contribute…
- Pareto Chart in Excel: How to Apply the 80/20 RuleTo make a Pareto chart in Microsoft Excel for Microsoft 365 on Windows, select a category-and-count table, then choose Insert > Insert…
- Overlapping Area Chart in Excel: How to Create OneTo create an overlapping area chart in Excel for Microsoft 365 on Windows, select your category labels and data series, then choose…
- Overlapping Stacked Bar Chart in Excel: How to Make OneYes—but Excel does not have a dedicated chart type called an overlapping stacked bar chart. In Microsoft Excel for Microsoft 365 on…
- Packed Bubble Chart in Excel: Options and AlternativesExcel for Microsoft 365 does not include a native packed bubble chart. You can make a standard bubble chart from three numeric…
- Org Chart in Excel: Templates, Setup, and Best PracticesYes—Excel includes a built-in way to make an org chart: choose Insert > SmartArt > Hierarchy > Organization Chart, then enter names…
- Org Chart Template Excel Free: Find and Use the Right OneYes. You can get a free org chart template for Excel from Microsoft’s template resources or create a chart in Excel with…
- Org Chart Program in Excel: Create and Maintain OneYes. Microsoft Excel for Microsoft 365 can create an organizational chart using SmartArt: choose Insert > SmartArt > Hierarchy > Organization Chart,…
- Org Chart Format in Excel: Build and Choose a LayoutIn Excel for Microsoft 365 on Windows, the quickest org chart format is SmartArt: choose Insert > SmartArt > Hierarchy, select Organization…
- Visio Org Chart from Excel Data: Steps and LimitsYes. In the Windows desktop version of Visio, the Organization Chart Wizard can turn an Excel employee list into an org chart…
- Org Chart in Excel or Word? Choosing the Right ToolFor a straightforward org chart that is mainly a document, use Word; for a chart that sits alongside staffing data or needs…
- Org Chart in Excel: Build, Format, and Maintain OneYes. In Microsoft Excel for Microsoft 365 on Windows, the quickest way to build an org chart is Insert > SmartArt >…
- Org Chart Creator in Excel: Steps, Limits, and OptionsExcel can create an org chart with its built-in SmartArt feature: choose Insert > SmartArt > Hierarchy, select an organization chart layout,…
- Nested Doughnut Chart in Excel: How to Build OneTo make a nested doughnut chart in Excel for Microsoft 365 on Windows, arrange each ring as a separate data series, select…
- Multiple Doughnut Charts in Excel: How to Make ThemTo make a multiple-ring doughnut chart in Excel, arrange each data series in its own column (or row), select the category labels…
- Multiple Stacked Bar Chart in Excel: How to Build OneYes. In Excel, you can make a chart with multiple stacked bars by arranging each bar as a separate category row, then…
- Multi-Year Gantt Chart Template in Excel: Build a PlanYes. You can build a multi-year Gantt chart template in Excel by listing tasks and their start and finish dates, then using…
- Microsoft Excel Org Chart Add-Ins and Built-In OptionsMicrosoft Excel for Microsoft 365 does not require an add-in to make a basic org chart: use the built-in SmartArt Organization Chart.…
- Microsoft Excel Org Chart Template: Create and CustomizeTo get a Microsoft Excel org chart template, open File > New and search for organization chart; available templates can vary. To…
- Microsoft Excel Gantt Chart Template: Build and Customize ItTo get a Microsoft Excel Gantt chart template, open Excel for Microsoft 365 on Windows, choose File > New, and search for…
- Microsoft Excel Bubble Chart Template: Build and CustomizeMicrosoft Excel does not provide one universal bubble-chart template, but you can build a reusable chart in minutes: arrange each item’s X…