Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Change Pivot Table Data Range: Steps and FixesTo change a PivotTable’s source range in Excel for Microsoft 365 on Windows, click inside the PivotTable, choose PivotTable Analyze > Change…
- Excel Add Power Pivot to the Ribbon: Steps and FixesTo add Power Pivot to the ribbon in Excel for Microsoft 365 on Windows, select File > Options > Add-ins. Beside Manage,…
- Excel Trendline for All Series: How It WorksNo—Excel does not add one trendline that automatically fits every chart series together. In Microsoft 365 for Windows, add a trendline to…
- Enable Power Pivot in Excel: Windows Steps and OptionsTo enable Power Pivot in Excel for Microsoft 365 on Windows, go to File > Options > Add-ins. Under Manage, select COM…
- Edit Histogram Bins in Excel: Width, Count, and LimitsTo edit histogram bins in Excel for Microsoft 365 on Windows, select the chart’s horizontal axis, open Format Axis, and change the…
- Dynamic Dashboard in Excel: Build One That UpdatesA dynamic dashboard in Excel is a visual summary that updates when its underlying data changes or when a viewer applies filters.…
- How to Draw a Histogram in Excel: Step-by-Step GuideTo draw a histogram in Excel for Microsoft 365 on Windows, put your numeric observations in one column, select the values, then…
- Does Excel Online Have Sparklines? Setup and LimitsYes. Excel for the web—often called Excel Online—can create and format sparklines, the small charts that fit inside worksheet cells. Select your…
- Excel Sparklines: Meaning, Types, and How to Use ThemExcel sparklines are miniature charts placed inside individual worksheet cells to show a small set of data as a trend or pattern.…
- DAX in Excel Power Pivot: How It Works and When to Use ItDAX in Excel Power Pivot is the formula language used to create calculations in an Excel data model, including reusable measures and…
- Data Modeling in Excel Power Pivot: A Practical GuideData modeling in Excel Power Pivot means connecting related tables in one workbook so they can be analyzed together without repeatedly merging…
- Excel Dashboard Monitoring: How to Track Key MetricsTo monitor a dashboard in Excel, organize source data in a consistent table, calculate a small set of meaningful metrics, and review…
- Dashboard from Excel Data: Build a Clear, Useful ViewYes. To make a dashboard from Excel data, organize the source as a clean Excel Table, summarize it with PivotTables, and present…
- HR Dashboard in Excel: Metrics, Setup, and Best PracticesAn HR dashboard in Excel is a concise, refreshable view of workforce measures such as headcount, turnover, hiring, and absence. Build one…
- Excel Dashboard: How to Build a Clear, Useful ReportTo make a dashboard in Excel for Microsoft 365 on Windows, put clean data in an Excel Table, create PivotTables with Insert…
- Excel Dashboard Graphs: Choose, Build, and Format ThemExcel dashboard graphs are charts arranged to show important measures, comparisons, and trends at a glance. In Microsoft Excel for Microsoft 365…
- Free Excel Dashboard: Templates, Costs and How to Build OneYes—you can create an Excel dashboard for free using Excel for the web or a free template, provided you have access to…
- Custom Trendline in Excel: How to Add and Format OneTo add a custom trendline in Excel for Microsoft 365 on Windows, select a supported chart, then choose Chart Design > Add…
- Creating Sparklines in Excel: Steps, Tips, and FixesTo create a sparkline in Excel for Microsoft 365 on Windows, select the cell where you want the miniature chart, choose Insert…
- Creating a Power Pivot in Excel: Steps and TipsTo create a Power Pivot in Excel for Microsoft 365 on Windows, enable the Power Pivot add-in if needed, add one or…
- Consolidate Multiple Pivot Tables in ExcelTo consolidate information shown in multiple PivotTables, combine their underlying data first, then build one PivotTable from the combined source. In Excel…
- Power Pivot in Excel: Enable It and Fix Missing TabsTo enable Power Pivot in Excel for Microsoft 365 on Windows, go to File > Options > Add-ins, select COM Add-ins beside…
- How to Create a Dashboard in Excel: A Practical GuideTo create a dashboard in Excel, organize your source data in a clean table, summarize it with PivotTables or formulas, and present…
- How to Make a Dashboard in ExcelTo make a dashboard in Excel, organize your data in a clean Excel Table, summarize it with PivotTables, and turn the summaries…
- Change the X-Axis on an Excel HistogramTo change a histogram’s X-axis in Excel for Microsoft 365 on Windows, right-click the horizontal axis, choose Format Axis, and adjust the…
- Change a Trendline Name in Excel’s LegendTo change a trendline’s name in an Excel legend, select the trendline, open Format Trendline, choose Custom under Trendline Name, and type…
- How to Change Histogram X-Axis Values and Bins in ExcelTo change the x-axis values on a histogram in Excel for Microsoft 365 on Windows, right-click the horizontal axis, choose Format Axis,…
- Pivot Table Excel: How to Create and Use OneTo create a PivotTable in Excel for Microsoft 365 on Windows, select a cell in a clean data range or Excel table,…
- Can You Power Pivot Two Excel Sheets? How to Do ItYes. In Excel for Microsoft 365 on Windows, turn each sheet’s data range into an Excel table, add both tables to the…
- Can You Create a Histogram in Excel? Steps and TipsYes. In Excel for Microsoft 365 on Windows, select your numeric data, then choose Insert > Insert Statistic Chart > Histogram. Excel…