Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Pivot Chart Not Showing All Data? FixesIf an Excel PivotChart is not showing all the data, first clear filters on the chart, its connected PivotTable, and any slicers,…
- Excel Pivot Chart Histogram: What Works and What Doesn’tExcel does not provide a true Histogram chart as a PivotChart type. You can, however, group numeric values into bins in a…
- Excel Pivot Chart Grand Totals: What You Can and Can’t ShowNo: an Excel PivotChart does not display the PivotTable’s grand total as a charted category or series. You can show the grand…
- Excel Pivot Chart Manual Sort: Can You Drag Items?Yes. To manually reorder categories in an Excel PivotChart, drag the corresponding item in its associated PivotTable; dragging a chart bar or…
- Excel Pivot Chart: Hide Zero Values the Right WayYes. In Excel for Microsoft 365 on Windows, hide zero-value categories in a PivotChart by applying a value filter to its PivotTable;…
- Excel Pivot Chart: Group Dates by Month?Yes. In Excel for Microsoft 365 on Windows, group dates in the PivotTable behind the PivotChart: right-click a date, choose Group, select…
- Excel Pivot Chart: Hide Field Buttons and Show Them AgainTo hide the buttons on an Excel PivotChart in Microsoft 365 for Windows, select the chart and choose PivotChart Analyze > Show/Hide…
- Excel Pivot Chart Zero Values: Why They DisappearYes. An Excel PivotChart can appear to omit zero values because the source contains blanks or text instead of numeric zeros, a…
- Excel Pivot Chart Example: Build a Sales DashboardAn Excel PivotChart example is a chart that summarizes sales by month and region, then lets you rearrange or filter the summary…
- Excel Pivot Chart Drill Down: Explore Data in ExcelTo drill down in an Excel PivotChart, select or right-click the chart data point and use an available Show Details command to…
- Excel Pivot Chart: Count Unique ValuesYes. An Excel PivotChart can display a count of unique values, but its PivotTable must use the Data Model: when you create…
- Excel Pivot Chart Colors Keep Changing? Fix the CauseExcel PivotChart colors usually change because filtering, refreshing, or rearranging fields changes which series are displayed or their order, so Excel reapplies…
- Excel Pivot Chart Date Format: Fix the Axis LabelsTo change date labels on an Excel PivotChart, select the chart’s date axis, right-click it, choose Format Axis, and set a date…
- Excel Pivot Chart: Change Legend Label NamesTo change a PivotChart legend label in Excel for Microsoft 365 on Windows, change the caption of the corresponding value field or…
- Excel Pivot Chart Legend Order: How to Change It EasilyIn Excel for Microsoft 365 on Windows, change a PivotChart’s legend order by changing the order of its series in the connected…
- Excel Pie Chart With Subcategories: How to Make OneTo show categories and their subcategories in Excel, select a table with one column for each level and a value column, then…
- Excel Pivot Chart: How to Change the Data Source SafelyTo change an Excel PivotChart’s data source, select its associated PivotTable, choose PivotTable Analyze > Change Data Source, enter or select the…
- Excel Pivot Bar Chart: Sort Categories AscendingTo sort an Excel PivotChart’s bar categories in ascending order, sort the matching field in its PivotTable: open the field’s drop-down arrow…
- Excel Pie Charts With Text Data: What Works and Why?Excel cannot use words alone to set the sizes of pie-chart slices: slice sizes must come from numeric values. But you can…
- Excel Pie Chart With Breakdown of Slices: How to Make OneTo show the detail behind one slice in Excel, create a Pie of Pie or Bar of Pie chart. Select your category…
- Excel Pie Chart With Other Category: How to Group SlicesTo make an Excel pie chart with an Other category, select the data and choose Insert > Insert Pie or Doughnut Chart…
- Excel Pie Chart Template: Create, Customize, and ReuseAn Excel pie chart template is a reusable chart design: it saves a chart type and formatting so you can apply a…
- Excel Pie Chart Labels: Use the Legend or Slice Text?In Excel, a pie chart legend identifies each slice by matching its color to a category name; it does not place text…
- Excel Pie Chart Tutorial: Create and Format OneTo make a pie chart in Excel for Microsoft 365 on Windows, select your category names and numeric values, then choose Insert…
- Excel Pie Chart: Rotate Slices and Set the First AngleTo rotate an Excel pie chart, select the chart, right-click a slice, choose Format Data Series, then change Angle of first slice…
- Excel Pie Chart: Show Percentages ClearlyYes. In Excel for Microsoft 365 on Windows, select the pie chart, then choose Chart Design > Add Chart Element > Data…
- Excel Pie Chart: Show Values, Percentages, or BothYes. In Excel for Microsoft 365 on Windows, select the pie chart, then choose Chart Design > Add Chart Element > Data…
- Excel Pie Chart Not Working? Fix Common Data IssuesIf an Excel pie chart is blank, incomplete, or showing the wrong slices, first check that its source contains one category column…
- Excel Pie Chart Percentages: Show and Calculate ThemTo show percentages on an Excel pie chart, select the chart, then choose Chart Design > Add Chart Element > Data Labels…
- Excel Pie Chart: Remove Zero-Value LabelsTo remove a zero-value label from an Excel pie chart, click the chart, click the label once to select the labels, click…