Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Sparklines: Purpose, Types, and How to Use ThemExcel sparklines are tiny charts displayed inside worksheet cells. Their purpose is to show the shape or direction of a data series…
- Excel Histogram: Create, Format, and Choose the Right BinsYes. In Excel for Microsoft 365 on Windows, select a column of numeric data, then choose Insert > Insert Statistic Chart >…
- Trendline Not an Option in Excel? How to Add One NowNo—Excel supports trendlines, but the option is unavailable for some chart types or when the chart itself, rather than a data series,…
- Histogram in Excel: Create, Format, and Interpret OneTo create a histogram in Microsoft Excel for Microsoft 365 on Windows, select your numeric data and choose Insert > Insert Statistic…
- Stacked Histogram in Excel: What It Is and How to Make OneExcel does not offer a built-in stacked histogram chart type. To make one in Microsoft Excel for Microsoft 365 on Windows, count…
- Sparklines Group in Excel: How to Group and Format ThemYes. In Excel, you can group selected sparklines so they share formatting and chart-type settings: select the sparkline cells, open the contextual…
- Sparklines in Excel: What They Are and How to Use ThemSparklines in Excel are tiny charts displayed inside individual cells; they are a charting feature, not worksheet functions you enter in a…
- Sparklines in Excel for the Web: What Works?Yes. Excel for the web can create and display sparklines—small charts placed inside worksheet cells—using the Insert tab. Select a destination cell,…
- Excel Sparklines: Meaning, Uses, and How to Add ThemIn Excel, sparklines are tiny charts placed inside individual worksheet cells to summarize a series of values. They show a trend or…
- Scatter Plot Maker in Excel: Create and Customize ChartsTo make a scatter plot in Microsoft Excel for Microsoft 365 on Windows, put your X values in one column and matching…
- Scatter Plot Excel Formatting Tips for Clearer ChartsTo format a scatter plot in Excel for Microsoft 365 on Windows, select the chart and use the Chart Design and Format…
- Scatter Plot Data in Excel: Create and Read ChartsTo create a scatter plot in Excel for Microsoft 365 on Windows, put numeric X values in one column and matching numeric…
- Resource Histogram Template Excel: Build and Use OneA resource histogram template in Excel is a time-based grid that shows how much work each person or resource is scheduled to…
- Rename a Trendline in Excel: Steps, Labels, and FixesTo rename a trendline in Excel for Microsoft 365 on Windows, select the trendline, open its formatting pane, and under Trendline Options…
- Regression Excel Scatter Plot: Add a Trendline and Read ItTo make a regression scatter plot in Excel, put the independent variable in one column and the dependent variable in the next,…
- Relative Frequency Histogram in Excel: Steps and FormulasTo make a relative frequency histogram in Excel, create bins, count how many observations fall in each bin, divide each count by…
- Professional Excel Dashboard: Design and Build OneA professional Excel dashboard turns reliable, organized data into a clear view of performance and next steps. In Microsoft Excel for Microsoft…
- Project Dashboard in Excel: Build and Track ProgressTo make a project dashboard in Excel, organize project details in an Excel Table, calculate a few key measures such as project…
- Production Dashboard in Excel: Build and Track OutputYes. You can build a production dashboard in Microsoft Excel for Microsoft 365 by keeping production records in a consistent table, calculating…
- Power Pivot Excel Formulas: DAX Measures and ColumnsPower Pivot formulas are written in Data Analysis Expressions (DAX), not with ordinary Excel worksheet formulas. Use a DAX measure for results…
- Power Trendline in Excel: How to Add and InterpretTo add a power trendline in Excel for Microsoft 365 on Windows, select an XY (Scatter) chart, then choose Chart Design >…
- Power Pivot in Excel: What It Does and How to Use ItPower Pivot is Excel’s data-modeling feature: it lets you connect and relate multiple tables, create calculations with the DAX language, and analyze…
- Power Pivot in Excel 2016: Setup, Models, and TipsPower Pivot is Excel 2016’s data-modeling add-in for combining tables, defining relationships, and analyzing larger datasets with PivotTables. On Windows, you can…
- Power Pivot in Excel 365: What It Does and How to Use ItYes—Power Pivot is available in Excel for Microsoft 365 for Windows when your Excel license includes the feature. It lets you build…
- Power BI Excel Dashboard: How to Build and Connect OneYes. You can build a Power BI report or dashboard from Excel data by importing an Excel workbook into Power BI Desktop,…
- Power BI and Excel Pivot Tables: How They Work TogetherYes—you can analyze a Power BI semantic model with an Excel PivotTable by using Power BI’s Analyze in Excel connection. The PivotTable…
- Power Automate Refresh Excel Pivot Tables: How It WorksYes—Power Automate can refresh Excel PivotTables by running an Office Script on a workbook stored in OneDrive for Business or SharePoint. There…
- Portfolio Slicer in Excel: Build an Interactive DashboardA portfolio slicer in Excel is a clickable filter for a PivotTable or Excel table, letting you narrow holdings by fields such…
- Pivot Table Excel Data Analysis: A Practical GuideA PivotTable in Excel summarizes and explores a dataset without changing its original rows. To create one in Microsoft 365 for Windows,…
- Excel Histogram Overflow Bin: Set and Interpret ItIn an Excel histogram, the overflow bin groups values above a cutoff you choose into one final bar. To set it in…