Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Pie Chart From a Single Column: How It WorksIn Excel for Microsoft 365 on Windows, select a column of numeric values, then choose Insert > Insert Pie or Doughnut Chart…
- Excel Copy Pivot Chart: Change Its Data Source Safely?Copying a PivotChart in Excel does not normally give the copy an independent data source: the copied chart remains connected to its…
- Excel Copy Trendline Equation to a Cell: What WorksYou cannot directly link an Excel chart’s displayed trendline equation to a worksheet cell with a built-in formula. To put the equation…
- Excel Consolidate Pie Charts: Methods and LimitsTo consolidate data for a pie chart in Excel, combine the category totals into one summary table, select that table, then choose…
- Excel Combo Chart: Stacked Bar and LineIn Excel for Microsoft 365 on Windows, you can combine stacked columns and a line by selecting your data, choosing Insert >…
- Excel Combo Pivot Chart: How to Build One in Microsoft 365Excel does not support a true combo chart as a PivotChart: you cannot combine chart types such as columns and a line…
- Excel Combo Chart Not Available? Causes and FixesYes—Excel for Microsoft 365 on Windows includes combo charts. If the Combo option is missing, try selecting a regular chart and choosing…
- Excel Combo Chart Secondary Axis: Setup and TipsTo put a series on a secondary axis in an Excel combo chart, select the chart, choose Chart Design > Change Chart…
- Excel Combo Chart: Two Stacked Columns Side by SideYes. In Excel for Microsoft 365 on Windows, you can make a combo chart with two separate stacked columns per category by…
- Excel Combo Chart: How to Combine Bars and a Line in ExcelTo make a bar-and-line combo chart in Excel for Microsoft 365 on Windows, select your data, choose Insert > Recommended Charts >…
- Excel Combo Chart: Change a Bar to a LineTo change one bar or column series to a line in an Excel combo chart, select the chart, go to Chart Design…
- Excel Combo Chart Example: Build a Clear Two-Axis ChartAn Excel combo chart combines two chart types—such as columns and a line—in one visual. For a practical example, plot monthly revenue…
- Excel Chart Stop Line Dropping to Zero: Causes and FixesTo stop an Excel line chart from dropping to zero when data is missing, select the chart and choose Chart Design >…
- Excel Chart Horizontal Line: Add a Constant or TargetTo add a horizontal target or constant line to an Excel chart, add a new data series whose value repeats across the…
- Excel Chart Line of Best Fit: How to Add and Read ItTo add a line of best fit in Excel for Microsoft 365 on Windows, select a chart, then choose Chart Design >…
- Excel Chart Gridline Interval: How to Set ItIn Excel for Microsoft 365 on Windows, set a chart’s gridline interval by formatting the axis that the gridlines belong to: right-click…
- Excel Chart Extend Line: Forecast Beyond Your DataTo extend a line beyond the last point in an Excel chart, select the data series, add a trendline, then set a…
- Excel Box Plot X-Axis Labels: Set and Fix ThemIn Excel for Microsoft 365 on Windows, a box plot’s x-axis labels normally come from the column headers in the chart’s source…
- Excel Box Plot X-Axis: Categories, Labels, and FixesIn an Excel box plot, the x-axis normally shows the categories or data groups being compared; the y-axis shows the numeric values.…
- Excel Box Plot: Add a Series and Expand the Chart DataTo add a series to an Excel box plot in Microsoft 365 for Windows, select the chart, choose Chart Design > Select…
- Excel Box and Whisker Plot X-Axis ExplainedIn an Excel box-and-whisker plot, the x-axis is the horizontal category axis: it identifies the groups represented by the boxes, such as…
- Excel Bar of Pie Chart: How to Configure ItTo configure a Bar of Pie chart in Excel for Microsoft 365 on Windows, select a category-and-value data range, choose Insert >…
- Excel Gantt Chart: Build, Format, and Manage a ScheduleYes. An Excel-based Gantt chart is a project schedule displayed as task rows and date columns, with colored cells showing when each…
- Excel Bar Chart With Line Overlay: How to Create OneTo make an Excel bar chart with a line overlay, select your category labels and data series, then choose Insert > Insert…
- Excel: Add a Reference Line to a ChartTo add a reference line in Excel for Microsoft 365 on Windows, add a helper data series containing the target value for…
- Excel Add Horizontal Line to Chart: Steps and TipsTo add a horizontal target or reference line to an Excel chart, add a data series whose value is repeated across the…
- Excel Add a Line to a Chart: Steps and OptionsTo add a line to an Excel chart, select the chart, choose Chart Design > Select Data > Add, then enter the…
- Excel 3-Line Chart: Create and Format Three SeriesTo create a three-line chart in Excel for Microsoft 365 on Windows, put the category labels in the first column and the…
- Excel 100% Stacked Lines in a Combo ChartYes, you can combine percentage lines with another chart type in Excel, but the most dependable method is to calculate each line’s…
- Enable Power Pivot in Excel: Steps and CompatibilityTo enable Power Pivot in Excel for Microsoft 365 on Windows, select File > Options > Add-ins, choose COM Add-ins in the…