Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Add Shaded Area to a Chart: Steps and OptionsTo add a shaded area to an Excel chart, use an area series for the region you want filled, then format its…
- How to Add a Trendline to an Excel Clustered Column ChartIn Excel for Microsoft 365 on Windows, select the clustered column chart, then choose Chart Design > Add Chart Element > Trendline…
- Excel Add Line to Column Chart: Step-by-Step GuideTo add a line to a column chart in Excel for Microsoft 365 on Windows, add the line’s values as a data…
- Excel 3D Clustered Column Chart: Create and Format ItTo create an Excel 3D clustered column chart in Microsoft 365 for Windows, select a table with category labels in the first…
- Excel 100% Stacked Bar Chart: Why It Looks WrongAn Excel 100% stacked bar chart is proportional within each bar, not between bars: it scales every category to a total length…
- Excel 100% Stacked Bar Chart: Show PercentagesYes. In Excel for Microsoft 365 on Windows, a 100% stacked bar chart scales each category to 100%, so its horizontal value…
- Excel 100% Stacked Bar Chart: How to Create OneTo create a 100% stacked bar chart in Excel for Microsoft 365 on Windows, select a table with categories in the first…
- Excel Pivot Table Errors: Causes and FixesIf Excel shows an error when you try to create a PivotTable, first check that the source has one clear header row,…
- Excel Pivot Table Error: Causes and FixesIf Excel shows an error while creating a PivotTable, first check that the source data is one continuous range with a nonblank,…
- Excel Clustered Bar Chart Error Bars: How to Add and FormatTo add error bars to a clustered bar chart in Excel for Microsoft 365 on Windows, select the chart, then choose Chart…
- Excel Chart Error Bars: How to Add and Format ThemTo add error bars in Excel for Microsoft 365 on Windows, select a chart, then choose Chart Design > Add Chart Element…
- Easy Org Chart in Excel: Steps and TipsYes. The easiest way to make an org chart in Excel for Microsoft 365 on Windows is to use SmartArt: choose Insert…
- Easy Org Chart Maker in Excel: Quick Steps and TipsYes. In Excel for Microsoft 365 on Windows, the easiest org chart maker is SmartArt: choose Insert > SmartArt > Hierarchy >…
- Dynamic Pareto Chart in Excel: Setup and UpdatesTo make a dynamic Pareto chart in Excel for Microsoft 365 on Windows, put one category and its count on each row…
- How to Make an Org Chart in ExcelThe easiest way to make an org chart in Excel for Microsoft 365 on Windows is to use SmartArt: select Insert >…
- How to Draw a Pareto Chart in ExcelTo draw a Pareto chart in Excel for Microsoft 365 on Windows, select a table with category names and their counts, then…
- Dynamic Charts in Excel Using the OFFSET Function ExplainedYes. In Excel for Microsoft 365 on Windows, you can make a chart expand as new rows are added by defining workbook…
- Double Stacked Bar Chart in Excel: How to Create OneTo create a double stacked bar chart in Excel, put each bar you want to compare on its own row, with one…
- Doughnut Chart in Excel: Show PercentagesYes. In Microsoft Excel for Microsoft 365 on Windows, select your category names and values, choose Insert > Insert Pie or Doughnut…
- Double Doughnut Chart in Excel: How to Create OneTo create a double doughnut chart in Excel for Microsoft 365, put the category names in the first column and the values…
- Excel Thermometer Charts: Built-In or DIY?Excel does not have a dedicated Thermometer Chart type in Microsoft 365 for Windows. You can make the familiar thermometer-style progress display…
- Does Excel Have an Org Chart? How to Create OneYes. Microsoft Excel for Microsoft 365 includes an org chart option in SmartArt: select Insert > SmartArt > Hierarchy > Organization Chart,…
- Does Excel Have an Org Chart Template? What to KnowYes. Excel for Microsoft 365 on Windows includes an Organization Chart layout in SmartArt, which you can use to build a hierarchy…
- Does Excel Have a Sunburst Chart? How to Make OneYes, Microsoft Excel has a built-in Sunburst chart for showing hierarchical data, such as departments divided into teams or product groups divided…
- Does Excel Have a Funnel Chart? How to Create OneYes. Microsoft Excel for Microsoft 365 on Windows includes a built-in Funnel chart for showing values across stages of a process, such…
- Diverging Stacked Bar Chart in Excel: How to Make OneYes. In Excel for Microsoft 365 on Windows, make a diverging stacked bar chart by splitting neutral responses into equal negative and…
- Div/0 Error in Pivot Tables: Causes, Checks, and FixesA #DIV/0! error in an Excel PivotTable usually means a value being summarized—or a formula used to calculate it—tries to divide by…
- Detailed Gantt Chart in Excel: Build and Manage a PlanTo make a detailed Gantt chart in Excel, list each task with a start date and duration, create a row of calendar…
- Data Source Reference Error in Pivot Tables: FixesThe Excel message Data source reference is not valid means the PivotTable cannot use the range, table, named range, or external source…
- Data Not Showing in Excel Chart? Fix the Source and AxisIf data is not showing in an Excel chart, first select the chart and check its source range at Chart Design >…