Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Pivot Var: What It Means and How to Read ResultsIn an Excel PivotTable, Var means sample variance: it measures how spread out the numeric values are around their average, using a…
- Excel Pivot Table SUMPRODUCT: When and How to Use ItYou generally cannot enter SUMPRODUCT directly as a PivotTable value calculation: a standard PivotTable summarizes source fields, while SUMPRODUCT works on worksheet…
- Excel Not Generating Charts? Fix the Common CausesIf Excel is not generating a chart, first select a clean range that includes the labels and values, then choose Insert >…
- Excel Charts: How to Choose and Create the Right ChartExcel charts turn worksheet data into visual summaries that make comparisons, trends, and relationships easier to see. To create one in Microsoft…
- Excel Not Plotting Data Correctly? Fix the ChartIf Excel is not plotting data correctly, select the chart and go to Chart Design > Select Data to check its source…
- Excel IFS in Pivot Tables: How to Add and Summarize ItYes, you can use an IFS formula with an Excel PivotTable, but the dependable method is to put IFS in a column…
- Break-Even Graph in Excel: Build and Read OneTo make a break-even graph in Excel, set up columns for units sold, revenue, and total costs, then plot them in a…
- Correlation Graph in Excel: Create and Interpret OneTo make a correlation graph in Excel, select two columns of paired numeric data and choose Insert > Insert Scatter (X, Y)…
- Data Visualization in Excel: Charts and Best PracticesYes—Microsoft Excel can turn worksheet data into charts, PivotCharts, conditional-formatting visuals, and compact in-cell trends. In Excel for Microsoft 365 on Windows,…
- Standard Deviation Graph in Excel: Create and Read ItExcel does not have a single chart type called a standard deviation graph. To show a distribution, calculate the mean and standard…
- Excel Data Model: Add a Calculated Column in Power PivotYes. In Excel for Microsoft 365 on Windows, open the Data Model in Power Pivot, select the table, and enter a DAX…
- Excel Mac Pivot Tables: Create, Refresh, and TroubleshootYes—Excel for Mac can create and use PivotTables. Select a clean data range, choose Insert > PivotTable, then arrange fields in the…
- Excel Pivot Table Won’t Refresh? How to Fix ItIf an Excel PivotTable won’t refresh, select a cell inside it and choose PivotTable Analyze > Refresh in Excel for Microsoft 365…
- Excel Pivot Tables: Advanced Features and AnalysisYes. Excel PivotTables support advanced analysis through features such as calculated summaries, percentage and running-total views, date grouping, slicers, PivotCharts, and the…
- Excel Pivot Table Weighted Average: Methods That WorkExcel PivotTables do not have a built-in Weighted Average summary option. The dependable approach is to add a row-level value-times-weight column to…
- Excel Pivot Table Variance Between Columns: How to CalculateTo show a variance between column items in an Excel PivotTable, right-click a value, choose Show Values As > Difference From, then…
- Excel Pivot Table Weekly Totals: Group Dates by WeekTo get weekly totals in an Excel PivotTable, put a valid date field in Rows and a numeric amount field in Values,…
- Excel Pivot Table Values Not Summing? Fix the CauseIf Excel PivotTable values are not summing, first check that the source column contains real numbers rather than numbers stored as text,…
- Excel Pivot Table Values as Text: What Works and WhyIn a standard Excel PivotTable, you generally cannot put a text field in the Values area and have it return the original…
- Excel Pivot Table Value Field Settings: How They WorkExcel PivotTable value field settings control how a field in the Values area is summarized and how its results are displayed. To…
- Excel Pivot Table Update Data Range: Steps and FixesTo update an Excel PivotTable’s data range, select the PivotTable and choose PivotTable Analyze > Change Data Source, enter the new range,…
- Excel Pivot Tables: Do They Update Automatically?No—an Excel PivotTable in Microsoft 365 for Windows does not normally update as soon as you change its source cells. Select the…
- Excel Pivot Table: How to Turn Off SubtotalsTo turn off every subtotal in an Excel PivotTable, click inside it and choose PivotTable Design > Subtotals > Do Not Show…
- Excel Pivot Table Unique Values: Count or List ThemTo list unique values in Excel, put the field in a PivotTable’s Rows area; repeated labels appear once. To count distinct values,…
- Excel Pivot Table Tabular View: Setup and FormattingTo display an Excel PivotTable in tabular view, click inside the PivotTable and choose PivotTable Design > Report Layout > Show in…
- Excel Pivot Table Show Text in Values? How It WorksA standard Excel PivotTable cannot display a text field as an ordinary value: when you drag text into Values, Excel usually counts…
- Excel Pivot Table Sort by Count: Quick StepsTo sort an Excel PivotTable by count, place the field you want to count in the Values area, set its summary to…
- Excel Pivot Table: Show Only Filtered Data in Your Report?Yes. In Excel for Microsoft 365 on Windows, filter a PivotTable field using its dropdown, or add a field to the Filters…
- Excel Pivot Table Running Total: Setup and TroubleshootingTo show a running total in an Excel PivotTable, select a value in the Values area, right-click it, and choose Show Values…
- Excel Pivot Table: Show All Row ValuesTo show a row label on every line in an Excel PivotTable, select the table, choose PivotTable Design > Report Layout >…