Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Series Trendline: Add, Choose, and Interpret OneTo add a trendline to a data series in Excel for Microsoft 365 on Windows, select the chart, then choose Chart Design…
- Excel Trendline Equation Wrong? Check These CausesUsually, an Excel trendline equation only looks wrong: the chart label rounds its coefficients, or the chart is fitting a different set…
- Add a Trendline in Excel for the Web: Step-by-StepTo add a trendline in Excel for the web, select a supported chart, open the Chart tab, choose Add Chart Element >…
- Excel Quadratic Trendline: Add, Interpret, and Check FitTo add a quadratic trendline in Excel for Microsoft 365 on Windows, create an XY scatter chart, select a data series, then…
- Excel Remove Trendline: Steps, Effects, and FixesTo remove a trendline in Excel for Microsoft 365 on Windows, select the chart, then choose Chart Design > Add Chart Element…
- Excel Trendline: How to Ignore Zero ValuesExcel has no built-in setting to make a trendline ignore zero values, but you can exclude them from the chart series with…
- How to Make a Histogram in Excel With Custom BinsTo make a histogram in Excel, select your numeric data, choose Insert > Insert Statistic Chart > Histogram, then right-click the horizontal…
- Create a Pivot Table in Excel 2019: Step-by-StepTo create a PivotTable in Excel 2019, select a cell in a clean data range, choose Insert > PivotTable, confirm the range…
- Probability Histogram in Excel: A Step-by-Step GuideTo make a probability histogram in Excel, divide your numeric data into bins, count the observations in each bin, divide each count…
- How to Make a Proper Histogram in Excel: Step by StepTo make a proper histogram in Excel, put one set of numeric measurements in a column, select the data, then choose Insert…
- Resource Histogram in Excel: Build One Step by StepTo make a resource histogram in Excel, organize allocated work by time period and resource, summarize the totals in a grid, then…
- How to Make a Good Histogram in Excel: A Step-by-Step GuideTo make a good histogram in Excel, put your numeric measurements in one column, select the values, then choose Insert > Insert…
- How to Make a Histogram Start at 0 in ExcelTo make histogram bins start at 0 reliably in Excel, create bin intervals beginning at 0, count the values in each interval,…
- Histogram in Excel: How to Create One From Your DataTo make a histogram in Excel, put your raw numeric observations in one column, select the values, then choose Insert > Insert…
- Histogram in Excel: How to Create and Customize OneYes. In Excel for Microsoft 365 on Windows, select your numeric data, then choose Insert > Insert Statistic Chart > Histogram. Excel…
- Creating a Histogram in Excel: Steps, Bins, and TipsTo create a histogram in Microsoft Excel for Microsoft 365 on Windows, select your numeric data, then choose Insert > Insert Statistic…
- Excel Histogram: Create One from a Column of DataYes. In Microsoft Excel for Microsoft 365 on Windows, select the numeric values in your column, then choose Insert > Insert Statistic…
- How to Make a Graph in Excel With Two Variables EasilyTo graph two numerical variables in Excel, put each variable in its own column, select the paired data, then choose Insert >…
- How to Make a Graph in Excel with Multiple Data SeriesTo make a graph in Excel with multiple data series, arrange each series in its own column or row, include a label…
- How to Make a Line Graph in Excel With Data in a Few StepsTo make a line graph in Excel, arrange your data in columns with time periods or other categories in the first column…
- How to Make Charts in Excel Dynamic as Data ChangesTo make a chart update as your data changes, turn the source range into an Excel Table, then create the chart from…
- How to Make Charts Wider in Excel Without DistortionTo make a chart wider in Excel, select the chart and drag a middle sizing handle on its left or right edge;…
- How to Make a 4-Quadrant Graph in ExcelTo make a 4-quadrant graph in Excel, plot your paired X and Y values in an XY scatter chart, then add one…
- How to Calculate an Average in an Excel Pivot TableTo calculate an average in an Excel PivotTable, add the numeric field you want to average to the Values area, open that…
- Clear an Excel Pivot Table: Filters, Data, or Table?To clear a PivotTable in Excel for Microsoft 365 on Windows, click inside it and choose PivotTable Analyze > Clear > Clear…
- Aggregate Excel Pivot Tables: Methods and ExamplesTo aggregate data in an Excel PivotTable, select a clean source range, choose Insert > PivotTable, and place a field in Values.…
- Excel Pivot Table Subtotals: How to Show, Change, and Fix ThemIn Excel for Microsoft 365 on Windows, select a cell in the PivotTable and choose PivotTable Design > Subtotals to show subtotals…
- Unique Excel Charts: Types, Uses, and How to Build ThemExcel does not have a chart type officially called a “unique chart,” but it does offer distinctive chart types that go beyond…
- Excel Pivot Table Unique Count: How to Get ItYes—Excel can count unique values in a PivotTable. In Excel for Microsoft 365 on Windows, create the PivotTable with Add this data…
- Excel Pivot Table: Sort Months ChronologicallyYes. To sort months chronologically in an Excel PivotTable, use a real date field and group it by Months (and Years when…