Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Pivot Table Gantt Chart: Build and Update a ScheduleYes—you can make a Gantt-style chart from Excel PivotTable data, but Excel does not have a dedicated Gantt chart type. The practical…
- Excel Pivot Table: Group Dates by MonthTo group dates by month in an Excel PivotTable in Microsoft 365 for Windows, put the date field in Rows or Columns,…
- Excel Pivot Table: Multiple Rows at the Same LevelYes. In Excel for Microsoft 365 on Windows, add each field to the PivotTable Rows area, then choose PivotTable Design > Report…
- Excel Pivot Pie Chart: Create, Filter, and Fix OneYes—Excel for Microsoft 365 on Windows can create a pie PivotChart from a PivotTable. Select a cell in the PivotTable, choose PivotTable…
- Excel Pivot Pie Chart With Slicers: How to Set It UpYes. In Excel for Microsoft 365 on Windows, create a PivotTable, insert a pie PivotChart from it, then add a slicer using…
- Excel Pivot Table Date Range: How to FilterTo filter an Excel PivotTable to a date range, open the drop-down for the date field in the Rows or Columns area,…
- Excel Pivot Chart Type Changes With Slicer?No: in Excel for Microsoft 365, a slicer filters the data shown in a PivotChart, but it does not automatically change the…
- Excel Pivot Chart Year Over Year: Setup and TipsTo make an Excel PivotChart compare results year over year, create a PivotTable from dated data, group its date field by Months…
- Excel Pivot Chart Without a PivotTable: What WorksYou can create an Excel PivotChart from a normal cell range without first converting the source data into an Excel Table, but…
- Excel Pivot Chart Tutorial: Create and Customize ChartsTo create a PivotChart in Excel for Microsoft 365 on Windows, select a clean data range or Excel table, choose Insert >…
- Excel Pivot Chart Axis: Switch Rows and Columns EasilyTo switch what an Excel PivotChart shows across its category axis and in its legend, select the chart, open PivotChart Analyze >…
- Excel Pivot Chart Trendline: What Works and What Does NotYou cannot add a trendline directly to a PivotChart in Excel for Microsoft 365 on Windows. To show a trendline for pivoted…
- Excel Pivot Chart Slicers: How to Add and Use ThemAn Excel PivotChart slicer is a set of clickable filter buttons for a PivotTable and its connected PivotChart. In Excel for Microsoft…
- Excel Pivot Chart Sort by Value: Steps, Tips, and FixesTo sort an Excel PivotChart by value, sort the corresponding field in its PivotTable: right-click a number in the value column, choose…
- Excel Pivot Chart Stacked Column: Show Grand TotalsExcel PivotCharts do not have a built-in option to place the sum above each stacked column. For reliable total labels, create a…
- Excel Pivot Chart Show Zero Values? Fixes That WorkYes. An Excel PivotChart can show zero values, but the right fix depends on whether the PivotTable contains a true zero, an…
- Excel Pivot Charts: Can They Show Grand Totals?Excel PivotCharts do not plot a PivotTable’s grand-total row or column as chart data. You can show the grand total in the…
- Excel Pivot Charts: Show Values and PercentagesYes. In Excel for Microsoft 365 on Windows, add the same numeric field to a PivotTable’s Values area twice, then set the…
- Excel Pivot Chart Secondary Y Axis: How to Add OneYes. In Excel for Microsoft 365 on Windows, select a PivotChart data series, open Format Data Series, and under Series Options choose…
- Excel Pivot Chart Scatter Plot: Limits and WorkaroundsNo—Excel for Microsoft 365 on Windows does not offer an XY (scatter) chart as a PivotChart type. You can still plot summarized…
- Excel Pivot Chart Secondary Axis: The WorkaroundIn Excel for Microsoft 365 on Windows, you generally cannot put a native PivotChart series on a true secondary axis because PivotCharts…
- Excel Pivot Chart: Remove “Sum of” From LabelsTo remove “Sum of” from a PivotChart legend label in Excel for Microsoft 365 on Windows, rename the chart’s value field: right-click…
- Excel Pivot Chart Axis Labels: How to Rotate Them EasilyTo rotate category-axis labels in an Excel PivotChart, select the labels, right-click and choose Format Axis, then open Text Options > Text…
- Excel Pivot Chart: How to Remove ButtonsTo remove the buttons from an Excel PivotChart in Microsoft 365 for Windows, select the chart, open the PivotChart Analyze tab, choose…
- Excel Pivot Chart: How to Remove Filter Buttons EasilyTo remove filter buttons from an Excel PivotChart in Microsoft 365 for Windows, select the chart and choose PivotChart Analyze > Show/Hide…
- Excel Pivot Chart: How to Remove a SeriesTo remove a series from an Excel PivotChart, select the chart, open PivotChart Analyze > Field List, and remove the relevant field…
- Excel Pivot Chart Not Updating? Fixes That WorkIf an Excel PivotChart is not updating, refresh the PivotTable behind it: select the PivotTable and choose PivotTable Analyze > Refresh, or…
- Excel Pivot Chart: Show Only Certain ColumnsYes. In Excel for Microsoft 365 on Windows, select the PivotChart and use the drop-down on the relevant field button to filter…
- Excel Pivot Chart Pie Chart: Multiple Columns ExplainedYes, you can make a pie PivotChart in Excel, but a pie chart can show only one data series at a time.…
- Excel Pivot Chart Multiple Lines: How to Create ThemYes. To show multiple lines in an Excel PivotChart, create a PivotChart from your PivotTable, choose a line chart, put the time…