Charts & pivot tables
Build, format and fix charts and pivot tables.
- Edit Legend in Excel Line Charts: Names, Position, and StyleTo edit a legend in an Excel line chart, select the chart and go to Chart Design > Select Data. Under Legend…
- EBITDA Waterfall Chart in Excel: Build It Step by StepTo make an EBITDA waterfall chart in Excel, list opening EBITDA, each positive or negative driver, and closing EBITDA in two columns;…
- Edit a Gantt Chart in Excel: Dates, Tasks, and BarsYes. To edit a Gantt chart in Excel, change the task names, start dates, finish dates, or durations in the worksheet that…
- Excel Histogram: Easy Steps to Create and Format OneTo make an Excel histogram, put your numeric observations in one column, select the data, then choose Insert > Insert Statistic Chart…
- Dual Axis Line Chart in Excel: Create and Format ItTo make a dual axis line chart in Excel for Microsoft 365 on Windows, select your data, then choose Insert > Insert…
- Dynamic Pie Chart in Excel: Build One That UpdatesA dynamic pie chart in Excel updates when its source data changes. For a chart that grows as you add records, format…
- Dual Axis Combo Chart in Excel: Create and Format ItIn Excel for Microsoft 365 on Windows, select your data, choose Insert > Insert Combo Chart > Create Custom Combo Chart, assign…
- Excel Gantt Charts: What’s Built In and How to Make OneExcel does not include a dedicated Gantt chart type, but you can make a Gantt chart with its stacked bar chart tools…
- Does Excel Have a Gantt Chart Template? How to Use ItYes. Excel has Gantt chart templates you can find through its template gallery or Microsoft Create, although the available choices can vary…
- Excel Sparklines: How to Display High and Low PointsYes. In Excel for Microsoft 365 on Windows, select a sparkline, open the contextual Sparkline tab, and in the Show group check…
- Pie Chart Formula for Percentages and AnglesThe key pie-chart formulas are straightforward: a slice’s share is its category value divided by the total of all category values; its…
- Delta Pivot Chart in Excel: Meaning and How to Build OneA “Delta PivotChart” is not a separate, built-in Excel chart type. It usually means a PivotChart that displays the change, or delta,…
- Delete a Trendline in Excel Without Removing the ChartTo delete a trendline in Excel for Microsoft 365 on Windows, click the trendline in the chart to select it, then press…
- Pivot Chart Definition, Uses, and How It WorksA PivotChart is an interactive chart linked to a PivotTable that summarizes and displays data by categories, measures, and filters. In Excel,…
- Excel Waterfall Chart Data Format: Examples and SetupFor an Excel waterfall chart, use one column for category labels and one column for numeric changes, with one item per row.…
- Data Pivot Chart: Meaning, Uses, and How It Works in ExcelA data pivot chart—usually called a PivotChart in Microsoft Excel—is an interactive chart linked to a PivotTable. It summarizes a larger data…
- Excel Dashboard: Build a Useful Interactive ReportYes—you can build an interactive dashboard in Microsoft Excel by organizing data in a table, summarizing it with PivotTables, and presenting the…
- Creating a Pie Chart in Excel: Steps, Labels, and TipsTo create a pie chart in Excel for Microsoft 365 on Windows, arrange category names beside their values, select both columns, then…
- Create a Pivot Chart in Excel: Step-by-Step GuideTo create a PivotChart in Excel for Microsoft 365 on Windows, select a cell in your data, choose Insert > PivotChart, confirm…
- Creating a Waterfall Chart in Excel: A Step-by-Step GuideTo create a waterfall chart in Excel for Microsoft 365 on Windows, put each step of the change in one column and…
- Create a Horizontal Line in an Excel Chart: MethodsTo create a horizontal line in an Excel chart, add another data series whose value is the same for every category, then…
- Create a Line Chart in Excel with Two Data SetsTo create a line chart from two data sets in Excel for Microsoft 365 on Windows, arrange the shared time points or…
- Create a Gantt Chart in Excel with a Pivot Table?Yes—but a PivotTable does not have a built-in Gantt view. In Excel for Microsoft 365 on Windows, summarize task start dates and…
- Create an Excel Dashboard With Free AI ToolsYes—you can create an Excel dashboard with free AI tools by asking a free AI assistant to help plan the layout, explain…
- Excel Pie Chart: Display Percentages on Your ChartTo create an Excel pie chart that shows percentages, select the category names and values, choose Insert > Insert Pie or Doughnut…
- Create an Excel Dashboard With AI: A Practical GuideYes. To create an Excel dashboard with AI, prepare clean, column-based data, ask Microsoft Copilot or another AI assistant to suggest useful…
- Create a Line Chart in Excel: A Step-by-Step GuideTo create a line chart in Excel for Microsoft 365 on Windows, arrange your data in columns or rows with time periods…
- Create a Pivot Chart in Excel: A Step-by-Step GuideTo create a PivotChart in Microsoft Excel for Microsoft 365 on Windows, select a cell in your data, choose Insert > PivotChart,…
- Create a Combo Chart in Excel: Steps and TipsTo create a combo chart in Excel for Microsoft 365 on Windows, select your data, choose Insert > Insert Combo Chart, and…
- Create a Gantt Chart in Excel: A Practical Step-by-Step GuideTo create a Gantt chart in Excel, list each task, its start date, and its duration, then insert a stacked bar chart…