Charts & pivot tables
Build, format and fix charts and pivot tables.
- Histogram in Excel: Video Guide and StepsIf you’re looking for a histogram Excel video, the essential steps in Microsoft 365 for Windows are to select a column of…
- Histogram Excel Formula: FREQUENCY, Bins, and Chart SetupIn Microsoft Excel for Microsoft 365, the core histogram formula is =FREQUENCY(A2:A13,C2:C6): with observations in A2:A13 and bin upper limits in C2:C6,…
- Heat Map Legend in Excel: Create, Read, and Fix the ScaleExcel does not automatically add a legend to a heat map made with Conditional Formatting color scales. To explain the colors, create…
- Enable Power Pivot in Excel: Steps, Versions, and FixesTo enable Power Pivot in Excel for Microsoft 365 on Windows, go to File > Options > Add-ins, choose COM Add-ins in…
- Gold Data Excel Dashboard: Build and Track Gold PricesA gold data Excel dashboard is a workbook that organizes gold-price data and presents key figures—such as the latest recorded price, daily…
- Frequency Histogram in Excel: Create and Interpret OneTo make a frequency histogram in Excel for Microsoft 365 on Windows, select your numeric data, then choose Insert > Insert Statistic…
- Free Excel Dashboard Templates XLS: Find and Use ThemYes—free Excel dashboard templates are available to download, but many are offered as .xlsx files rather than the older .xls format. Look…
- Format Trendline in Excel: Steps and OptionsTo format a trendline in Excel for Microsoft 365 on Windows, select the chart, choose Chart Design > Add Chart Element >…
- Financial Dashboard in Excel: Build, Track, and AnalyzeA financial dashboard in Excel is a workbook page that summarizes important financial measures—such as revenue, expenses, profit, and cash flow—in one…
- Export Jira Dashboard to Excel: What Works and HowYou generally cannot export an entire Jira dashboard, with all its gadgets and charts, directly to an Excel workbook using a single…
- Excel Yin Yang Dashboard: Build a Balanced ViewAn Excel yin yang dashboard is a custom workbook that uses the yin-yang idea of balance to present two related measures or…
- Excel Win-Loss Sparklines: Setup, Reading, and UsesYes—Excel for Microsoft 365 on Windows has a built-in Win/Loss sparkline that summarizes positive, negative, and zero values as compact marks inside…
- Excel Visual Dashboard: Build, Design, and Maintain OneAn Excel visual dashboard is a compact, interactive view of important data, built from elements such as charts, summary numbers, PivotTables, and…
- Excel Trendline Formula: How to Show and Use It in ChartsTo show a trendline formula in an Excel chart, select the chart, choose Chart Design > Add Chart Element > Trendline >…
- Excel Trendline Equation in a Cell: How to Calculate ItYes. For a linear trendline, calculate its slope and intercept in worksheet cells, then use those values to predict results; Excel does…
- Excel Trendline Values: Show, Calculate, and Use ThemIn Excel, trendline values are the estimated y-values produced by a trendline for particular x-values. To see a trendline equation on a…
- Excel Trendline Significant Digits: Set Equation PrecisionIn Excel for Microsoft 365 on Windows, change the digits shown in a trendline equation by selecting the equation label, opening Format…
- Excel Trendline Slope Formula: Find and Interpret ItIf your x-values are in A2:A6 and your y-values are in B2:B6, calculate the linear trendline slope in Excel with =SLOPE(B2:B6,A2:A6). The…
- Excel Trendline Is Wrong? How to Check and Fix ItAn Excel trendline can look wrong even when Excel has calculated it correctly: the chart may be using the wrong kind of…
- Excel Trendline: Show More Significant FiguresTo show more digits in an Excel trendline equation, select the equation on the chart, open Format Trendline Label, expand Number, choose…
- Excel Trendline: Increase Decimal PlacesTo increase the decimal places in an Excel trendline equation, select the equation label on the chart, right-click it, choose Format Trendline…
- Excel Trendline Intercept: Meaning and How to Set ItIn Excel, a trendline intercept is the estimated y-value where the trendline crosses the vertical axis, which is the value of y…
- Excel Trendline in a Cell: Formulas and Practical MethodsYes. To calculate a linear trendline in a worksheet cell, use Excel’s TREND function: with known x-values in A2:A6, known y-values in…
- Excel Trendline Function: Charts and TREND FormulasExcel does not have a worksheet function named TRENDLINE. To draw a trendline, select a chart and choose Chart Design > Add…
- Excel Trendline Greyed Out? Causes and FixesIf Excel’s trendline option is greyed out, first select a plotted data series—not just the chart background—and check that the chart type…
- Excel Trendline Formula in a Cell: Methods and ExamplesYes. To calculate a linear trendline estimate in an Excel cell, use FORECAST.LINEAR or calculate the slope and intercept yourself. With x-values…
- Excel Trendline Formula Wrong? Check These CausesUsually, an Excel trendline formula is not wrong: the equation displayed on the chart is rounded, or the chart is fitting different…
- 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…