Charts & pivot tables
Build, format and fix charts and pivot tables.
- Build a Waterfall Chart in Excel: Steps, Tips, and FixesIn Excel for Microsoft 365 on Windows, place each step of the change in one column and its value in the next,…
- Box Plot in Excel: Show Outliers and Read the ChartYes. In Excel for Microsoft 365 on Windows, select your data, choose Insert > Insert Statistic Chart > Box and Whisker, then…
- Box Plot Maker in Excel: Create a Box-and-Whisker ChartExcel has a built-in box plot maker: select your grouped numeric data, then choose Insert > Insert Statistic Chart > Box and…
- Box Plot in Excel: How to Chart Multiple Data SeriesYes. In Excel for Microsoft 365 on Windows, put each group of numeric observations in its own column, select the data, then…
- Box and Whisker Plot Excel X-Axis Labels ExplainedIn Excel for Microsoft 365 on Windows, box-and-whisker plot x-axis labels usually come from the headers above each group of data. Put…
- Best Free Excel Gantt Chart Templates: 5 PicksFor most people, Vertex42’s Gantt Chart Template is the best free Excel Gantt chart template: it gives you a clear date-based schedule…
- Bell Curve Pivot Chart in Excel: Build and Explain ItA PivotChart can summarize your data into bins, but Excel does not provide a one-click bell-curve PivotChart. To show both the observed…
- Best Excel Gantt Chart Templates for Every ProjectFor most projects, the Vertex42 Gantt Chart Template is the best place to start: it gives you a ready-made task-and-timeline layout without…
- Basic Excel Line Chart: Create and Format OneTo make a basic line chart in Microsoft Excel for Microsoft 365 on Windows, arrange time periods in the first column and…
- Bar Chart Maker in Excel: Create and Format ChartsExcel has a built-in bar chart maker: select your category labels and values, then choose Insert > Insert Column or Bar Chart…
- Bar Chart Pivot Table: How to Create and Format in ExcelA bar chart pivot table is a PivotChart that displays summarized PivotTable data as horizontal bars. In Excel for Microsoft 365 on…
- Excel Bar Charts for Civil Construction ProjectsYes. In Excel for Microsoft 365 on Windows, put civil construction categories in one column and the quantities or progress values you…
- Bar Chart in Excel: How to Create and Format OneTo make a bar chart in Excel for Microsoft 365 on Windows, arrange category names in one column and the numbers to…
- Bar Chart in Cell Excel: How to Make OneExcel does not put a standard bar chart inside a worksheet cell, but you can create an in-cell bar effect with Conditional…
- Excel Bar Chart in Descending Order: Sort It CorrectlyTo put an Excel bar chart in descending order, sort the chart’s source data from largest to smallest: select a cell in…
- Bar Chart Examples in Excel: How to Create and ChooseUseful bar chart examples in Excel include comparing sales by product, survey responses by answer, or monthly results across regions. To make…
- Bar Chart Formula in Excel: How to Create OneThere is no special Excel formula that creates a bar chart: a chart is an object you insert from selected data. In…
- Bar Chart by Month in Excel: Create, Format, and ReadTo make a month-by-month chart in Excel, put each month in one column and its value in the next, select the two…
- Bar Chart Construction Schedule in ExcelTo make a construction schedule bar chart in Excel, list each task, its start date, and its duration, then insert a stacked…
- Automated Gantt Chart in Excel: Setup and LimitsYes. In Microsoft Excel for Microsoft 365 on Windows, you can make a Gantt chart update automatically by storing task start and…
- Agile Gantt Chart in Excel: Plan Sprints and ReleasesYes. You can make an Agile Gantt chart in Microsoft Excel by listing work items, adding start and end dates, and using…
- Auto Refresh Pivot Charts in Excel: Setup and LimitsIn Excel for Microsoft 365 on Windows, a PivotChart refreshes when its associated PivotTable refreshes; the chart does not have a separate…
- Add a Zero Line to an Excel Chart: Methods and TipsTo add a zero line to an Excel chart, either make the value axis cross at 0 or add a separate data…
- Add a Trendline to an Excel Bar Chart? Here’s How It WorksYes—Excel for Microsoft 365 on Windows can add a trendline to a supported 2-D bar chart. Select the chart, then choose Chart…
- Add a Trendline to an Excel PivotChart (Workarounds)Excel for Microsoft 365 on Windows does not let you add a trendline directly to a PivotChart. Create a regular chart from…
- Add an Upper Limit Line to an Excel ChartTo add an upper limit line to an Excel chart, create a helper series whose value repeats the limit for every category,…
- Add a Trendline to an Excel Combo Chart: Full GuideTo add a trendline to an Excel combo chart in Microsoft 365 for Windows, select the chart, click the data series you…
- Add a Pivot Chart to an Existing PivotTable in ExcelYes. In Excel for Microsoft 365 on Windows, click a cell inside the existing PivotTable, select PivotTable Analyze > PivotChart, choose a…
- Excel Waterfall Chart: Add and Format a Subtotal BarTo add a subtotal to an Excel waterfall chart, include a row containing the cumulative subtotal in the chart’s source data, then…
- Add a Line to a Waterfall Chart in ExcelExcel for Microsoft 365 does not provide a supported Combo Chart option for adding a data-driven line series directly to its built-in…