Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Gantt Chart Schedule: Create and Track ProjectsAn Excel Gantt chart schedule is a task list paired with a date-based timeline, where colored cells show when each task starts…
- Excel Gantt Chart Scrolling Increment and Setup GuideIn Excel, a Gantt chart does not have a built-in scrolling-increment setting. To move a timeline by a chosen amount, add a…
- Excel Gantt Chart Scroll Bar: Setup and TroubleshootingYes. In Excel for Microsoft 365 on Windows, add a Form Control scroll bar and link it to a cell; formulas can…
- Excel Gantt Chart: Exclude Weekends in Your ScheduleYes. To make an Excel Gantt chart exclude weekends, build its timeline from working dates rather than consecutive calendar dates; for a…
- Excel Gantt Chart: Free Templates and How to Make OneYes. You can make a Gantt chart in Excel for free using Excel for the web and a Microsoft account, or start…
- Excel Gantt Chart Sample: Build a Clear Project Timeline FastAn Excel Gantt chart sample is a task list paired with a calendar timeline, where colored cells show when each task starts…
- Excel Gantt Chart Automatic? Setup, Updates, and LimitsYes. In Microsoft Excel for Microsoft 365 on Windows, a Gantt chart can update automatically when you change task dates, provided you…
- Excel Gantt Chart by Month: Build, Format, and UpdateTo make an Excel Gantt chart by month, set up one column for each month and use conditional formatting to shade the…
- Excel Gantt Chart by Week: Build a Weekly TimelineTo make an Excel Gantt chart by week, list each task’s start and finish dates, put consecutive Monday dates across the timeline,…
- Power Pivot SUM Function: Syntax, Examples, and TipsIn Power Pivot, the DAX SUM function adds the numeric values in one column, returning a total that responds to the filters…
- Excel Budget Chart: Build and Read ItAn Excel budget chart compares planned spending with actual spending so you can see where money is on track and where it…
- Does Excel Have a Gantt Chart? How to Make OneExcel does not include a dedicated Gantt chart type, but you can make a useful Gantt-style schedule in Microsoft Excel for Microsoft…
- Power Pivot and SharePoint: What Works TodayYes—Excel Power Pivot can analyze data stored in SharePoint, including SharePoint lists and files, by importing or connecting to that data in…
- Power Pivot Slicers: How to Add and Connect ThemA Power Pivot slicer is a clickable filter for a PivotTable built from Excel’s Data Model. In Excel for Microsoft 365 on…
- Power Pivot Sort by Column: How It WorksIn Excel for Microsoft 365 on Windows, set a Power Pivot sort column by opening the model in the Power Pivot window,…
- Power Pivot: Merge Two Tables or Create a Relationship?Power Pivot does not have a Power Query-style Merge command: to combine tables into one query, use Data > Get Data and…
- Power Pivot Relationships: How They Work in Excel ModelsPower Pivot relationships connect tables in Excel’s Data Model through matching columns, letting a PivotTable combine fields from different tables without merging…
- Power Pivot Not Showing in Ribbon? Fix It in ExcelIf Power Pivot is missing from the Excel ribbon on Windows, first confirm your Excel edition includes the feature, then enable its…
- Power Pivot Hierarchy: Create and Use One in ExcelA Power Pivot hierarchy is an ordered set of related columns from one table in Excel’s Data Model, such as Year, Quarter,…
- Power Pivot Many-to-Many Relationships ExplainedPower Pivot does not model a many-to-many relationship as a direct link between two tables when both sides contain repeated keys. Instead,…
- Power Pivot Measures: How to Create and Use Them in ExcelPower Pivot measures are calculations written in DAX that summarize data in response to a PivotTable’s current filters, rows, and columns. In…
- Power Pivot DAX: What It Does and How It Works in ExcelPower Pivot DAX is the formula language used to calculate and analyze data in Excel’s Data Model. DAX stands for Data Analysis…
- Power Pivot Greyed Out? Causes and FixesIf Power Pivot is greyed out in Excel for Microsoft 365 on Windows, first check whether the Power Pivot COM add-in is…
- Excel Time Charts: Plotting Dates, Times, and TrendsTo make an Excel time chart, put each date or time in one column and its measurement in the next, select the…
- Excel Column Chart: Make Columns Wider and Improve SpacingTo make columns wider in an Excel column chart, select a column, open Format Data Series, and reduce Gap Width under Series…
- Excel Mac Chart Creation: Make and Format ChartsTo create a chart in Excel for Mac, select your data, choose Insert > Recommended Charts, select a chart type, and click…
- Excel Gantt Chart Dates: Formulas, Setup, and TipsFor a basic Excel Gantt chart, calculate each task’s finish date with =B5+C5-1 when B5 is its start date and C5 is…
- Pivot Chart Grand Totals: Why Excel Leaves Them OutNo. In Microsoft Excel for Microsoft 365, a PivotChart does not plot a PivotTable’s grand total, even when that total is visible…
- Pivot Chart: Remove Filter Labels in ExcelTo remove the filter labels from an Excel PivotChart, select the chart and choose PivotChart Analyze > Show/Hide > Field Buttons >…
- Pivot Chart Scatter Plot in Excel: Limits and WorkaroundsNo: in Microsoft Excel for Microsoft 365 on Windows, you cannot create an XY scatter plot as a PivotChart. The practical workaround…