Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Clustered Column Chart Overlap: Causes and FixesYes—columns in an Excel clustered column chart can overlap when the series overlap setting is above 0%, or when series are plotted…
- Excel Clustered Column Chart with a Secondary AxisYes. In Excel for Microsoft 365 on Windows, select the chart, choose Chart Design > Change Chart Type > Combo, set the…
- Excel Clustered Column Chart With a Line: How to Make OneTo make a clustered column chart with a line in Excel for Microsoft 365 on Windows, select your data, choose Insert >…
- Excel Clustered Column Chart Bar Width: How to Adjust ItIn Excel for Microsoft 365 on Windows, change the width of columns in a clustered column chart by selecting a column, opening…
- Excel Chart: Shade the Area Under a Line in ExcelYes. In Excel for Microsoft 365 on Windows, change a line chart to an Area chart to fill beneath the data, or…
- Excel Speedometer Chart: Build One and Make It WorkAn Excel speedometer chart is a dashboard-style gauge that shows a value on a semicircular scale; Excel does not provide a dedicated…
- Excel Chart Y-Axis Range: Set Minimum and MaximumTo change an Excel chart’s y-axis range, select the vertical value axis, open Format Axis, and enter the values you want under…
- Excel Chart Reverse Order: Flip Categories or ValuesTo reverse an Excel chart’s category order, right-click the category axis, choose Format Axis, then under Axis Options select Categories in reverse…
- Excel Chart: How to Select X-Axis DataTo select x-axis data in Excel for Microsoft 365 on Windows, click the chart, choose Chart Design > Select Data, then edit…
- Excel Chart: Shade the Area Between Two LinesTo shade the area between two lines in an Excel chart, add helper columns for the lower value and the gap between…
- Excel Chart X-Axis: Group Categories and Fix LabelsTo group categories on an Excel chart’s x-axis, arrange the category labels in adjacent columns—for example, Region and Quarter—then select those columns…
- Excel Charts from One Column: What Works and HowYes. In Excel for Microsoft 365 on Windows, select a column of numeric values, then choose Insert > Insert Column or Bar…
- Excel Chart Number Format: Display Thousands as KYes. To show Excel chart values in thousands with a K suffix, apply the custom number format 0.0,"K" to the chart axis…
- Excel Chart Area Between Lines: How to Shade the GapTo show a shaded area between two lines in Excel, use a combo chart with a stacked-area helper series for the band…
- Excel Chart Design Not Working? Fix the Common CausesIf Excel Chart Design is missing or its options are not working, click the chart first to show its contextual ribbon tab,…
- Excel Chart Fill Between Lines: The Stacked Area MethodTo fill the space between two lines in an Excel chart, add a stacked-area band made from a baseline and the difference…
- Excel Chart: How to Align Zero on a Secondary AxisTo align zero on an Excel chart’s secondary axis with zero on its primary axis, set fixed minimum and maximum bounds for…
- Excel Gantt Chart Template for Business Project PlanningAn Excel business Gantt chart template is a task list paired with a date-based grid, where colored cells or bars show when…
- Excel Bubble Chart Different Colors: Set Each SeriesYes. In Excel for Microsoft 365, bubble-chart colors are usually assigned by data series: put each group you want colored differently in…
- Excel Bubble Chart Data Setup: Build a Clear ChartSet up an Excel bubble chart with three numeric columns for each data point: an X value, a Y value, and a…
- Excel Bubble Chart Color Options: How to Customize ThemIn Excel for Microsoft 365 on Windows, select a bubble series and use Format Data Series > Fill & Line to choose…
- Excel Bubble Chart Colours: What You Can ChangeIn Excel, you can change bubble chart colours for the whole chart, a data series, or an individual bubble. Select the chart…
- Excel Bubble Chart Data Labels: Add and Format ThemTo add labels to an Excel bubble chart in Microsoft 365 for Windows, select the chart, choose Chart Design > Add Chart…
- Excel Bubble Chart Axis Settings: How to Set the ScalesIn Excel for Microsoft 365 on Windows, select an axis in the bubble chart, right-click it, and choose Format Axis to set…
- Excel Bubble Chart Color Change: Steps and OptionsTo change bubble colors in Excel for Microsoft 365 on Windows, select the chart, right-click a bubble, choose Format Data Series, then…
- Excel Org Chart: Build and Maintain One in Microsoft 365Yes. In Excel for Microsoft 365 on Windows, select Insert > SmartArt > Hierarchy, choose Organization Chart, and enter each person in…
- Excel Area Chart Change Order: Move Series CorrectlyTo change the order of series in an Excel area chart, select the chart and choose Chart Design > Select Data. Under…
- Excel Area Chart Smooth Lines: What Works and What Doesn’tNo: in Excel for Microsoft 365 on Windows, an area chart does not provide a supported Smoothed line setting for its data…
- Excel Area Chart: How to Bring a Series to the FrontTo bring one series to the front of an Excel area chart, select the chart, choose Chart Design > Select Data, select…
- Excel Align Chart to Grid: Snap, Position, and ResizeTo align a chart with Excel’s cell grid in Microsoft 365 for Windows, select the chart and hold Alt while dragging or…