Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel: How to Turn On Power Pivot and Build Data ModelsTo turn on Power Pivot in Excel for Microsoft 365 on Windows, select File > Options > Add-ins. At the bottom, set…
- Excel Trendline Start From a Different Point?Yes. In Excel, a trendline is fitted to a chart series, so to start it at a later point, create a separate…
- Excel Trendline vs. Linear Forecast: Key DifferencesAn Excel linear trendline draws a best-fit straight line on a chart; FORECAST.LINEAR calculates a predicted value in a worksheet cell. Both…
- Excel Trendline Only Some Data Points? Fix ItIn Excel, a trendline is normally calculated for an entire chart series, not for individually selected points. To fit only some data…
- Excel Polynomial Trendline Order: What the Number MeansIn Excel, a polynomial trendline order is its degree: choose order 2 for a quadratic curve, up to order 6 for a…
- Excel to Pie Chart Converter: How to Make a Pie ChartExcel has a built-in pie chart converter: select a category column and its values, then choose Insert > Insert Pie or Doughnut…
- Excel Trendline Equation Without a ChartYes. In Excel for Microsoft 365 on Windows, calculate a linear trendline without creating a chart by using SLOPE and INTERCEPT: they…
- Excel Trendline Error: Causes and FixesIf an Excel trendline will not appear, select a supported chart series and choose Chart Design > Add Chart Element > Trendline…
- Excel Waterfall Chart Template: Build and Customize OneYes. In Excel for Microsoft 365 on Windows, select a category-and-value table, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or…
- Excel Stacked Line Chart ExplainedAn Excel stacked line chart plots each series as a running total of the series before it, rather than showing every series…
- Excel Stacked Bar Chart Combo: Build and Format ItYes, Excel can combine chart types, but a horizontal stacked bar chart paired with a line or another chart type is not…
- Excel Sparklines Tutorial: Create and Format Mini ChartsTo create an Excel sparkline, select the cell where the mini chart should appear, choose Insert > Sparklines > Line, Column, or…
- Excel Sparklines Examples for Sales, Trends, and KPIsExcel sparklines are tiny charts placed inside worksheet cells, useful for showing a trend beside the number it summarizes. In Microsoft 365…
- Excel Sparklines: How to Make Horizontal Bar ChartsExcel for Microsoft 365 does not have a horizontal-bar sparkline type: its built-in sparklines are Line, Column, and Win/Loss. To show horizontal…
- Excel Sparklines Line Chart: How to Add and Format OneIn Excel for Microsoft 365 on Windows, select the data, choose Insert > Sparklines > Line, and specify where the sparkline should…
- Excel Sparklines: Create and Format Column Charts in CellsYes—Excel can make a column sparkline, a compact chart of vertical bars placed inside a worksheet cell. In Microsoft Excel for Microsoft…
- Excel Smooth Line Chart: How to Create and Format OneTo create a smooth line chart in Excel for Microsoft 365 on Windows, select your data, choose Insert > Insert Line or…
- Excel Solid Line Chart: Create and Format OneTo make a solid line chart in Excel for Microsoft 365 on Windows, select your data and choose Insert > Insert Line…
- Excel Slicer vs Pivot Table: What’s the Difference?An Excel PivotTable summarizes and reorganizes data; a slicer is a visual control for filtering a table or PivotTable. They are not…
- Excel Slicer Link to Different Pivot Tables: How It WorksYes. In Excel for Microsoft 365 on Windows, one slicer can filter multiple PivotTables when those PivotTables share a compatible PivotTable cache…
- Excel Sparkline Shortcut: Insert Line, Column, or Win/LossIn Excel for Microsoft 365 on Windows, select the cell where the sparkline should appear, then press Alt, N, S, L for…
- Excel Gantt Chart Template: Build and Customize OneAn Excel Gantt chart template is a worksheet that lays out tasks against dates, then uses colored cells or bars to show…
- Excel Gantt Chart: Build a Timeline from a Task ListYes. In Excel for Microsoft 365 on Windows, make a Gantt chart by putting task names, start dates, and durations in a…
- Excel Scatter Plot With Dates on the X-Axis: Setup TipsTo make an Excel scatter plot with dates on the x-axis, put genuine Excel dates in one column and numeric y-values in…
- Excel Scatter Plot Not Working? Fix Common Chart IssuesIf an Excel scatter plot is blank, misplaced, or showing the wrong points, check that both series ranges contain numeric X and…
- Free Excel Project Gantt Chart Template: How to Use ItYes—free Excel project Gantt chart templates are available, including templates listed through Microsoft Create and downloadable spreadsheets from other providers. Choose a…
- Excel Power Pivot vs Power Query: What’s the Difference?Power Query prepares data by connecting to sources, cleaning it, and reshaping it; Power Pivot builds a data model so you can…
- Excel Power Pivot vs Power BI: Which Fits?Excel Power Pivot is Excel’s data-modeling and analysis feature; Power BI is a broader platform for building, publishing, and sharing interactive reports.…
- Excel Power Pivot Table Tutorial for BeginnersIn Excel for Microsoft 365 on Windows, enable Power Pivot, add your data tables to the workbook Data Model, connect them with…
- Excel Power Pivot vs PivotTable: Differences, Uses, and ChoiceExcel PivotTables summarize and explore data; Power Pivot adds a data-modeling layer for connecting tables, defining relationships, and creating reusable calculations. They…