Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Double Stacked Column Chart: How to Build OneExcel does not have a chart type called a double stacked column chart, but you can create the common version—a pair of…
- Excel Double Column Chart: Create, Compare, and Format DataIn Excel for Microsoft 365 on Windows, a “double column chart” usually means a clustered column chart that places two data series…
- Excel Donut Chart Template: Build and Customize OneAn Excel donut chart template is a reusable chart design for showing how categories make up a whole. In Microsoft Excel for…
- Excel Donut Chart Total in the Middle?To put a total in the middle of an Excel doughnut chart, calculate the total in a worksheet cell, insert a text…
- Excel Donut Chart With Multiple Rings: Setup and TipsYes. In Excel for Microsoft 365 on Windows, a doughnut chart can show multiple rings when its source data contains multiple data…
- Excel Donut Chart: How to Make the Ring Wider and ThickerTo make an Excel donut chart’s ring thicker, select the ring, open Format Data Series, and reduce Doughnut Hole Size. To make…
- Excel Donut Chart Percentage: Show and Calculate LabelsTo show percentages on an Excel donut chart, select the chart and choose Chart Design > Add Chart Element > Data Labels…
- Excel Donut Chart Progress: Build a Progress RingTo make an Excel donut chart show progress, give it two values: the amount complete and the amount remaining. Select those values…
- Excel Donut Chart: Change Colors by Slice or ThemeTo change colors in an Excel donut chart, select the chart and choose Chart Design > Change Colors to apply a coordinated…
- Excel Donut Chart Labels Outside: How to Set ThemYes. In Excel for Microsoft 365 on Windows, select the donut chart, then choose Chart Design > Add Chart Element > Data…
- Excel Donut Chart: How to Create, Format, and Use OneAn Excel donut chart displays how categories contribute to a whole, using colored segments arranged around a central hole. To create one…
- Excel Stacked Column Chart: Show Total LabelsTo show totals on an Excel stacked column chart, add a row or column of totals to the worksheet, select the chart’s…
- Excel Charts Won’t Resize? How to Fix ThemIf an Excel chart will not resize or keeps changing size when worksheet cells change, select the chart and adjust its object-position…
- Excel Pivot Table Not Refreshing? Causes and FixesIf an Excel PivotTable is not refreshing, right-click inside it and select Refresh; to update every PivotTable and connection, choose Data >…
- Excel Stacked Bar Chart Data: The Right LayoutFor an Excel stacked bar chart, put each category in its own row, each data series in a separate column, and clear…
- Excel Org Chart From Employee List: 10 MethodsFor a quick chart in Excel, arrange employees in a list, choose Insert > SmartArt > Hierarchy, then build the reporting tree…
- Excel Copy Chart Formatting to Another Chart QuicklyTo copy a chart’s formatting in Excel for Microsoft 365 on Windows, select the source chart and press Ctrl+C, select the destination…
- Excel Comparison Chart Examples and How to Build ThemExcel comparison chart examples include clustered column charts for comparing sales across products, bar charts for ranking categories, line charts for tracking…
- Excel Combine Stacked and Clustered Bar ChartsExcel does not offer a single chart type that directly combines clustered and stacked bars. In Microsoft 365 for Windows, the practical…
- Excel Column Number to Letter Chart and Formula GuideIn Excel, column 1 is A, 26 is Z, 27 is AA, and 16,384 is XFD. Use the chart below for columns…
- Excel Column Number Chart: Letter-to-Number ConversionAn Excel column number chart maps column letters to their positions: A = 1, B = 2, and Z = 26; after…
- Excel Column Chart With Two Data Sources: How to Build OneYes. In Excel for Microsoft 365, you can put two data sources in one column chart by adding each source as a…
- Excel Column Chart With Two Y-Axes: Setup and TipsTo make an Excel column chart use two y-axes, select the chart and choose Chart Design > Change Chart Type > Combo;…
- Excel Column Chart Too Narrow? How to Make Bars WiderIf the columns in an Excel chart look too narrow, select a column in the chart, open Format Data Series, and reduce…
- Excel Column Chart With Percentage Change: How to Show ItTo show percentage change on an Excel column chart, calculate the change between periods, then either use those percentages as the charted…
- Excel Column Chart With Error Bars: Setup and MeaningTo add error bars to a column chart in Excel for Microsoft 365 on Windows, select the chart, then choose Chart Design…
- Excel Column Chart Colors Based on Values: How to Set ThemTo color an Excel column chart by value, use separate helper series for the value ranges you want to color, then format…
- Excel Column Chart Too Skinny? Fix the Gap WidthIf an Excel column chart looks too skinny, select a column, right-click it, choose Format Data Series, and reduce Gap Width under…
- Excel Column Chart Data Selection ExplainedTo choose data for an Excel column chart, select the cells containing the category labels and the values you want to compare,…
- Excel Column Chart: Two Axes Without OverlapYes—Excel can plot column data on two vertical axes, but the columns will commonly overlap because each axis group positions its columns…