Charts & pivot tables
Build, format and fix charts and pivot tables.
- Compare Two Excel Sheets With a Pivot TableTo compare two Excel sheets with a PivotTable, combine their rows into one table, add a column identifying which sheet each row…
- Combo Pivot Chart in Excel: What Works and HowA combo PivotChart cannot be created directly in Excel for Microsoft 365: PivotCharts do not support combining chart types, such as columns…
- Combo Chart in Excel 2010: How to Create OneYes. In Excel 2010, create a chart, select the data series you want to display differently, right-click it, and choose Change Series…
- Combo Chart in Excel: How to Create and Format OneA combo chart in Excel combines two or more chart types in one chart, most often columns and a line. In Microsoft…
- Combo Chart in Excel: How to Create, Format, and Read OneA combo chart in Excel combines two or more chart types, commonly columns for one measure and a line for another. In…
- Combo Chart in Excel: How to Create and Use OneTo make a combo chart in Excel for Microsoft 365 on Windows, select your data, choose Insert > Insert Combo Chart, and…
- Combo Chart Icon in Excel: Where to Find and Use ItIn Excel for Microsoft 365 on Windows, find the combo chart icon on the Insert tab, in the Charts group, under Insert…
- Excel Combo and Stacked Charts: How to Combine ThemYes. In Excel for Microsoft 365 on Windows, you can combine stacked columns with another chart type, such as a line, by…
- Combo Bar Chart in Excel: Create, Format, and Fix ItTo make a combo chart in Excel, select your data, choose Insert > Recommended Charts > All Charts > Combo, then assign…
- How to Build Clustered and Stacked Combo Charts in ExcelYes. In Excel for Microsoft 365 on Windows, use Insert > Insert Combo Chart > Create Custom Combo Chart to assign stacked…
- Clustered Column Line Combo Chart in Excel: How-ToTo make a clustered column and line combo chart in Excel for Microsoft 365 on Windows, select your category labels and data…
- Excel Pivot Table Chart Maker: Create PivotChartsTo make a chart from an Excel PivotTable in Microsoft 365 for Windows, click inside the PivotTable and choose PivotTable Analyze >…
- How to Change Legend Names in an Excel PivotChartTo change a legend name in an Excel PivotChart, rename the field caption or item that supplies the legend entry in the…
- Excel Combo Chart Bar Width: How to Change Gap WidthTo change bar width in an Excel combo chart, select a column series, open Format Data Series, and adjust Series Options >…
- Pivot Table Charts in Excel: Create, Format, and UseYes. In Microsoft Excel for Microsoft 365 on Windows, click inside a PivotTable, choose PivotTable Analyze > PivotChart, select a chart type,…
- Change Bin Size in an Excel HistogramTo change a histogram’s bin size in Excel for Microsoft 365 on Windows, select the chart’s horizontal axis, open Format Axis, and…
- Combo Chart in Excel: How to Create and Format OneTo make a combo chart in Excel for Microsoft 365 on Windows, select your data, choose Insert > Insert Combo Chart >…
- Pivot Charts in Excel: Create, Customize, and RefreshTo make a PivotChart in Excel for Microsoft 365 on Windows, select a cell in a clean data table, choose Insert >…
- Duplicate Pivot Charts and Tables in ExcelTo duplicate a PivotTable in Excel for Microsoft 365 on Windows, select the whole table with PivotTable Analyze > Select > Entire…
- Can’t See Power Pivot in Excel? Fix the Missing TabIf you can’t see Power Pivot in Excel for Microsoft 365 on Windows, first enable its COM add-in: go to File >…
- Can You Rotate a Pie Chart in Excel? Steps and TipsYes. In Excel for Microsoft 365 on Windows, select the pie chart, right-click a slice, choose Format Data Series, then open Series…
- Combo Waterfall Charts in Excel: How to Build OneYes, you can make a chart that combines a waterfall-style breakdown with another measure, such as a target line, in Excel for…
- Can You Make a Stacked Waterfall Chart in Excel?Yes—but Excel does not provide a native chart type that combines stacked components with waterfall steps. In Microsoft Excel for Microsoft 365…
- Create a Pie Chart in Excel: Steps and TipsYes. In Excel for Microsoft 365 on Windows, select your category names and values, then choose Insert > Insert Pie or Doughnut…
- Can Excel Make a Gantt Chart? A Practical GuideYes. Excel can create a Gantt chart, usually by turning a stacked bar chart into a timeline or by using conditional formatting…
- Box Plot in Excel: Create, Format, and Read the ChartYes. In Excel for Microsoft 365 on Windows, select your numeric data, then choose Insert > Insert Statistic Chart > Box and…
- Building a Pivot Chart in Excel: A Practical GuideTo build a PivotChart in Excel for Microsoft 365 on Windows, create or select a PivotTable, choose PivotTable Analyze > PivotChart, pick…
- Build an Excel Dashboard: Steps, Design, and ExamplesYes. To build an Excel dashboard, organize your source data as a clean table, summarize it with PivotTables or formulas, add charts…
- Build a Gantt Chart in Excel: Step-by-Step GuideTo build a Gantt chart in Excel for Microsoft 365 on Windows, list each task with a start date and duration, create…
- Excel Pie Chart: How to Break Its Link in Microsoft WordTo break a linked Excel pie chart in Word for Microsoft 365 on Windows, open the document and choose File > Info…