Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Histogram Groups: Set and Change Bin SizesExcel histogram groups numerical values into bins—ranges such as 0–10, 10–20, and 20–30—and counts how many observations fall in each range. In…
- Excel Histogram: Change the Number of BucketsTo change the number of buckets in an Excel histogram, select the chart’s horizontal axis, open Format Axis, and under Axis Options…
- Excel Histogram Bin Number: How to Choose ItIn an Excel histogram, the bin number is the number of intervals used to group your numeric data. To change it in…
- Excel Histogram Bin Size: How to Set the Right WidthIn Excel for Microsoft 365 on Windows, select the histogram’s horizontal axis, open Format Axis, and under Axis Options choose either Bin…
- Excel: Hide Columns Without Affecting Your Chart ViewYes. In Excel for Microsoft 365 on Windows, select the chart, go to Chart Design > Select Data > Hidden and Empty…
- Excel Pie Chart: Create, Format, and Fix OneTo make a pie chart in Excel for Microsoft 365 on Windows, select a table with one category column and one numeric-value…
- Excel Gantt Chart Tutorial: Build a Project TimelineTo make a Gantt chart in Excel, list each task with a start date and finish date, place project dates across columns,…
- Excel Gantt Chart With a Today LineYes. For a Gantt chart made from worksheet cells, apply conditional formatting to the date grid so the column for today gets…
- Excel Gantt Chart Template XLS: How to Find or Build OneYes—an Excel Gantt chart template can be opened or built in Excel, but “XLS” is the older Excel file format. For a…
- Excel Gantt Chart Template Monthly: Build One That WorksYes. You can make a monthly Gantt chart template in Excel by listing each task with its start and finish dates, placing…
- Excel Gantt Chart Template Weekly: Build a TimelineYes—a weekly Gantt chart template in Excel can show each task as a bar across a calendar, with one column per week.…
- Excel Gantt Chart Template With DependenciesYes. You can make an Excel Gantt chart template with dependencies by keeping tasks, durations, predecessor IDs, and calculated dates in a…
- Excel Gantt Chart Schedule Template: Build, Format, and UseAn Excel Gantt chart schedule template combines a task list with a dated timeline, then uses conditional formatting to draw a bar…
- Excel Gantt Chart Not Showing All Data? How to Fix ItIf an Excel Gantt chart is not showing all its data, check the chart’s source range, date-axis limits, and filters first; these…
- Excel Gantt Chart Project Plan: Build and Manage ItTo make an Excel Gantt chart project plan, list each task with a start date and duration, put consecutive dates across a…
- Excel Gantt Chart Formula: Build a Timeline BarThe core Excel Gantt chart formula is =AND(H$1>=$B2,H$1<=$C2). Apply it as a conditional-formatting rule to the timeline grid: it colors a cell…
- Excel Fill Area Under a Line Chart: Add Shaded AreaTo fill the area beneath a line in Excel for Microsoft 365 on Windows, create a combo chart with two copies of…
- Excel Extend Trendline Beyond Data Points?Yes. In Excel for Microsoft 365 on Windows, select the chart, choose Chart Design > Add Chart Element > Trendline > More…
- Excel Explode Pie Chart Slice: How to Pull One OutTo explode one slice in an Excel pie chart, click the chart, click the slice a second time to select just that…
- Excel Waterfall Chart Example: Build One Step by StepAn Excel waterfall chart shows how a starting value changes through a series of increases and decreases to reach an ending value.…
- Excel Error Bars in Pivot Charts: Limits and WorkaroundsFor practical purposes, Excel PivotCharts are not a reliable place to add error bars, especially custom error bars tied to a range…
- Excel Chart Data Table: Can You Change Its Text?Yes—but you generally cannot edit values by typing directly into an Excel chart’s data table. In Excel for Microsoft 365 on Windows,…
- Excel Dashboard vs Power BI: Which Should You Choose?Excel is usually the better choice for a small, flexible dashboard built around spreadsheets; Power BI is usually better for interactive reports…
- Excel PivotTable Charts: How to Create and Use ThemTo create an Excel PivotChart in Microsoft 365 for Windows, click a cell in a PivotTable, choose PivotTable Analyze > PivotChart, select…
- Excel Dashboard Best Practices for Clear, Reliable ReportsBuild an effective Excel dashboard by defining the decisions it should support, organizing its source data in a consistent table, and presenting…
- Excel Dashboard Software Examples: Tools, Uses, and LimitsExamples of software used to create dashboards from Excel data include Microsoft Excel, Microsoft Power BI, Tableau, Qlik Sense, and Zoho Analytics.…
- Excel Dashboard Software Tutorial: Build One Step by StepTo build an Excel dashboard, organize your source data in a clean Excel Table, summarize it with PivotTables, then add charts, KPI…
- Excel Custom Combo Chart: How to Build and Format OneAn Excel custom combo chart combines two or more chart types—such as columns and a line—in one chart, so you can compare…
- Excel Dashboard Software Alternatives and How to ChooseExcel dashboard software alternatives include Microsoft Power BI, Tableau, Looker Studio, Qlik Sense, Zoho Analytics, and Metabase. The best fit depends on…
- Excel Line Chart With Multiple Series: A Step-by-Step GuideTo create a line chart with multiple series in Excel for Microsoft 365 on Windows, arrange each series in its own column,…