Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel SmartArt Org Chart: Create and Customize ChartsTo create an org chart in Excel for Microsoft 365 on Windows, choose Insert > SmartArt > Hierarchy > Organization Chart, then…
- Excel SmartArt Org Charts: Create, Edit, and Fix ThemTo make an org chart in Excel for Microsoft 365 on Windows, choose Insert > SmartArt > Hierarchy > Organization Chart, then…
- Excel Side-by-Side Stacked Bar Chart: How to Make OneExcel does not have a built-in chart type that clusters multiple stacked bars in one category. A practical workaround is to put…
- Excel Shade Under Line Graph: How to Fill the AreaTo shade under a line graph in Excel, change the chart to a 2-D Area chart; Excel fills the space between each…
- Excel Reverse X-Axis Order: Fix Categories and DatesTo reverse the order of an Excel chart’s horizontal category axis, right-click the axis, choose Format Axis, then under Axis Options select…
- Excel: Remove Zero Values From a Stacked Bar ChartTo remove visible zero labels from an Excel stacked bar chart, format the data labels with a number format that leaves the…
- Excel Refresh Pivot Table After Query Refresh: How It WorksTo refresh a PivotTable after its query has finished updating, select a cell in the PivotTable and choose PivotTable Analyze > Refresh,…
- Excel Radar Chart With Different Scales: What WorksNo: an Excel radar chart uses one shared value scale for every series and spoke, so you cannot assign a different scale…
- Excel Radar Chart Radial Lines: Show, Hide, and FormatIn an Excel radar chart, the lines radiating from the center are category-axis lines, often called spokes; the rings or polygon-shaped lines…
- Excel Radar Charts Over Time: Setup and Better OptionsYes—Excel can use a radar chart to compare measurements from different dates, but a radar chart does not have a true time…
- Excel Radar Chart Fill: Add, Color, and Adjust the AreaTo fill the area of an Excel radar chart, select the chart and choose Chart Design > Change Chart Type > Radar…
- Excel Radar Chart: Change the Axis ScaleIn Excel for Microsoft 365 on Windows, select the radar chart’s value axis, open Format Axis, and enter the values you want…
- Excel Radar Chart Scale: Set the Minimum and MaximumIn Excel for Microsoft 365 on Windows, select the radar chart’s numeric value axis, right-click it, and choose Format Axis. Under Axis…
- Excel Product Comparison Chart Template: How to Build OneBuild an Excel product comparison chart template by listing products in rows and decision criteria in columns, then add filters, clear formatting,…
- Excel Pivot Table Using Multiple Sheets: How It WorksYes. In Excel for Microsoft 365 on Windows, you can build a PivotTable from multiple sheets by combining their rows with Power…
- Excel Pivot Table Won’t Sort? Fixes for Common Sorting ProblemsIf an Excel PivotTable will not sort, select an item in the field you want to reorder, right-click it, and choose Sort…
- Excel Pivot Table Won’t Group Dates? Fix the Source DataIf an Excel PivotTable won’t group dates, the date column usually contains text, blanks, or errors—or the PivotTable’s source does not support…
- Excel Pivot Table: Use a Field as Row and FilterYes. In an Excel PivotTable, you can place the same field in both the Rows and Filters areas. The field then appears…
- Excel Pivot Table Unable to Group Dates? Fix the SourceIf an Excel PivotTable cannot group dates, first check the source date column for blanks, errors, or values stored as text rather…
- Excel Pivot Table Sort Not Working? Fix the CauseIf an Excel PivotTable will not sort, first select an item or value in the field you want to order, then use…
- Excel Pivot Table Sort in Data Source Order: How It WorksExcel does not automatically keep PivotTable row labels in the order they first appear in the source data. To reproduce that order…
- Excel Pivot Table Date Sorting: Get Chronological OrderTo sort dates chronologically in an Excel PivotTable, right-click a date in the row or column labels and choose Sort > Sort…
- Excel Pivot Table: How to Sort Items in the Filter ListIn Excel for Microsoft 365 on Windows, open the PivotTable field’s drop-down and choose Sort A to Z or Sort Z to…
- Excel Pivot Table Dates: How to Group and Sort by WeekTo sort PivotTable dates by seven-day periods in Excel for Microsoft 365 on Windows, right-click a date in the PivotTable, choose Group,…
- Excel Pivot Table Sort by Value Not Working? FixesIf an Excel PivotTable will not sort by value, select a number in the value column you want to sort, right-click it,…
- Excel Pivot Table Date Sorting Wrong? Fix the Sort OrderIn Excel for Microsoft 365 on Windows, a PivotTable sorts genuine date values chronologically. If the order is wrong, check whether the…
- Excel Pivot Table: Show Errors as BlankTo show errors as blank in an Excel PivotTable, select the PivotTable, open PivotTable Analyze > Options, go to Layout & Format,…
- Excel Pivot Table Rows and Filters: How They WorkIn an Excel PivotTable, the Rows area determines which categories appear down the left side, while the Filters area adds a report-wide…
- Excel Pivot Table Show Report Filter Pages ExplainedIn Excel for Microsoft 365 on Windows, select the PivotTable, open PivotTable Analyze > Options, and choose Show Report Filter Pages. Select…
- Excel Pivot Table Refresh Error? Causes and FixesTo fix an Excel PivotTable refresh error, select the PivotTable and choose PivotTable Analyze > Refresh; to update every connection and PivotTable…