Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Pie Chart From One Column: What You Need to KnowYes. In Excel for Microsoft 365 on Windows, select a column of numeric values, then choose Insert > Insert Pie or Doughnut…
- Excel Pivot Chart Pareto: Build and Read OneYes—but Excel cannot create a Pareto chart as a native PivotChart. The practical workaround is to build a PivotTable, sort its categories…
- Excel Pivot Chart Stacked Column: How to Create OneTo create a stacked column PivotChart in Microsoft Excel for Microsoft 365 on Windows, click inside a PivotTable, choose PivotTable Analyze >…
- Excel Pareto Chart: Show the Cumulative PercentageYes. Excel’s built-in Pareto chart includes a line for cumulative percentage, usually plotted against a percentage scale on the right side of…
- Excel Pareto Chart Data Labels: Add and Format ThemTo show data labels on a Pareto chart in Excel for Microsoft 365 on Windows, select the chart, then choose Chart Design…
- Excel Pareto Chart from PivotTable: How to Build OneExcel for Microsoft 365 on Windows cannot make a true Pareto chart directly as a PivotChart. Instead, summarize and sort your data…
- Excel Overlapping Pivot Table Error: How to Fix ItExcel’s overlapping PivotTable error means a PivotTable is trying to occupy cells already used by another PivotTable on the same worksheet. Move…
- Excel Org Chart From a Table: Build It Step by StepYes, you can make an org chart from employee data in Excel, but Excel does not automatically turn a normal table into…
- Excel: Move X-Axis Labels to the Bottom of a ChartTo move Excel chart labels to the bottom, select the horizontal (x) axis, open Format Axis, then under Axis Options > Labels,…
- Excel: How to Move a Pie Chart Within the Chart AreaTo move a pie chart within its chart frame in Excel for Microsoft 365 on Windows, select the chart, click the blank…
- Excel Pie Chart from a Column: Steps and TipsTo make a pie chart in Excel, select a numeric column and choose Insert > Insert Pie or Doughnut Chart > 2-D…
- Excel Line Chart With Shaded Area: How to Make OneTo make an Excel line chart with a shaded area beneath the line, create a combo chart from two copies of the…
- Excel Line Chart With Area: Add Shading and Keep the LineTo put shaded area under an Excel line, change the chart to an Area chart, or make a combo chart with an…
- Excel KPI Dashboard Examples and How to Build ThemUseful Excel KPI dashboard examples include a sales dashboard for revenue and quota attainment, a support dashboard for response time and resolution,…
- Excel Speedometer Chart: How to Create a GaugeExcel for Microsoft 365 does not include a built-in speedometer chart type. You can make a semicircular gauge by inserting a doughnut…
- Excel Horizontal Bullet Chart: Build One Step by StepTo make a horizontal bullet chart in Excel for Microsoft 365 on Windows, create a stacked bar chart from the target scale’s…
- Excel High-Low-Close Chart: Create and Format OneIn Excel for Microsoft 365 on Windows, arrange your data in columns as Date, High, Low, and Close, select the range, then…
- Excel Grouped Stacked Bar Chart: How to Create OneExcel does not offer a built-in chart type that combines clustered bars with stacked segments. You can create the same visual by…
- Excel Area Chart: How to Create and Format OneTo create an area chart in Excel for Microsoft 365 on Windows, select your data, then choose Insert > Insert Line or…
- Excel Stacked Bar Chart: How to Create and Read OneTo make a stacked bar chart in Excel for Microsoft 365 on Windows, select your category labels and series data, then choose…
- Excel Funnel Chart Multiple Series: Limits and OptionsNo: Excel’s built-in funnel chart is designed to show one data series across a set of stages, not several parallel series in…
- Excel Funnel Chart: Can You Compare Two Data Series?No—not as two independently comparable funnels in one standard Excel funnel chart. Excel’s built-in funnel chart is designed to show one value…
- Excel Funnel Chart Data Labels Not Showing? FixesTo show labels on an Excel funnel chart, select the chart, then choose Chart Design > Add Chart Element > Data Labels…
- Excel Format Chart Area Size Greyed Out? FixesIn Excel for Microsoft 365 on Windows, a greyed-out chart-area size control usually means Excel is not treating the selected element as…
- Excel Format Chart Area Greyed Out? Causes and FixesIf Format Chart Area is greyed out in Excel, first select the actual chart and then its outer chart area; the control…
- Excel Floating Stacked Bar Chart: How to Build OneTo make a floating stacked bar chart in Excel for Microsoft 365 on Windows, create a stacked bar chart with two series:…
- Excel Find Pivot Table Names: Where to LookTo find a PivotTable’s name in Excel for Microsoft 365 on Windows, click any cell inside it, open PivotTable Analyze, and read…
- Excel Average for Every 5-Unit X-Axis RangeTo find the average Y value in each 5-unit X-axis range in Excel, put the X values in A2:A100, the Y values…
- Excel Pivot Table: How to Filter by a List of ValuesFor a quick filter, open the PivotTable field’s drop-down, clear Select All, check the values you want, and click OK; for a…
- Excel Doughnut Chart With a Total in the Center ExplainedYes. In Excel for Microsoft 365 on Windows, create a doughnut chart, calculate the total in a worksheet cell, then place a…