Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Pivot Table Refresh Failed? Fix the Common CausesIf an Excel PivotTable refresh failed, first confirm that its source data is available and has a valid, complete header row, then…
- Data Mapping in Excel for Org Charts: A Practical GuideTo map employee data in Excel for an org chart, make a table with one row per person and separate columns for…
- Excel Sunburst Chart Data Layout: A Practical GuideFor an Excel sunburst chart, put each level of the hierarchy in its own column, from the broadest group to the most…
- Creating a Sunburst Chart in Excel: Step-by-StepTo create a Sunburst chart in Excel for Microsoft 365 on Windows, arrange your data in columns from the broadest category to…
- Creating a Stacked Bar Chart in Excel: Steps & TipsTo create a stacked bar chart in Excel for Microsoft 365 on Windows, arrange each category in a row and each data…
- Creating an Org Chart in Excel: Steps and Options ExplainedTo create an org chart in Excel for Microsoft 365 on Windows, choose Insert > SmartArt > Hierarchy > Organization Chart, then…
- How to Create an Org Chart in Excel: Steps and TipsTo create an org chart in Excel for Microsoft 365 on Windows, select Insert > SmartArt > Hierarchy > Organization Chart, then…
- Speedometer Chart in Excel: A Practical Step-by-Step GuideTo create a speedometer chart in Excel for Microsoft 365 on Windows, make a doughnut chart from three threshold bands and a…
- Create a Thermometer Chart in Excel: Steps and TipsTo create a thermometer chart in Excel for Microsoft 365 on Windows, enter a completed amount and a goal, calculate the completed…
- Thermometer Goal Chart in Excel: Create One Step by StepTo create a thermometer goal chart in Excel for Microsoft 365 on Windows, put the current amount and the amount remaining in…
- Funnel Chart in Excel: Create, Format, and Fix OneTo create a funnel chart in Microsoft Excel for Microsoft 365 on Windows, put your process stages in one column and their…
- Creating a Radar Chart in Excel: A Clear Step-by-Step GuideTo create a radar chart in Excel for Microsoft 365 on Windows, arrange category labels in the first column and one or…
- Create a Pie Chart in Excel from One Column of DataTo create a pie chart from one column in Excel for Microsoft 365 on Windows, select the numeric cells, then choose Insert…
- Create an Org Chart in Excel From a ListYes. Put each person in a list with their manager, then use Insert > SmartArt > Hierarchy > Organization Chart to build…
- Create an Org Chart From Excel Data in ExcelYes. In Microsoft Excel for Microsoft 365 on Windows, you can create an org chart with Insert > SmartArt > Hierarchy >…
- Create an Org Chart in Excel from Your Employee DataYes. In Excel for Microsoft 365 on Windows, choose Insert > SmartArt > Hierarchy > Organization Chart, then enter or paste names…
- Excel Org Chart: Create One from a Manager Data RangeTo create an org chart from an Excel data range, first arrange the data so each person has a name and a…
- Create a Pareto Chart in Excel: Steps, Tips, and ExamplesTo create a Pareto chart in Excel for Microsoft 365 on Windows, select a table containing category names and counts, then choose…
- How to Create a Doughnut Chart in ExcelTo create a doughnut chart in Excel for Microsoft 365 on Windows, arrange category names in one column and their values in…
- Create a Bullet Chart in Excel: Step-by-Step GuideTo create a bullet chart in Excel for Microsoft 365 on Windows, make a stacked bar chart for the performance ranges, place…
- Create a Comparison Chart in Excel: A Step-by-Step GuideTo create a comparison chart in Excel for Microsoft 365 on Windows, arrange the items you want to compare in one column…
- Convert an Excel List to an Org Chart in Microsoft 365To convert an Excel list to an org chart, arrange the people in a reporting hierarchy, then use Insert > SmartArt >…
- Excel Chart Bars: Conditional Formatting MethodsExcel does not apply worksheet conditional formatting directly to chart bars. To color bars according to a rule, split the values into…
- Conditional Formatting Bar Chart in Excel: How It WorksTo make a bar chart inside Excel cells, select the values, then choose Home > Conditional Formatting > Data Bars and pick…
- Column Chart Maker in Excel: Create a ChartExcel has a built-in column chart maker: arrange categories in one column and their values in another, select the data, then choose…
- Excel Column and Line Charts: How to Create ThemIn Excel for Microsoft 365 on Windows, select your data and choose Insert > Recommended Charts > All Charts > Combo, then…
- Column Chart Example in Excel: Create and Format OneTo make a column chart in Excel, place category names in the first column and the values for each series in adjacent…
- Column Chart in Excel: Definition, Uses, and ExamplesA column chart in Excel is a chart that uses vertical bars to compare values across categories or show how values change…
- Clustered Stacked Bar Chart in Excel: How to Build OneExcel does not include a chart type that directly combines clustered and stacked bars. You can make a clear visual workaround by…
- Clustered Column Pivot Chart in Excel: Create and Fix ItTo make a clustered column PivotChart in Excel for Microsoft 365 on Windows, click inside a PivotTable, choose PivotTable Analyze > PivotChart,…