Charts & pivot tables
Build, format and fix charts and pivot tables.
- Parabolic Trendline in Excel: How to Add and Use ItTo add a parabolic trendline in Excel for Microsoft 365 on Windows, select an XY scatter chart’s data series, choose Chart Design…
- Office Excel Dashboard Templates: How to ChooseOffice Excel dashboard templates are ready-made workbooks that organize key measures, charts, and filters on a summary sheet. In Excel for Microsoft…
- No Power Pivot in Excel? How to Find or Enable the Add-inIf Power Pivot is missing in Excel, first check that you are using a supported edition of Excel for Windows; then enable…
- Excel Trendline: Where to Find It and How to Add OneYes—Excel has a trendline option, but it appears only for supported chart types. In Excel for Microsoft 365 on Windows, select the…
- MS Excel Scatter Plot: Create and Interpret XY ChartsTo make a scatter plot in Microsoft Excel for Microsoft 365 on Windows, arrange each observation’s X value and Y value in…
- MS Excel Dashboard: How to Build, Design, and Use OneAn MS Excel dashboard is a single worksheet that turns data into an at-a-glance view of important measures, trends, and comparisons. You…
- Excel Histogram: How to Create and Customize OneTo make a histogram in Excel for Microsoft 365 on Windows, select a single column of numeric data, then choose Insert >…
- Excel Dashboard: How to Build One Step by StepTo make an Excel dashboard, first organize your source data in a consistent table, decide which measures matter, then summarize the data…
- Manpower Histogram in Excel: Build a Staffing ChartA manpower histogram in Excel is a time-based chart showing how many people—or how much labor capacity—you need during each day, week,…
- Linear Trendline in Excel: Add, Read, and Use ItTo add a linear trendline in Excel for Microsoft 365 on Windows, select a chart, then choose Chart Design > Add Chart…
- Power Pivot KPIs in Excel: Create, Edit, and Switch ViewsTo switch what a Power Pivot KPI shows in an Excel PivotTable, expand the KPI in the PivotTable Fields pane and add…
- Line Sparklines in Excel: How to Create and Format ThemTo add a line sparkline in Excel for Microsoft 365 on Windows, select the cell where it should appear, choose Insert >…
- KPI Dashboard Excel Template: Free Options OnlineYes. You can find free KPI dashboard Excel templates online from sources such as Microsoft’s template gallery and spreadsheet-template publishers, then download…
- Kenji Excel Dashboard: What It Means and How to Build OneThere is no standard Microsoft Excel feature officially called a “Kenji dashboard.” If Kenji refers to a person, team, or project, the…
- Interactive Excel Dashboard: How to Build OneYes. In Microsoft Excel for Microsoft 365, a practical interactive dashboard usually combines a clean source table, PivotTables or formulas, charts, and…
- Jira Dashboard to Excel: How to Export Useful DataThere usually isn’t a one-click way to turn an entire Jira dashboard into an Excel workbook. Instead, export the issues behind a…
- Insert Line Sparklines in Excel: Steps, Tips, and UsesTo insert a line sparkline in Excel for Microsoft 365 on Windows, select the cell or cells where the mini charts should…
- Excel Power Pivot Incremental Load: What WorksExcel Power Pivot does not have a built-in incremental refresh policy that keeps old rows and imports only new or changed rows.…
- How to Zoom In on a Scatter Plot in Excel: Axis ScalingTo zoom in on a scatter plot in Excel, change the horizontal (X) and vertical (Y) axis bounds so they show a…
- Column Sparklines in Excel: Create and Format ThemTo create column sparklines in Excel, select the empty cell or cells where you want the tiny charts, choose Insert > Sparklines…
- How to Update Sparklines in ExcelTo update sparklines in Excel, change the cells they summarize; the mini charts normally recalculate automatically. To include a different range, select…
- How to Switch X and Y Axis in an Excel HistogramExcel’s built-in Histogram chart does not have a direct command to swap its horizontal and vertical axes. To put the bins on…
- How to Put Sparklines in ExcelTo put sparklines in Excel, select the blank cell or cells where you want the mini charts, choose Insert > Sparklines, select…
- How to Make a Quadratic Trendline in an Excel ChartTo make a quadratic trendline in Excel, create an XY (Scatter) chart from paired numeric data, select the chart, then choose Chart…
- Extend a Trendline to the Y-Axis in ExcelTo extend a trendline to the y-axis in Excel, select the trendline, open Format Trendline, and increase Forecast > Backward until the…
- How to Edit Sparklines in Excel: Data, Style, and AxesTo edit a sparkline in Excel, select its cell and use the contextual Sparkline tab to change its data range, chart type,…
- How to Enter Sparklines in Excel and Format Them EasilyTo enter a sparkline in Excel, select the cell where you want the mini chart, choose Insert > Sparklines > Line, Column,…
- How to Add a Quadratic Trendline to an Excel ChartTo add a quadratic trendline in Excel for Microsoft 365 on Windows, create or select an XY (Scatter) chart, then choose Chart…
- How to Add Column Sparklines in Excel: Quick GuideTo add a column sparkline in Microsoft Excel for Microsoft 365 on Windows, select the cell where it should appear, choose Insert…
- Histogram With 2 Variables in Excel: Create a 2D ViewExcel’s built-in Histogram chart handles one variable at a time, so it cannot directly make a histogram from two variables. To show…