Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Scatter Plot Help: Create and Fix Your ChartTo make an Excel scatter plot, put numeric X values in one column and matching numeric Y values beside them, select both…
- Excel Scatter Plot: Add a Second Y-AxisYes. In Excel for Microsoft 365 on Windows, select the data series you want to scale separately, right-click it, choose Format Data…
- Excel Scatter Plot from Pivot Table: How to Create OneYes—but not as a PivotChart: Excel does not offer an XY scatter chart as a PivotChart type. Create a regular scatter chart…
- Excel Scatter Plot Axis Labels: Add and Format ThemTo add axis labels (axis titles) to an Excel scatter plot in Microsoft 365 for Windows, select the chart, then choose Chart…
- Excel: Remove a Trendline From the Legend, Not the ChartTo remove a trendline from an Excel chart legend without removing the line, click the legend, click the trendline’s legend entry a…
- Excel Dashboard: Build One With or Without RAn Excel dashboard is a compact view of important measures, charts, and sometimes interactive filters, built from data in a workbook. If…
- Excel Project Dashboard Template: Build One That WorksAn Excel project dashboard template is a workbook that turns a structured project list into a quick view of status, deadlines, progress,…
- Excel Predict Value From a Trendline? How It WorksYes. Excel can estimate a value from a trendline: use a chart’s trendline forecast controls to extend the line visually, or use…
- Excel Power Query Pivot Table: How to Build OneYes—Power Query can pivot a column of values into separate columns, and you can load the result into Excel and summarize it…
- Excel Power Query Pivot Column: Steps and ExamplesTo pivot a column in Excel Power Query, select the column whose distinct values should become new headers, then choose Transform >…
- Excel Power Pivot Training: What to Learn and How to ChooseExcel Power Pivot training teaches you to build a relational data model in Excel, connect tables, and analyze the model with PivotTables…
- Excel Power Pivot Tables: How They Work and When to Use ThemAn Excel Power Pivot table usually means a PivotTable built from Excel’s Data Model, where Power Pivot can combine multiple tables and…
- Excel Power Pivot Tab: Where It Is and How to Enable ItThe Power Pivot tab is an optional Excel ribbon tab for working with data models, relationships, and DAX calculations. In Excel for…
- Excel Power Pivot Relationships: How to Create and Use ThemExcel Power Pivot relationships connect tables in the Data Model through matching columns, so you can analyze related data together without combining…
- Excel Power Pivot: What It Is and How It WorksExcel Power Pivot is a data-modeling tool in the Windows desktop version of Excel that lets you combine tables, define relationships, and…
- Excel Power Pivot Measures: How to Create and Use ThemExcel Power Pivot measures are DAX calculations stored in the workbook’s Data Model and evaluated dynamically for the current PivotTable filters, rows,…
- Excel Power Pivot KPIs: How to Create and Use ThemExcel Power Pivot KPIs are indicators built from a data-model measure and a target: they compare actual performance with the goal and…
- Excel Power Pivot KPIs: How to Create and Use ThemAn Excel Power Pivot KPI is a Key Performance Indicator built from a Data Model measure and compared with a target, with…
- Excel Power Pivot Grouping: What Works and What Doesn’tIn an Excel Power Pivot PivotTable, you generally cannot use the usual right-click Group command to group selected items or dates. Instead,…
- Excel Power Pivot Greyed Out? Causes, Checks, and FixesIf Excel Power Pivot is greyed out, first check that you are using the Windows desktop version of Excel with a license…
- Excel Power Pivot Functions: A Practical Guide to DAXExcel Power Pivot functions are DAX (Data Analysis Expressions) functions used to calculate results in an Excel Data Model. They let you…
- Excel Power Pivot: Create a Table and Build a Data ModelTo create a table in Excel Power Pivot, first make or import a structured data table in Excel, then select it and…
- KPI Dashboard PowerPoint: Build and Present Clear ReportsA KPI dashboard PowerPoint is a slide or short deck that summarizes a small set of key performance indicators, their targets, and…
- Excel Power Pivot: Create Relationships Between TablesYes. In Excel for Microsoft 365 on Windows, create a Power Pivot relationship by adding both tables to the Data Model, then…
- Excel Power Pivot: How to Create a DAX Measure in ExcelTo create a measure in Excel Power Pivot for Microsoft 365 on Windows, open the Power Pivot tab, choose Measures > New…
- Excel Power Pivot Calculated Fields: Measures ExplainedIn Excel Power Pivot, what many people call a calculated field is usually a DAX measure: a formula that calculates an aggregate,…
- Excel Power Pivot Basics: Data Models, DAX, and ReportsExcel Power Pivot is a data-modeling tool for combining tables, defining relationships, and analyzing large or multi-table datasets with PivotTables and DAX…
- Excel Power Pivot: Append Tables the Right Way in ExcelExcel Power Pivot does not have a command for appending tables. In Excel for Microsoft 365 on Windows, use Power Query’s Append…
- Excel Power Pivot: Add Rows to a Table and RefreshTo add a row to a Power Pivot table, add it to the table or other source that feeds the Data Model,…
- Excel Power Pivot: How to Add a MeasureTo add a measure in Excel Power Pivot for Microsoft 365 on Windows, open the Power Pivot tab and choose Measures >…