Charts & pivot tables
Build, format and fix charts and pivot tables.
- How to Change Line Color in Excel Charts and ShapesTo change a chart line in Excel for Microsoft 365 on Windows, select the line, right-click it, choose Format Data Series, then…
- How to Change a Column Name in an Excel ChartTo change a column name shown in an Excel chart, rename the chart’s data series: select the chart, go to Chart Design…
- How to Change Chart Area in Excel: Color, Border, and SizeTo change a chart area in Excel, select the chart, right-click its outer background, choose Format Chart Area, then adjust the fill…
- How to Center Bars in an Excel ChartTo center bars within their category spaces in Excel, select the chart’s category axis, open Format Axis, and set Axis position to…
- Center Bar Graphs in Excel: Align Bars and ChartsTo center a bar graph in Excel, first decide whether you mean the whole chart object or the bars inside its plot…
- Pareto Chart in Excel: How to Calculate and Build OneTo calculate a Pareto chart in Excel, arrange your categories and counts, sort the counts from largest to smallest, calculate each category’s…
- How to Build a KPI Dashboard in ExcelTo build a KPI dashboard in Excel, put clean, consistently defined measures in a structured data table, calculate the key metrics with…
- How to Build a Thermometer Chart in Excel: Step by StepTo build a thermometer chart in Excel, put the completed amount and the amount remaining in a two-series table, insert a 2-D…
- How to Build a Treemap Chart in Excel Step by StepTo build a treemap chart in Excel, arrange your categories in one or more columns and their numeric values in the last…
- Excel Speedometer Chart: Build a Gauge Step by StepTo build a speedometer chart in Excel, make a doughnut chart from your gauge ranges, hide its lower half, then overlay a…
- How to Build a Radar Chart in Excel: A Practical GuideTo build a radar chart in Excel, arrange categories in the first column and each data series in its own column, select…
- How to Build a Funnel Chart in Excel: Step-by-StepTo build a funnel chart in Excel for Microsoft 365 on Windows, arrange process stages in one column and their values in…
- How to Build a Bubble Chart in Excel: A Step-by-Step GuideTo build a bubble chart in Excel, arrange each observation’s X value, Y value, and bubble-size value in separate numeric columns, select…
- How to Apply an Outline to a Chart Area in ExcelTo outline a chart in Excel for Microsoft 365 on Windows, right-click the chart’s outer background, choose Format Chart Area, open Fill…
- How to Align a Flow Chart in Excel with Shape ToolsTo align a flow chart in Excel, select the shapes you want to arrange, then use Shape Format > Align to line…
- How to Align a Data Table With a Chart in Microsoft ExcelTo place a data table directly beneath an Excel chart, select the chart and choose Chart Design > Add Chart Element >…
- How to Add Superscript in an Excel Chart LegendTo add superscript to an Excel chart legend, put the appropriate Unicode superscript character in the chart’s series name, then use that…
- How to Add a Line in an Excel Org ChartTo add a reporting line in an Excel org chart, select the employee’s box and use SmartArt Design > Add Shape to…
- How to Add a Funnel Chart in Excel: Steps and TipsTo add a funnel chart in Excel for Microsoft 365 on Windows, put each process stage in one column and its value…
- How to Add an Average Line to an Excel Chart: StepsTo add an average line to an Excel chart, calculate the average in a helper column, repeat that result beside each chart…
- Add an Average Line to a Bar Graph in Excel: StepsTo add an average line to a bar graph in Excel, calculate the average in a worksheet cell, repeat that value in…
- Excel Org Chart: How to Add a Relationship Line CorrectlyTo add a relationship in an Excel org chart, first decide whether you mean a reporting link or an additional connection between…
- How to Add an 80% Reference Line to a Pareto Chart in ExcelTo add an 80% line to a Pareto chart in Excel, calculate a cumulative percentage and create a second series containing 80%…
- Excel Funnel Chart: How to Create, Format, and Fix OneTo make a funnel chart in Excel for Microsoft 365 on Windows, put process stages in one column and their values in…
- How to Create a Bubble Chart in ExcelTo create a bubble chart in Excel for Microsoft 365 on Windows, arrange your data in three numeric columns—X values, Y values,…
- How to Make a Thermometer Chart in ExcelTo make a thermometer chart in Excel for Microsoft 365 on Windows, enter a completion value and the amount remaining in two…
- Hourly Gantt Chart Template Excel: Plan by the HourYes—an hourly Gantt chart template in Excel can be built with one row per task, one column per hour, and conditional formatting…
- How to Create a Funnel Chart in ExcelTo create a funnel chart in Excel for Microsoft 365 on Windows, arrange process stages in one column and their values in…
- Horizontal Funnel Chart in Excel: How to Make OneExcel’s built-in Funnel chart is vertical, so it does not directly create a horizontal funnel. To make a horizontal version in Microsoft…
- High-Level Gantt Chart Excel Template: Build a Clear ViewA high-level Gantt chart in Excel is a short project schedule that shows major phases or deliverables against a calendar, rather than…