Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Stacked Column Chart: Reverse Series or Categories?To reverse the order of the colored sections in an Excel stacked column chart, select the chart and choose Chart Design >…
- Excel Stacked Bar Chart With Two Data Sets ExplainedTo make an Excel stacked bar chart with two data sets, arrange categories in the first column and the two data series…
- Excel Stacked Column Chart for Multiple Groups ExplainedYes—Excel can show multiple groups in a stacked column chart by using one or more category columns for the groups and separate…
- Excel Stacked Bar Chart Total Labels: How to Add ThemTo show a total at the end of each stacked bar in Excel for Microsoft 365 on Windows, calculate each row’s total,…
- Excel Stacked Bar Chart With Negative ValuesYes. Excel can display negative values in a stacked bar chart: positive series values stack to the right of zero, while negative…
- Excel Stacked Bar Chart: Show Total Data LabelsTo show totals on an Excel stacked bar chart, add data labels to the series at the end of each bar, choose…
- Excel Stacked Bar Chart: How to Show the Total ValueYes. In Excel, the clearest way to show a total at the end of each stacked bar is to calculate totals in…
- Excel Stacked Bar Chart: Show Total Data Labels EasilyYes. In Excel for Microsoft 365 on Windows, select the stacked bar chart and look in Format Data Labels for Show total;…
- Excel Stacked Bar Chart: Sort Categories by Largest ShareTo sort an Excel stacked bar chart by each bar’s largest share, add a helper column that calculates the largest segment as…
- Excel Stacked Bar Chart: Reverse Series or Category OrderYes. In Excel for Microsoft 365 on Windows, you can reverse the order of the colored segments by rearranging the chart’s data…
- Excel Stacked Bar Chart: Show Grand Totals on BarsYes. In Excel for Microsoft 365 on Windows, the clearest way to show grand totals on a stacked bar chart is to…
- Excel Stacked Bar Chart: Show PercentagesYes. In Excel for Microsoft 365 on Windows, choose a 100% Stacked Bar chart to show each category as a full 100%…
- Excel Stacked Bar Chart Not Proportional? Fix the ScaleIf an Excel stacked bar chart does not look proportional, first check whether it is a regular Stacked Bar chart or a…
- Excel Stacked Bar Chart Percentage of TotalTo show each category as a percentage of its own total in Excel, select the data and choose Insert > Insert Column…
- Excel Stacked Bar Chart Next to Non-Stacked: How ToYes—but Excel does not offer a one-click chart type that reliably places a stacked bar and a regular, unstacked bar beside each…
- Excel Stacked Bar Chart: Flip Category and Series OrderTo flip the order of the bars in an Excel stacked bar chart, right-click the vertical category axis, choose Format Axis, then…
- Excel Stacked Bar Chart: How to Make the Bars WiderTo make bars wider in an Excel stacked bar chart, select a bar, open Format Data Series, and reduce Gap Width under…
- Excel Stacked Bar Chart from a PivotTable: How to Make OneYes. In Excel for Microsoft 365 on Windows, select a cell in your PivotTable, choose PivotTable Analyze > PivotChart, then select Bar…
- Excel Stacked Bar Chart: Change Series Order EasilyTo change the series order in an Excel stacked bar chart, select the chart and choose Chart Design > Select Data. Under…
- Excel Stacked Bar Charts: Compare Years ClearlyYes. To compare years in Excel, put each year in its own row and each component you want to compare in a…
- Excel Stacked Bar Chart as a Timeline: Setup and TipsYes. In Excel for Microsoft 365 on Windows, a stacked bar chart can work as a timeline by stacking an invisible start-date…
- Excel Stacked Bar Chart: Add Total LabelsTo add totals to an Excel stacked bar chart, put each bar’s total in worksheet cells, add data labels to the final…
- Excel Stacked Area Chart With Negative Values ExplainedYes. Excel for Microsoft 365 can plot negative values in a Stacked Area chart: select the category labels and data series, then…
- Excel Stacked Bar Chart: Add, Move, and Format the LegendTo add a legend to a stacked bar chart in Excel for Microsoft 365 on Windows, select the chart, then choose Chart…
- Excel Gantt Chart Template: Create and CustomizeAn Excel Gantt chart template lays out project tasks against dates, using horizontal bars to show when each task starts and how…
- Excel Stack Chart: How to Create and Format OneTo make a stack chart in Excel for Microsoft 365 on Windows, arrange categories in the first column and the values for…
- Excel Spreadsheet Org Chart: Build, Format, and UpdateTo make an org chart in Excel for Microsoft 365 on Windows, choose Insert > SmartArt > Hierarchy > Organization Chart, then…
- Excel Speedometer Chart With Two NeedlesYes. In Excel for Microsoft 365 on Windows, you can make a two-needle speedometer by building a doughnut-chart gauge and placing two…
- Excel Sort a Column Chart by Value: Step-by-Step GuideTo sort an Excel column chart by value, sort the chart’s source data: select the whole data range, choose Data > Sort,…
- Excel SmartArt Org Chart: Create and Format a HierarchyTo create an org chart in Excel for Microsoft 365 on Windows, select Insert > SmartArt > Hierarchy, choose an organization-chart layout,…