Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Graph Axis Range: How to Set Minimum and MaximumTo change an Excel graph’s axis range, select the chart axis, right-click it, choose Format Axis, and enter values under Axis Options…
- Excel Graph API: How It Works and What It Can DoThe Excel Graph API is the set of Microsoft Graph REST endpoints that lets an application read and change Excel workbooks stored…
- Excel Graph Axis Labels: Add, Edit, and FormatIn Excel, axis labels are the category names or scale values shown beside a chart’s horizontal or vertical axis. To change category…
- Excel Charts and Graphs: How to Choose, Create, and FormatExcel charts and graphs turn worksheet data into visual summaries that make comparisons, patterns, and changes easier to understand. In Microsoft Excel…
- Excel Chart Types: Uses, Examples, and How to ChooseExcel includes chart types for comparing categories, showing change over time, displaying parts of a whole, and exploring relationships between numbers. The…
- Power BI Pivot Table: How to Build a Matrix ReportPower BI does not have an Excel-style PivotTable object, but its Matrix visual provides a similar way to summarize data across row…
- Group Rows in a Pivot Table: Excel Steps and FixesTo group rows in an Excel PivotTable, select one or more row-label items, right-click, and choose Group. For date or number fields,…
- Power Pivot Data Analysis: How to Model Data in ExcelPower Pivot is Excel’s data-modeling tool: it lets you combine related tables, create calculations with DAX, and analyze the result in PivotTables…
- Pivot Table Data Source Reference Not Valid? How to FixIf Excel says “The PivotTable field name is not valid” or “Data source reference is not valid,” check the source range, column…
- Distinct Count in Excel Pivot Tables: A Practical GuideTo get a distinct count in a PivotTable in Excel for Microsoft 365 on Windows, create the PivotTable with Add this data…
- Create a Pivot Table in Excel: Steps and Tips That WorkTo create a PivotTable in Excel for Microsoft 365 on Windows, select a cell in a well-organized data range, choose Insert >…
- Power Pivot for Beginners: A Practical Excel GuidePower Pivot is an Excel tool for combining data from multiple tables and analyzing it with PivotTables. To get started in Microsoft…
- Cannot Group That Selection in a Pivot Table? FixesIf Excel says “Cannot group that selection” when you try to group PivotTable items, first check the source field for blanks, text…
- Power Pivot Connection Settings: Where to Find ThemIn Excel for Microsoft 365 on Windows, find Power Pivot connections by selecting Power Pivot > Manage, then, in the Power Pivot…
- Power Pivot Column Formatting: Set Formats That StickIn Excel for Microsoft 365 on Windows, open the Power Pivot window, select the column, then choose a number format from Home…
- Power Pivot Add-In: What It Does and How to Enable ItThe Power Pivot add-in is an Excel tool for building data models: it can connect tables, define relationships, and create calculations for…
- Pivot Text to Columns in Excel: Split or Reshape?If you mean splitting text from one Excel column into separate columns, select the cells and choose Data > Text to Columns.…
- Best Pivot Table Design: Five Clear Layouts for ExcelFor most Excel reports, the best pivot table design is a simple summary in Tabular Form, with only the fields needed to…
- Pivot Power Skating: How to Turn, Train, and ImprovePivot power skating is the practice of changing from forward to backward skating, or backward to forward, while staying balanced and ready…
- Basic Pivot Table: Create and Use One in ExcelA basic pivot table is an interactive summary of source data: in Excel for Microsoft 365 on Windows, select a clean data…
- Pivot Power Sioux Falls, SD: What to KnowIf you are looking for Pivot Power in Sioux Falls, South Dakota, the name alone is not enough to identify a confirmed…
- Pivot Columns in Power Query: How to Reshape DataTo pivot columns in Power Query, select the column whose distinct values should become new headers, then choose Transform > Pivot Column.…
- Balance Graph in Excel: Make One With a Running TotalTo make a balance graph in Excel, put dates and running balances in adjacent columns, select those columns, then choose Insert >…
- Pivot Tables in Microsoft Excel: How to Create and UseA PivotTable in Microsoft Excel summarizes and reorganizes a larger data set so you can compare totals, counts, and other measures without…
- Pivot Table Spill Error: Causes and FixesA PivotTable spill error usually means a dynamic-array formula cannot place its results because the intended spill range is blocked; it does…
- Excel Pivot Field Name Is Not Valid? Causes and FixesThe Excel error “The PivotTable field name is not valid” usually means the selected source data has at least one missing or…
- Chart IF Formula Examples in ExcelYes. In Excel, use an IF formula to create chart-ready values in helper columns, then select those values and choose Insert >…
- What Does a Trendline Tell You in Excel? A Clear GuideA trendline in Excel summarizes the general direction or pattern of data in a chart: it can show whether values tend to…
- Excel Trendline Tutorial: Add, Format, and Choose OneTo add a trendline in Excel for Microsoft 365 on Windows, select a chart, then choose Chart Design > Add Chart Element…
- Stacked Waterfall Chart in Excel: Handling NegativesExcel’s built-in Waterfall chart can show positive and negative changes, including a running balance that falls below zero, but it cannot stack…