Charts & pivot tables
Build, format and fix charts and pivot tables.
- Pie Chart in Excel: How to Create, Format, and Label ItTo create a pie chart in Excel for Microsoft 365 on Windows, select a column of category names and the matching values,…
- Pie Chart Creator Online in Excel: How to Make OneYes. In Excel for the web, select a table containing category names and values, then use the Insert tab to add a…
- Pie Chart Angle Formula: How to Calculate Each SliceThe pie chart angle formula is slice angle = (category value ÷ total of all values) × 360°. Divide a category’s value…
- Pie Chart Creation in Excel: A Practical Step-by-Step GuideTo create a pie chart in Excel for Microsoft 365 on Windows, place category names in one column and their values in…
- Pie Chart Creator in Excel: Make and Format a ChartExcel has a built-in pie chart creator: select a category-and-value table, then choose Insert > Insert Pie or Doughnut Chart > 2-D…
- Other Levels Excel Dashboard: A Guide to Multi-Level ViewsYes—Excel can show a dashboard at different levels of detail, from a high-level summary to team, product, or transaction views. “Other levels”…
- Open Excel Power Pivot: Enable and Use the Add-InTo open Power Pivot in Excel for Microsoft 365 on Windows, enable its add-in: select File > Options > Add-ins, choose COM…
- Online Pivot Table Chart: How to Create, Read, and UseAn online pivot table chart is a visual summary built from data organized in a pivot table. In Excel for the web,…
- OEE Waterfall Chart in Excel: Build and Interpret ResultsTo make an OEE waterfall chart in Excel, put the starting 100% and each staged loss in a two-column table, insert a…
- Multi-Series Pivot Chart in Excel: Setup and TipsA multi-series PivotChart displays two or more related data series in one chart, usually by placing a category field such as Region…
- Nested Pie Chart in Excel: Create and Format a SunburstTo make a nested pie chart in Excel for Microsoft 365 on Windows, arrange your categories in separate hierarchy columns and put…
- New Excel Charts for Dashboards: What to UseYes. Excel for Microsoft 365 includes several chart types that can make dashboards more informative, including waterfall, funnel, histogram, Pareto, box-and-whisker, treemap,…
- Excel Waterfall Charts: How to Create and Format ThemIn Microsoft Excel for Microsoft 365, select a table of categories and values, then choose Insert > Insert Waterfall, Funnel, Stock, Surface…
- Move a Pivot Chart to Another Sheet in ExcelIn Excel for Microsoft 365 on Windows, select the PivotChart, choose Chart Design > Move Chart, select Object in, choose the destination…
- Microsoft Power Pivot: What It Is and How It WorksMicrosoft Power Pivot is an Excel feature for building data models from multiple tables and analyzing them with PivotTables, relationships and DAX…
- Microsoft Excel Waterfall Chart: Create and Format OneTo create a waterfall chart in Microsoft Excel for Microsoft 365 on Windows, select a table with category labels and change values,…
- Microsoft Excel Sparklines: How to Add and Format ThemMicrosoft Excel sparklines are small charts displayed inside individual worksheet cells, making it easy to spot a trend beside the numbers it…
- Microsoft Excel Pivot Charts: How to Create and UseA Microsoft Excel PivotChart is a chart linked to a PivotTable, so you can summarize and explore data by moving fields, filtering…
- Microsoft Excel Power Pivot: What It Is and How to Use ItMicrosoft Excel Power Pivot is a data-modeling feature in desktop Excel for Windows that lets you combine tables, define relationships, and analyze…
- Microsoft Excel Dashboard: Build, Design, and Use OneA Microsoft Excel dashboard is a visual summary of important data, usually built from tables, PivotTables, charts, and filters on one worksheet.…
- Microsoft Excel Combo Charts: How to Create and FormatA Microsoft Excel combo chart displays two or more data series as different chart types, such as columns for sales and a…
- Pie Chart in Excel: How to Create and Format OneTo make a pie chart in Excel for Microsoft 365 on Windows, place category names in one column and their values in…
- Manually Rearrange a Pivot Chart in ExcelYes. In Excel, manually rearrange a PivotChart by changing the item order in its associated PivotTable: drag a row or column label…
- Make a Pivot Wheel Chart in Excel: Steps and OptionsYes. In Excel for Microsoft 365, make a PivotTable, insert a PivotChart, and select a radial style such as Radar if it…
- How to Make a Pie Chart in ExcelTo make a pie chart in Microsoft Excel for Microsoft 365 on Windows, arrange category names in one column and their values…
- Manual Sort Pivot Chart in Excel: Control Category OrderTo manually sort a PivotChart in Excel for Microsoft 365 on Windows, reorder the chart’s categories in its associated PivotTable: select a…
- Make an Excel Dashboard with AI: A Step-by-Step GuideYes. You can make an Excel dashboard with AI by using an assistant to plan the layout, suggest formulas, summarize data, or…
- Link a Pivot Chart to a Slicer in ExcelTo link a slicer to an Excel PivotChart, select the PivotTable or PivotChart, choose PivotTable Analyze > Insert Slicer, and select the…
- Limit Pivot Chart Data in Excel with Filters and Top 8To limit the data shown in an Excel PivotChart, filter its PivotTable fields: use the field dropdowns on the chart or table,…
- Line Chart in Excel: Definition and How It WorksA line chart in Excel displays data as points connected by straight lines, making changes and trends across an ordered set of…