Charts & pivot tables
Build, format and fix charts and pivot tables.
- BI with Excel Power Pivot: Models, Reports, and LimitsYes—Excel Power Pivot can support business intelligence (BI) by combining data from multiple sources into a relational data model, calculating metrics with…
- Excel Power Pivot: What It Does and When to Use ItYes. Excel Power Pivot is a business intelligence (BI) and data-modeling feature built into certain Windows versions of Excel. It lets you…
- Excel Pivot Tables for BI: Uses, Limits, and AlternativesYes. Excel PivotTables can serve as a practical, entry-level business intelligence (BI) tool: they summarize data, reveal patterns, and let people explore…
- Excel Pivot Tables: How They Work and When to Use ThemAn Excel PivotTable is a tool for summarizing and exploring a larger list of data without changing the original records. You choose…
- Adding Power Pivot to Excel: Enable and Use ItTo add Power Pivot to Excel for Microsoft 365 on Windows, go to File > Options > Add-ins, select COM Add-ins beside…
- Adding Sparklines in Excel: Steps, Types, and TipsTo add a sparkline in Excel for Microsoft 365 on Windows, select the cell where it should appear, choose Insert > Sparklines…
- Excel Pivot: Add Week, Month, and Quarter SlicersTo add week, month, and quarter slicers to an Excel PivotTable, add week-start, month-start, and quarter-start fields to the source data, refresh…
- Add Power Pivot to Excel: Enable It and Get StartedTo add Power Pivot in Excel for Microsoft 365 on Windows, select File > Options > Add-ins, choose COM Add-ins from the…
- Add a Histogram in Excel: Create, Format, and Read ItTo add a histogram in Excel for Microsoft 365 on Windows, select one column of numeric data, then choose Insert > Insert…
- Activate Power Pivot in Excel: Windows Setup GuideTo activate Power Pivot in Excel for Microsoft 365 on Windows, select File > Options > Add-ins, choose COM Add-ins beside Manage,…
- Access Power Pivot in Excel: Ribbon Steps and FixesIn Excel for Microsoft 365 on Windows, open File > Options > Add-ins, choose COM Add-ins beside Manage, select Microsoft Office Power…
- Enable Power Pivot in Excel: Steps, Requirements and UseTo enable Power Pivot in Excel for Microsoft 365 on Windows, select File > Options > Add-ins. In the Manage box, choose…
- Access Power Pivot in Excel 365: Enable and Use ItTo access Power Pivot in Excel for Microsoft 365 on Windows, open File > Options > Add-ins, choose COM Add-ins in the…
- Access Power Pivot in Excel: Enable and Troubleshoot ItTo access Power Pivot in Excel for Microsoft 365 on Windows, select File > Options > Add-ins. At the bottom, set Manage…
- Power Pivot in Excel for Mac: What You Can and Can’t DoNo: Excel for Mac does not include Power Pivot, so you cannot create or manage a Power Pivot data model directly in…
- How to Create a Traffic Light Graph in ExcelTo create a traffic light graph in Excel, put the values you want to assess in a column, select them, then choose…
- Spider Web Graph in Excel: Create and Format OneIn Excel, a spider web graph is usually called a radar chart. To create one in Microsoft Excel for Microsoft 365 on…
- Excel for Mac Spiderweb Graph: Create and Format ItYes. In Excel for Mac, a spiderweb graph is called a Radar chart: arrange your categories and values in a table, select…
- Excel Pivot Table: How to Highlight Subtotal RowsYes. In Excel for Microsoft 365 on Windows, the most reliable way to highlight PivotTable subtotal rows is to create or apply…
- Show a Formula in an Excel Graph: Trendline or SeriesTo show an equation on an Excel graph, select the chart, add a trendline, open its formatting options, and check Display Equation…
- How to Add a Formula to an Excel GraphTo add a formula’s results to an Excel graph, enter the formula in a worksheet column, fill it down for each category,…
- Add a Formula in an Excel Pivot Table: Step by StepTo add a formula directly to a PivotTable in Excel for Microsoft 365 on Windows, select the PivotTable, then choose PivotTable Analyze…
- Column Sparklines in Excel: A Step-by-Step How-ToTo insert column sparklines in Excel for Microsoft 365 on Windows, select the cells where you want the mini charts, choose Insert…
- Excel Sparkline Location Range: Meaning and Setup GuideIn Excel, the sparkline Location Range is the cell or cells where the miniature charts will appear; the Data Range is the…
- Excel Trendline Not Showing? Causes and Fixes in ChartsIf the Trendline option is missing in Excel, select a data series inside the chart, not the chart background, and check that…
- Excel Sparklines: Can You Use Multiple Data Ranges?In Excel, each sparkline shows one sequence of values in one cell; it does not combine several separate ranges as independent series…
- Linear Trendline in Excel: Make One and Show Its EquationTo make a linear trendline in Excel for Microsoft 365 on Windows, select your paired data, choose Insert > Insert Scatter (X,…
- How to Make a Trendline Solid in Excel and Fix DashesTo make a trendline solid in Excel for Microsoft 365 on Windows, select the trendline, press Ctrl+1, open Fill & Line in…
- How to Create a Trendline in ExcelTo create a trendline in Excel, select a chart, then choose Chart Design > Add Chart Element > Trendline and pick a…
- How to Display a Trendline Equation in Excel ChartsTo display a trendline equation in Excel, select a chart, add a trendline, open its formatting options, and select Display Equation on…