Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Pie Chart Not Updating? Fix the Data Range NowAn Excel pie chart usually misses new data because its source range still ends at the old last row. Select the chart,…
- Excel Pie Chart Legend on Slices: How to Add LabelsYes. In Excel for Microsoft 365 on Windows, select the pie chart, then choose Chart Design > Add Chart Element > Data…
- Excel Pie Chart Not Showing? Fix the Data and DisplayIf an Excel pie chart is not showing, first check that its source range contains one series of numeric values and category…
- Excel Pie Chart: Group Small Categories into OtherTo group data in an Excel pie chart, first summarize the values you want to show, then chart that summary; for a…
- Excel Pie Chart Labels: Add, Format, and TroubleshootTo add labels to an Excel pie chart, select the chart and choose Chart Design > Add Chart Element > Data Labels,…
- Excel Pie Chart Labels on Slices: How to Add ThemTo put labels directly on pie slices in Excel for Microsoft 365 on Windows, select the chart, then choose Chart Design >…
- Excel Pie Chart: Exclude Zero Values and Empty SlicesExcel pie charts automatically omit zero values as slices, so you usually do not need to change a setting. If you also…
- Excel Pie Chart from a Table: Create and Format ItTo make an Excel pie chart from a table, select the category names and their numeric values, then choose Insert > Insert…
- Excel Pie Chart From PivotTable: How to Create OneYes—you can create a pie chart directly from an Excel PivotTable by selecting a cell in the table and choosing PivotTable Analyze…
- Excel Pie Chart: Combine Small Values into One SliceTo combine small values in an Excel pie chart, select the data and choose Insert > Insert Pie or Doughnut Chart >…
- Excel Pie Chart: Count Occurrences for Each CategoryYes. To make an Excel pie chart count occurrences, first summarize how many times each category appears, then chart those totals; a…
- Excel Pie Chart Zero Labels: What Happens and How to Fix ItUsually, an Excel pie chart has no visible slice for a value of zero, so its label may not appear beside a…
- Excel Pie Chart: Change the Color of a SliceTo change one slice in an Excel pie chart, click the chart, then click the slice again so only that data point…
- Excel Pie Chart: How to Change the Order of SlicesTo change the order of slices in an Excel pie chart, reorder the category and value rows in the chart’s source data;…
- Excel Online Waterfall Chart: How to Set a Bar as TotalIn Excel for the web, select the individual waterfall column and check its right-click menu for Set as Total. If that command…
- Excel Number Line Chart: Create and Format a Dot PlotExcel has no chart type named Number Line, but you can make one with an XY (Scatter) chart: put the number values…
- Excel Combo Chart Not Working? Fix the Common CausesTo create a combo chart in Excel for Microsoft 365 on Windows, select your data, choose Insert > Recommended Charts > All…
- Excel Named Ranges in Chart Data: Setup and TroubleshootingYes. In Excel for Microsoft 365 on Windows, you can use a defined name for a chart’s data series or horizontal-axis labels,…
- Excel Pie Chart from a Single Column: What Works?Yes—but a single column works only when it contains numeric values you want to compare. Select the numbers, then choose Insert >…
- Excel Line Chart With X and Y Values: Setup and TipsTo make an Excel line chart, put your x values in one column and the matching y values in the next, select…
- Excel Line Chart With Two X-Axes: Setup and AlternativesExcel can display a secondary horizontal axis on some charts, but a standard line chart does not give each series its own…
- Excel Line Chart With Multiple Lines: How to Create OneTo create an Excel line chart with multiple lines, put the shared categories—such as dates—in the first column and each data series…
- Excel Line Chart with Multiple Lines and a Secondary AxisTo make an Excel line chart with multiple lines, arrange each series in its own column, select the data, then choose Insert…
- Excel Line Chart With Two Y-Axes: How to Create OneYes. In Excel for Microsoft 365 on Windows, create a line chart, select the series that needs its own scale, right-click it,…
- Excel Line Chart With Data Labels: Add and Format ThemTo add data labels to an Excel line chart, select the chart and choose Chart Design > Add Chart Element > Data…
- Excel Line Chart With Error Bars: How to Add ThemTo add error bars to a line chart in Excel for Microsoft 365 on Windows, select the chart, then choose Chart Design…
- Excel Line Chart: Plotting Total Values Over TimeTo make an Excel line chart that uses total values, put each period or category in one column and its total in…
- Excel Line Chart Trendline: Add, Format, and ChooseTo add a trendline to an Excel line chart in Microsoft 365 for Windows, select the chart, then choose Chart Design >…
- Excel Line Chart Tutorial: Create and Format OneTo make a line chart in Excel for Microsoft 365 on Windows, arrange your categories in one column and each data series…
- Excel Line Chart Smooth Curve: Setup, Limits, and TipsYes. In Excel for Microsoft 365 on Windows, select a line in the chart, open Format Data Series, then choose Fill &…