Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Trendline for a Specific Range: How to Set It UpExcel does not let you tell a trendline to use an arbitrary subset of points within a chart series: by default, it…
- Excel Trendline Formula: Find, Read, and Calculate ItAn Excel trendline formula is the equation Excel fits to data in a chart; for a linear trendline, it describes the relationship…
- Excel Trendline Equation: Show More Decimal PlacesTo show more decimal places in an Excel trendline equation, select the equation label, open Format Trendline Label, and use the Number…
- Excel Trendline for Part of Data: Steps and OptionsExcel applies a trendline to a chart series, not to a hand-selected handful of points within a series. To fit only part…
- Excel Trendline for Part of a GraphTo add a trendline to only part of an Excel graph, make a helper data series containing values for the section you…
- Excel Trendline Equation in a Cell: How to Get ItYes—but Excel does not put a chart’s trendline equation into a worksheet cell automatically. For a linear trendline, calculate its slope and…
- Excel Trendline Equation: How to Get It From Data in ExcelTo get an Excel trendline equation from data, make a chart, select its data series, and add a trendline. In Excel for…
- Excel Trendline Equation: Formula and How to Use ItIn Excel, a linear trendline is described by y = mx + b: m is the slope and b is the y-intercept.…
- Excel Trendline Data Labels: Add, Format, and Fix ThemIn Excel for Microsoft 365 on Windows, select the chart, choose Chart Design > Add Chart Element > Trendline > More Trendline…
- Excel Trendline Definition: Meaning, Types, and UsesAn Excel trendline is a line or curve added to a chart to summarize the general direction or pattern of a data…
- Excel Trendline Equation Doesn’t Match Data?If an Excel trendline equation seems not to match your data, first check whether the chart label has rounded the coefficients; then…
- Excel Trendline Average: What It Means and How to Use ItIn Excel, a trendline is not necessarily an average: most trendlines model the overall direction of data, while the chart’s Moving Average…
- Excel Spreadsheet Histogram: How to Create, Read, and Fix ItTo make a histogram in Excel for Microsoft 365 on Windows, select a column of numeric observations, then choose Insert > Insert…
- Excel Sparklines Greyed Out? Causes, Fixes, and LimitsIf Excel’s Sparkline commands are greyed out, first exit cell-edit mode, select a normal worksheet cell, and check whether the sheet is…
- Excel Sparklines Formula: How to Create and Customize ThemExcel does not have a worksheet formula called SPARKLINE: a sparkline is a small chart inserted into a cell, not a formula…
- Excel Sparklines from PivotTables: How to Add ThemYes. In Excel for Microsoft 365 on Windows, you can create sparklines from numeric cells in a PivotTable: select blank cells outside…
- Excel Sparklines: Customize Their Look, Color, and ScaleExcel sparklines can be customized by changing their type, color, markers, axis scale, and how they display missing or hidden data. Select…
- Excel Sparklines in German: Create and Format ThemIn German-language Excel, sparklines are still called Sparklines: small charts placed inside worksheet cells to show a data trend at a glance.…
- Excel Slicer Not Showing All Pivot Tables? Here’s WhyAn Excel slicer only lists PivotTables that are compatible with it, usually because they share the same PivotCache or Data Model connection.…
- Excel Slicers for Multiple Pivot Tables: How to ConnectYes. In Excel for Microsoft 365 on Windows, select the slicer, choose Slicer > Report Connections (called PivotTable Connections in some versions),…
- Excel Trendline Values: Show and Calculate ThemYes. In Excel for Microsoft 365 on Windows, select the chart, choose Chart Design > Add Chart Element > Trendline > More…
- Excel Sheet Dashboard: What It Is and How to Build One EasilyAn Excel sheet dashboard is a compact, visual summary of important data—such as sales, expenses, or project status—built in a worksheet so…
- Excel Scatter Plot X Axis Wrong? Find and Fix the CauseIf an Excel scatter plot’s x-axis is wrong, first check the series’ X values: select the chart, choose Chart Design > Select…
- Excel Scatter Plot X-Axis Labels: Set or Change ThemIn Excel for Microsoft 365 on Windows, change a scatter plot’s horizontal values by selecting the chart, choosing Chart Design > Select…
- Excel Scatter Plot X-Axis Text: How to Add LabelsIn Excel, a scatter plot’s x-axis must use numeric values, so it cannot use text categories as ordinary axis positions. To show…
- Excel Scatter Plot With a Categorical X-Axis ExplainedAn Excel XY scatter plot cannot use text categories directly on its x-axis: the horizontal axis is a continuous numeric scale. For…
- Excel Scatter Plot Trendline Equation: How to Show ItTo show an equation on an Excel scatter plot, select the chart and choose Chart Design > Add Chart Element > Trendline…
- Excel Scatter Plot Not Showing the Correct X Axis?If an Excel scatter plot is showing the wrong X axis, select the chart and check the series’ Series X values range…
- Excel Scatter Plot Secondary Y-Axis: Setup and TipsYes. In Excel for Microsoft 365 on Windows, select the scatter-plot data series you want to move, right-click it, choose Format Data…
- Excel Scatter Plot Linear Regression: How to Add a TrendlineTo show a linear regression on an Excel scatter plot, select your numeric X and Y data, choose Insert > Insert Scatter…