Charts & pivot tables
Build, format and fix charts and pivot tables.
- 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…
- Z Score Distribution Graph: Meaning, Uses, and ExamplesA z score distribution graph shows values on a standard normal curve, where the horizontal axis is measured in standard deviations from…
- Graph a Line Equation: Steps, Examples, and TipsTo graph a line equation, identify two points that satisfy it, plot them on a coordinate plane, and draw the straight line…
- What Does P Represent on a Graph? Meaning and ExamplesOn a graph, p represents the quantity or variable assigned to it by the graph’s labels, equation, or surrounding explanation; it has…
- Line 3 of a Graph in Excel: How to Find and Format ItIn an Excel chart, “line 3” usually means the third data series—the third set of values drawn as a line. Its exact…
- T-Test Distribution Graph: How to Read and Interpret ItA t-test distribution graph is a picture of the t-distribution: a symmetric, bell-shaped probability curve centered at zero. It helps show how…
- Behavioral Economics and Graph Theory: How They ConnectBehavioral economics and graph theory connect when economists use networks to study how people’s choices are shaped by their relationships. Graph theory…
- Point Q on a Graph: Coordinates and MeaningPoint Q on a graph is a labeled location, usually identified by an ordered pair of coordinates such as Q(3, 2). On…
- Line Graph With 2 Lines in Excel: Create and Compare DataA line graph with two lines shows two data series across the same ordered categories or time periods, making their trends easy…
- Zero Line on a Graph: Meaning and How to Show It in ExcelA zero line on a graph is the reference line marking a value of zero on an axis. It helps you see…
- X and Y Line Graph in Excel: Create and Format ItIn Excel, use an XY scatter chart with straight lines when your X values are numbers that must determine each point’s horizontal…