Charts & pivot tables
Build, format and fix charts and pivot tables.
- Google Sheets Progress Meter: Make a Chart or BarIn Google Sheets, the quickest progress meter is a SPARKLINE bar inside a cell: if B2 contains a percentage from 0% to…
- Google Sheets Gantt Chart for Project TimelinesTo make a project timeline Gantt chart in Google Sheets, put tasks and start dates in columns, calculate each task’s end date,…
- PowerPoint Org Chart: Make All Boxes the Same SizeYes. For an org chart made from separate shapes, select the boxes and enter matching Height and Width values on the Shape…
- Google Sheets Pivot Tables: Combine Multiple SheetsGoogle Sheets pivot tables use one source range, so they cannot directly summarize separate tabs as independent sources. To report across multiple…
- Organization Chart in Google Sheets: Make and Share OneYes. Google Sheets can turn employee and manager data into an organizational chart: put each person in one column and their manager…
- How to Open a Pivot Table Menu in Google SheetsTo open the pivot table controls in Google Sheets, click any cell inside the pivot table; the Pivot table editor should appear…
- Org Chart Template for Google SheetsTo make an org chart in Google Sheets, put each person or position in column A and that person’s manager in column…
- Google Sheets Pivot Tables: How to Make and Use OneTo make a pivot table in Google Sheets, select a data range with a header row, choose Insert > Pivot table, select…
- Line Chart in Google Sheets: Create, Customize, and FixTo make a line chart in Google Sheets, select your data, choose Insert > Chart, then pick Line chart in the Chart…
- Google Sheets Line Chart Maker: Create and Format a ChartGoogle Sheets has a built-in line chart maker: select your data, choose Insert > Chart, then select Line chart in the Chart…
- Google Sheets Scatter Chart: Fix Common ProblemsTo fix a Google Sheets scatter chart, put numeric X values in one column and numeric Y values beside them, select both…
- Google Sheets: How to Create and Customize a GraphTo create a graph in Google Sheets, select the cells containing your data, including their labels, then choose Insert > Chart. Sheets…
- Google Sheets Gantt Chart Formatting GuideTo format a Gantt chart in Google Sheets, arrange tasks in rows, put each task’s start and end dates in separate columns,…
- Google Sheets Pivot Table Formatting: A Practical GuideTo format a pivot table in Google Sheets, click a cell in the table and use the toolbar or the Format menu…
- Google Sheets Flow Chart: Create and Customize OneYes. In Google Sheets in a web browser, choose Insert > Drawing > New, add flowchart shapes and connector lines, then select…
- Inserting an Excel Chart Into PowerPoint: Steps and OptionsTo insert an Excel chart into PowerPoint, select the chart in Excel, press Ctrl+C, then in PowerPoint choose Home > Paste and…
- Insert a Live Excel Chart Into PowerPoint and Update ItTo insert a live Excel chart into PowerPoint, copy the chart in Excel, then in PowerPoint for Microsoft 365 on Windows choose…
- How to Insert a Gantt Chart in Google Sheets Step by StepYou can make a Gantt chart in Google Sheets, but Sheets does not provide a dedicated Gantt chart type. The practical options…
- Insert an Excel Pie Chart into PowerPointTo insert an Excel pie chart into PowerPoint, select the chart in Excel, press Ctrl+C, switch to PowerPoint, and press Ctrl+V. Choose…
- Insert a Linked Excel Chart in PowerPoint: Keep It UpdatedTo insert a linked Excel chart in PowerPoint for Microsoft 365 on Windows, select the chart in Excel and press Ctrl+C. In…
- How to Insert a Dynamic Excel Chart in PowerPointTo insert a dynamic Excel chart in PowerPoint for Microsoft 365 on Windows, select the chart in Excel, press Ctrl+C, then in…
- Google Sheets Pie Charts: Create, Customize, and Fix ThemTo make a pie chart in Google Sheets, put category names in one column and their numeric values in the next, select…
- How to Update and Refresh a Pivot Table in Google SheetsTo update a pivot table in Google Sheets, change the source data and the pivot table will usually recalculate automatically. If you…
- How to Set Up a Pie Chart in Google Sheets EasilyTo set up a pie chart in Google Sheets, put category names in one column and their numeric values in the next,…
- How to Put a Pivot Table in Google Sheets: Step by StepTo put a pivot table in Google Sheets, select a cell in your data, choose Insert > Pivot table, select where to…
- How to Put an Excel Chart in PowerPointTo put an Excel chart in PowerPoint, select the chart in Excel, press Ctrl+C, switch to PowerPoint, and use Home > Paste…
- How to Make Org Chart Lines in PowerPoint and Align ThemTo make org chart lines in PowerPoint, insert a SmartArt organization chart and add positions with SmartArt Design > Add Shape; PowerPoint…
- How to Make an Org Chart Bigger in PowerPointTo make an org chart physically bigger in PowerPoint, select its outer boundary and drag a corner handle outward; to make it…
- How to Make an XY Graph in Google SheetsTo make an XY graph in Google Sheets, put your X values in one column and your matching Y values in another,…
- How to Make a Scatter Graph in Google Sheets: Step by StepTo make a scatter graph in Google Sheets, put your X values in one column and the matching Y values in the…