Charts & pivot tables
Build, format and fix charts and pivot tables.
- Clustered Stack Column Chart in Excel: How to Make OneExcel does not offer a chart type named Clustered Stacked Column, but you can create the same visual by arranging each category-and-group…
- Cluster Column Chart in Excel: Create and Format ItTo make a clustered column chart in Excel for Microsoft 365 on Windows, arrange categories in the first column and each data…
- Clustered Column Line Chart in Excel: How to Make OneIn Excel, a clustered column line chart is a combo chart: it displays one or more data series as side-by-side columns and…
- Circular Radar Chart in Excel: Create and Format ItTo make a circular radar chart in Excel for Microsoft 365 on Windows, arrange your categories in one column and each data…
- Chart Area in Excel: Definition and How It WorksIn Excel, the chart area is the entire region occupied by a chart, including the plot area and other chart elements such…
- Excel Chart Linking Errors: Are All Links Really OK?No: an Excel workbook can report that its external links are fine while a chart still points to the wrong cells, an…
- Chart Not Showing in Excel? Causes, Checks, and FixesIf a chart is missing or blank in Excel for Microsoft 365 on Windows, first check whether Excel is hiding objects: go…
- Chart Area and Plot Area in Excel: What’s the Difference?In Excel, the chart area is the entire chart object, while the plot area is the region inside it where the data…
- How to Change Bubble Size in an Excel Bubble ChartTo change bubble sizes in an Excel bubble chart, right-click a bubble, choose Format Data Series, open Series Options, and adjust Scale…
- Radar Chart in Excel: How to Create and Format OneTo make a radar chart in Excel for Microsoft 365 on Windows, arrange categories in the first column and data series in…
- Link Excel to Word: Keep Tables and Charts UpdatedTo link Excel data to Word, copy the cells or chart in Excel, then in Word for Microsoft 365 on Windows choose…
- Doughnut Chart in Excel: Create, Format, and Read ItTo make a doughnut chart in Excel for Microsoft 365 on Windows, select your category labels and values, then choose Insert >…
- Pareto Chart in Excel: How to Create and Interpret ItTo make a Pareto chart in Microsoft Excel for Microsoft 365 on Windows, arrange categories and their counts in two columns, select…
- Create an Org Chart From Excel Data in Microsoft ExcelYes—you can create an org chart from Excel data by organizing employee names and reporting levels, then inserting a hierarchy SmartArt graphic…
- Org Chart in Excel: How to Create, Format, and UpdateYes. In Microsoft Excel for Microsoft 365 on Windows, choose Insert > SmartArt > Hierarchy > Organization Chart, then enter employees and…
- Can You Create a Bubble Chart in Excel? Steps and TipsYes. In Excel for Microsoft 365 on Windows, arrange your data in columns for X values, Y values, and bubble size, select…
- Pareto Chart in Excel: How to Create and Interpret ItYes. In Excel for Microsoft 365 on Windows, select a column of raw category records, then choose Insert > Insert Statistic Chart…
- Can You Cluster a Stacked Bar Chart in Excel?Yes, but Excel does not offer a built-in chart type that both clusters and stacks bars. In Microsoft 365 for Windows, the…
- Can You Build an Org Chart in Excel? Steps & OptionsYes, you can build an organizational chart in Excel using SmartArt or by arranging shapes and connector lines. For a quick chart,…
- Calendar Gantt Chart Excel Template: Build a Useful PlanA calendar Gantt chart Excel template places tasks on rows and real dates across columns, then uses conditional formatting to shade the…
- Build a Pareto Chart in Excel: Steps and TipsTo build a Pareto chart in Excel, summarize your categories and counts, sort the counts from largest to smallest, calculate a running…
- Build an Org Chart in Excel: Steps, Layout, and Design TipsTo build an org chart in Excel for Microsoft 365 on Windows, select Insert > SmartArt > Hierarchy > Organization Chart, then…
- Build an Org Chart From Excel Data: Steps and OptionsYes. You can build an org chart in Excel by choosing Insert > SmartArt > Hierarchy > Organization Chart, then entering employee…
- Build an Org Chart from Excel Data in Microsoft 365To build an org chart from Excel data, first organize each employee on one row with a unique ID and a manager…
- Bubble Chart in Excel: Create, Format, and TroubleshootTo make a bubble chart in Excel for Microsoft 365 on Windows, arrange your data in three numeric columns for X values,…
- Bubble Chart in Excel: Make Each Bubble a Different SizeYes. To make bubbles different sizes in an Excel bubble chart, give each data point its own size value: arrange the data…
- Bubble Chart in Excel: Plot Three Variables ClearlyYes. An Excel bubble chart displays three numeric variables at once: one on the horizontal axis, one on the vertical axis, and…
- Bubble Chart Excel Tutorial: Create, Format, and Read OneTo create a bubble chart in Excel for Microsoft 365 on Windows, arrange each observation in a row with an X value,…
- Bubble Chart in Excel With Four Quadrants: How to Make OneYes. In Excel, make a bubble chart from three data fields—an X value, a Y value, and a bubble-size value—then set the…
- Bubble Chart in Excel: How to Create and Read OneTo create a bubble chart in Excel for Microsoft 365 on Windows, arrange your data in three columns—X values, Y values, and…