Charts & pivot tables
Build, format and fix charts and pivot tables.
- Sample Pareto Chart in Excel: Example, Steps, TipsTo make a sample Pareto chart in Excel, first sort category counts from largest to smallest, calculate each category’s cumulative percentage, then…
- Sales Funnel Chart in Excel: Template, Setup, and TipsTo make a sales funnel chart in Excel, arrange sales stages in one column and the number of prospects at each stage…
- Resource Gantt Chart Excel Template: Build and Use ItA resource Gantt chart Excel template combines a list of assignments with a date-based timeline, so you can see who is working…
- Remove a Column from an Excel Chart Without Deleting DataTo remove a column from an Excel chart without deleting its worksheet data, select the chart, open Chart Design > Select Data,…
- How to Refresh a Visio Org Chart from ExcelIf your Visio org chart is linked to an Excel workbook, open the diagram in Visio for Windows and choose Data >…
- Refresh Pivot Table on Open in Excel: Setup & LimitsYes. In Excel for Microsoft 365 on Windows, right-click a PivotTable, choose PivotTable Options, open the Data tab, select Refresh data when…
- Ranking Chart in Excel: How to Build and Update ItTo make a ranking chart in Excel, sort values from highest to lowest, select the labels and values, then choose Insert >…
- Radar Chart Excel Tutorial: Create and Format OneTo create a radar chart in Excel for Microsoft 365 on Windows, select a table with category labels and one or more…
- Radar Chart Maker in Excel: Create and Format Radar ChartsYes. In Microsoft Excel for Microsoft 365 on Windows, select your category labels and numeric data, then choose Insert > Insert Waterfall,…
- Radial Column Chart in Excel: How to Make OneExcel does not include a built-in radial column chart type. You can approximate one by plotting each category as a thick radial…
- Radar Chart Excel Format: Setup and Styling GuideIn Microsoft Excel for Microsoft 365 on Windows, select a table with category labels and one or more data series, then choose…
- Radar Chart Excel Template: Build and Format a Chart in ExcelA radar chart Excel template is a worksheet that arranges categories and comparable measurements so you can create a radar chart with…
- Quarterly Gantt Chart Excel Template: Free OptionsYes. You can get a free quarterly Gantt chart template for Excel when one is available in a template library, or make…
- Quarterly Gantt Chart Excel Template: Build a Clear PlanA quarterly Gantt chart Excel template lays out a three-month plan as a timeline, with tasks listed in rows and colored cells…
- Proportional Area Chart in Excel: How to Create OneTo make a proportional area chart in Excel, use a bubble chart: arrange each category’s X position, Y position, and size value…
- Project Timeline Excel Template With Gantt ChartA project timeline Excel template with a Gantt chart can be built from a task list, start and finish dates, and a…
- Project Gantt Chart Template Excel: Build and Use OneA project Gantt chart template in Excel is a task list paired with a date-based grid: enter each task’s start and finish…
- Progress Doughnut Chart in Excel: Build and Format OneTo make a progress doughnut chart in Excel for Microsoft 365 on Windows, enter a completed percentage and its remainder in two…
- PowerShell Excel Pivot Refresh: Methods and Common IssuesYes. On Windows, PowerShell can refresh an Excel PivotTable by automating the installed desktop version of Excel: open the workbook, call the…
- Pivot Table Stopped Working in Excel? Causes and FixesIf a PivotTable in Excel has stopped working, first select it and choose PivotTable Analyze > Refresh; if the result is still…
- Pivot Table Report Is Invalid Error: Causes and FixesIn Excel, a “PivotTable report is invalid” message usually means the PivotTable’s source data or its field layout no longer meets Excel’s…
- Pivot Table Name Is Not Valid in Excel? How to FixThe Excel message usually means the source data has a missing or unusable column heading—not that the PivotTable’s own name is wrong.…
- Pivot Table Name Error: Causes, Fixes, and PreventionA PivotTable name error in Excel usually means either the source data has a missing or invalid column heading, or the PivotTable’s…
- Pivot Table in Excel Not Working? Fix Common CausesIf a PivotTable in Excel is not working, first select a cell inside it and choose PivotTable Analyze > Refresh; if the…
- Excel Pivot Table Formula Shortcuts and Calculated FieldsExcel has no single dedicated shortcut for inserting a formula into a PivotTable. To add a calculated field in Excel for Microsoft…
- Pivot Table Formula Errors in Excel: Causes and FixesA PivotTable formula error usually comes from an error in the source data, a calculated field that does not work as intended,…
- Excel Pivot Table Filters: Formula Options and LimitsA PivotTable does not accept a normal worksheet formula as its filter rule. Use PivotTable controls for ordinary filtering; when the rule…
- Pie Chart Speedometer in Excel: Build a GaugeTo make a pie chart speedometer in Excel, build a doughnut chart from the measured value, the unused part of the scale,…
- Pivot Table Error Messages: Causes and FixesA PivotTable error message in Excel is not one single error: the wording points to the cause, such as a blank source-column…
- Pareto Chart in Excel: Cumulative Percentage GuideYes. In Excel, a Pareto chart displays categories from largest to smallest and plots their running total as a cumulative-percentage line; for…