Charts & pivot tables
Build, format and fix charts and pivot tables.
- Thermometer Chart Excel Template: Create One That WorksA thermometer chart Excel template is usually a worksheet with an actual value and a target, paired with a stacked column chart;…
- Temperature Gauge Chart in Excel: How to Build OneYes. In Excel for Microsoft 365 on Windows, create a thermometer-style temperature gauge by charting the measured temperature and the unused part…
- Superscript in Excel Chart Legends: Methods That WorkTo show superscript in an Excel chart legend, put the superscript character directly in the series name—usually the chart’s source header cell—for…
- Sunburst Chart Excel Template: How to Build and FormatA Sunburst chart Excel template is a workbook layout with hierarchical category columns and one numeric value column, ready to turn into…
- Stylish Doughnut Chart in Excel: Design Tips & StepsTo make a stylish doughnut chart in Excel for Microsoft 365 on Windows, select a clean category-and-value table, choose Insert > Insert…
- Standard Error in Excel Pivot Tables: How to Calculate ItExcel PivotTables do not have a built-in Standard Error summary. To calculate the standard error of a mean, show the sample standard…
- Stacked Column Chart Excel With Two Columns?Yes—Excel can make a stacked column chart from two columns of values, but the chart needs at least two data series to…
- Stacked Pareto Chart in Excel: How to Build OneExcel does not have a built-in chart type called a stacked Pareto chart. To make one in Microsoft 365 for Windows, sort…
- Stacked Column Chart in Excel: How to Show PercentagesYes. To make every column represent 100%, select a 100% Stacked Column chart; to print percentages on the segments, add data labels…
- Stacked Column Chart in Excel: Create and Read ItTo make a stacked column chart in Excel for Microsoft 365 on Windows, arrange categories in the first column and each data…
- Stacked Bar Chart in Excel: Build It from a TableTo make a stacked bar chart in Excel, arrange categories in the first column and the values for each series in separate…
- Stacked Bar Pareto Chart in Excel: Build and FormatTo make a stacked Pareto chart in Microsoft Excel for Microsoft 365 on Windows, sort categories by their combined total, plot the…
- Stacked Bar Chart in Excel with 4 Variables: How-ToTo make a stacked bar chart in Excel with four variables, put one category in the first column and each numeric variable…
- Stacked Bar Chart Not Working in Excel? Fix ItIf a stacked bar chart in Excel is blank, has the wrong segments, or looks nothing like the source data, check the…
- Stacked Bar Chart Excel Template: Build and Customize OneA stacked bar chart Excel template is a reusable chart setup that shows how several series contribute to a total for each…
- Stacked Bar Chart in Excel With Two VariablesTo make a stacked bar chart in Excel, arrange each bar category in one column, put the values for each stack segment…
- Stacked Bar Chart Data in Excel: Setup and TipsTo make a stacked bar chart in Excel, put each category in its own row, each data series in a separate column,…
- Stacked Bar Chart Excel Gantt: Build a Task TimelineYes. In Excel, a Gantt chart can be made from a stacked bar chart by plotting each task’s start date as an…
- Stacked Column Chart in Excel: Create and UseA stacked column chart in Excel displays several data series as colored sections stacked within vertical columns, so you can compare both…
- Square Area Chart in Excel: How to Create and FormatExcel does not include a chart type named “Square Area Chart.” If you mean an Area chart displayed in a square-shaped frame,…
- Speedometer Gauge Chart in Excel: How to Build OneTo make a speedometer gauge chart in Excel, build a doughnut chart from value bands, hide the bottom half, and add a…
- Speedometer Chart in Excel: Build a Reusable TemplateA speedometer chart is not a built-in Excel chart type, but you can create a reusable gauge from a doughnut chart and…
- Smooth Area Chart in Excel: Options and WorkaroundsExcel does not provide a native smooth-curve switch for an area chart. In Microsoft 365 for Windows, create one with Insert >…
- Side-by-Side Stacked Column Chart in ExcelTo make a side-by-side stacked column chart in Excel for Microsoft 365 on Windows, arrange each main category and subgroup in separate…
- Excel Column Chart Side Wall: What It Is and How to FormatIn Excel, a side wall is a background plane on a three-dimensional (3-D) chart; an ordinary two-dimensional (2-D) column chart has no…
- Show Total Value in a Stacked Bar Chart in ExcelTo show totals at the ends of stacked bars in Excel for Microsoft 365 on Windows, calculate each row’s total in a…
- Side-by-Side Column Chart in Excel: How to Make OneTo make a side-by-side column chart in Excel for Microsoft 365 on Windows, arrange your categories in the first column and each…
- Shade Area of a Chart in Excel: Methods and TipsTo shade the area beneath a line in Excel, select the chart, go to Chart Design > Change Chart Type, and choose…
- Selecting the Chart Area in Excel: A Practical GuideTo select the chart area in Excel for Microsoft 365 on Windows, click a blank part of the chart outside the plot…
- Sample Org Chart in Excel: Build a Clear HierarchyYes. In Excel for Microsoft 365 on Windows, choose Insert > SmartArt > Hierarchy > Organization Chart, then enter names and job…