Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Pivot Table Percent of Total: How to Show ItTo show a percent of total in an Excel pivot table, add the value field a second time, then right-click it and…
- Excel Pivot Table Percent of SubtotalTo show a value as a percent of its subtotal in an Excel pivot table, add the field to the Values area,…
- Excel Pivot Table Not Counting Unique Values? FixExcel pivot tables do not have a built-in “count unique values” option, so if you’re trying to count distinct items directly in…
- Excel Pivot Table Not Updating? Fix Refresh IssuesIf your Excel pivot table is not updating when you refresh, the most common cause is that new rows or columns were…
- Excel Pivot Table Group by Date: Step-by-StepTo group a pivot table by date in Excel, right-click any date cell inside the pivot table, choose Group, then select the…
- Excel Pivot Table Group Date Field: Step-by-StepTo group a date field in an Excel pivot table, right-click any date value in the Rows area, choose Group, then select…
- Excel Pivot Table: Modify a Calculated FieldTo modify a calculated field in an Excel pivot table, click anywhere inside the pivot table, go to the PivotTable Analyze tab…
- Excel Pivot Table Grand Total as PercentageTo show a pivot table’s Grand Total as a percentage, you add a calculated field that divides the Grand Total by itself…
- Excel Pivot Table from Filtered Data: How It WorksYes, you can create a pivot table from filtered data in Excel, but the pivot table does not automatically respect the filter…
- Excel Pivot Table: Generate Multiple Sheets?Yes, you can generate multiple sheets from a single Excel pivot table, but not with a built-in one-click command. The standard approach…
- Excel Pivot Table Formulas from Pivot ColumnsYou cannot write a regular cell formula that directly references a pivot table’s calculated fields or values by their pivot names, but…
- Excel Pivot Table Calculated Field Percentage: How-ToTo show a percentage in an Excel pivot table using a calculated field, you add a calculated field that divides one existing…
- Excel Pivot Table Can’t Add Calculated Field? Fix ItYes, Excel pivot tables can add calculated fields, but the command is grayed out or missing when you select the wrong area,…
- Excel Pivot Hide Columns: Step-by-Step GuideYes, you can hide columns in an Excel pivot table by right-clicking a column header and selecting Hide, or by unchecking the…
- Excel Pivot Table: Add Percentage ColumnYes, you can add a percentage column to an Excel pivot table by using the “Show Values As” feature. Right-click any value…
- Excel Pivot Table Calculated Fields: Formulas ExplainedTo add a calculated field in an Excel pivot table, go to PivotTable Analyze > Fields, Items & Sets > Calculated Field,…
- Excel Pivot Calculated Fields: How to Add & Use ThemA calculated field in an Excel pivot table is a custom column you add that performs a formula on the pivot’s underlying…
- Excel Multiple Pivot Tables on One SheetYes, you can place multiple pivot tables on a single worksheet in Excel, and they will work independently as long as they…
- Sort Pivot Table by Grand Total in ExcelTo sort a pivot table by the Grand Total column, click any cell inside the Grand Total row or column, then use…
- How to Refresh a Pivot Table in ExcelTo refresh a pivot table in Excel, right-click anywhere inside the pivot table and choose Refresh from the context menu. Alternatively, select…
- Excel Data Model Pivot Table Calculated Field?Yes, you can add calculated fields to a PivotTable that uses the Excel Data Model, but not through the usual PivotTable Tools…
- Excel Pivot Table zh: Chinese Terms and SetupIn an Excel search, “zh” usually means Chinese: it is the two-letter language code commonly used for Chinese, not a special PivotTable…
- Log x Function Graph: Shape, Domain, Range, and ExamplesThe graph of a logarithmic function such as y = logb(x) is a curve defined only for positive x, with a vertical…
- Line of Stability Graph: Reading the Nuclear ChartA line of stability graph shows which combinations of protons and neutrons form stable atomic nuclei, usually by plotting neutron number against…
- Slope of 0 Graph: Meaning, Examples, and How to Spot ItThe slope of a graph is 0 when the graph is a horizontal line: as x changes, y stays the same. In…
- How to Graph Z Scores in ExcelTo graph z scores in Excel, calculate each score’s z value, then plot the results with a histogram or an XY scatter…
- How to Make a Pivot Table in Excel From Your Own DataTo make a PivotTable in Excel for Microsoft 365 on Windows, put your data in a clean table with one header row,…
- Graph the Line y = x – 5: Slope, Intercepts, and StepsAssuming you mean y = x – 5, graph a straight line with slope 1 and y-intercept -5. Plot points such as…
- Line Graph in Graph Theory: Definition and ExamplesA line graph is a graph built from another graph by turning each original edge into a vertex; two new vertices are…
- Graph y = -2: Plotting the Horizontal Line Step by StepIf you mean the equation y = -2, graph it as a horizontal line two units below the x-axis. Every point on…