Charts & pivot tables
Build, format and fix charts and pivot tables.
- Build an Org Chart From Excel Data: Steps and OptionsYes. You can build an org chart in Excel by choosing Insert > SmartArt > Hierarchy > Organization Chart, then entering employee…
- Build an Org Chart from Excel Data in Microsoft 365To build an org chart from Excel data, first organize each employee on one row with a unique ID and a manager…
- Bubble Chart in Excel: Create, Format, and TroubleshootTo make a bubble chart in Excel for Microsoft 365 on Windows, arrange your data in three numeric columns for X values,…
- Bubble Chart in Excel: Make Each Bubble a Different SizeYes. To make bubbles different sizes in an Excel bubble chart, give each data point its own size value: arrange the data…
- Bubble Chart in Excel: Plot Three Variables ClearlyYes. An Excel bubble chart displays three numeric variables at once: one on the horizontal axis, one on the vertical axis, and…
- Bubble Chart Excel Tutorial: Create, Format, and Read OneTo create a bubble chart in Excel for Microsoft 365 on Windows, arrange each observation in a row with an X value,…
- Bubble Chart in Excel With Four Quadrants: How to Make OneYes. In Excel, make a bubble chart from three data fields—an X value, a Y value, and a bubble-size value—then set the…
- Bubble Chart in Excel: How to Create and Read OneTo create a bubble chart in Excel for Microsoft 365 on Windows, arrange your data in three columns—X values, Y values, and…
- Bubble Chart in Excel: Plot Two Variables and SizeYes, you can make a bubble chart in Excel to plot two variables, but a bubble chart also needs a third numeric…
- Best Excel Chart for Comparing Data: 5 Top OptionsFor most comparisons between categories, the best Excel chart is a clustered column chart: it places values side by side, making differences…
- Basic Gantt Chart Template in Excel: Build One FastA basic Gantt chart template in Excel is a task list paired with a calendar grid, where colored cells show when each…
- Best Design Funnel Chart in Excel: 5 Ways to Build OneFor most Microsoft 365 users, the top pick is Excel’s built-in Funnel chart: it is quick to create, stays linked to your…
- Automatically Create an Org Chart in Excel: What WorksExcel can quickly create an org-chart graphic with SmartArt, but it cannot automatically turn a regular employee table into a chart that…
- Automatic Pareto Chart in Excel: Make One That UpdatesTo make an automatic Pareto chart in Excel for Microsoft 365 on Windows, select a single column of raw category observations, then…
- Excel Chart Area Gradient Fill: How to Apply ItTo apply a gradient fill to a chart area in Excel for Microsoft 365 on Windows, select the chart’s outer background, right-click…
- Area Between Two Lines Chart in Excel: A Clear MethodTo shade the area between two lines in Excel, create helper columns for the lower value and the difference between the two…
- Advanced Gantt Chart Excel Formula: Build a Dynamic PlanAn advanced Gantt chart in Excel is usually built with a date-based conditional-formatting formula, not a single formula that draws the whole…
- Adjust Column Width in Excel Charts and WorksheetsTo make columns wider or narrower in an Excel chart, select a chart column, open Format Data Series, choose Series Options, and…
- Stacked Bar Chart in Excel: How to Add and Format OneTo add a stacked bar chart in Excel for Microsoft 365 on Windows, select a table with category labels and one or…
- Add a Pareto Line to an Excel Bar ChartYes. In Excel for Microsoft 365 on Windows, add a cumulative-percentage column beside your category counts, then use Insert > Combo to…
- Add a Pareto Line to an Excel ChartTo add a Pareto line in Excel, either select your category and count data and choose Insert > Insert Statistic Chart >…
- How to Add a Second Y Axis to an Excel Column ChartTo add a second y-axis to an Excel column chart, select the data series that needs its own scale, open Format Data…
- Add Labels to a Bubble Chart in Excel: Steps and TipsTo add labels to a bubble chart in Excel for Microsoft 365 on Windows, select the chart, choose Chart Design > Add…
- Add a Line to a Clustered Column Chart in ExcelTo add a line to a clustered column chart in Excel, select the chart, choose Chart Design > Change Chart Type >…
- Add Data Labels to a Bubble Chart in Excel with StepsTo add data labels to a bubble chart in Excel for Microsoft 365 on Windows, select the chart, choose Chart Design >…
- Add Error Bars to an Excel Chart: A Practical GuideTo add error bars in Excel for Microsoft 365 on Windows, select the chart, then choose Chart Design > Add Chart Element…
- Add a Column to an Excel Chart: Steps and FixesTo add a column of data as a new series in an Excel chart, select the chart, choose Chart Design > Select…
- 3 Column Chart Template Excel: Three Layouts That WorkIn Excel for Microsoft 365 on Windows, put category labels in column A and three numeric series in columns B through D,…
- 2-D Clustered Column Chart in Excel: How to Make OneTo make a 2-D clustered column chart in Excel for Microsoft 365 on Windows, select your category labels and series data, then…
- Excel Logarithmic Trendline: How to Add and InterpretAn Excel logarithmic trendline is a curve that models how a value changes as the predictor grows by progressively larger amounts, often…