Charts & pivot tables
Build, format and fix charts and pivot tables.
- Google Sheets Chart Templates: How to Find and Use ThemGoogle Sheets does not have a dedicated gallery of reusable chart-style templates, but you can start with a spreadsheet template, build a…
- Google Sheets Chart Not Showing All Data? How to Fix ItIf a Google Sheets chart is missing data, first check its source range in the Chart editor, then check whether the missing…
- Google Sheets Chart of Accounts Template and SetupA Google Sheets chart of accounts template is a structured list of the accounts a business uses to classify its financial activity.…
- Google Sheets Chart Examples: Types, Uses, and TipsGoogle Sheets chart examples include a line chart for monthly sales trends, a bar chart for comparing products, a pie chart for…
- Google Sheets Chart Legend Labels: Edit and FixIn Google Sheets, chart legend labels usually come from the headings in the chart’s source data: edit the relevant header cell to…
- Google Sheets Chart Data Range: Set, Edit, and Fix ItIn Google Sheets, a chart’s data range is the cell range that supplies its labels and values. To set or change it,…
- Google Sheets Chart Custom Font: What You Can ChangeYes, you can change a chart’s font in Google Sheets: select the chart, open the Chart editor, choose Customize, and use the…
- Google Sheets Pivot Tables: How to Edit and UpdateTo change a pivot table in Google Sheets, click a cell inside it to open the Pivot table editor on the right,…
- Google Sheets Chart Trendlines: Add and Customize OneTo add a trendline in Google Sheets, open the chart editor by double-clicking your chart, choose Customize > Series, select the data…
- Google Sheets Chart Aggregate: How to Group Chart DataYes. In Google Sheets, a chart’s Aggregate option can combine rows that share the same value on the horizontal axis, so repeated…
- Google Sheets Blank Chart? Causes, Checks, and FixesA blank Google Sheets chart usually means the chart is pointed at the wrong cells, has no usable numeric data, or is…
- Google Sheets Bar Chart: Create and Customize ItTo make a bar chart in Google Sheets, select your category labels and numeric values, choose Insert > Chart, then select Bar…
- Google Sheets Bar Chart Tutorial: Create and CustomizeTo make a bar chart in Google Sheets, select your category labels and numeric values, choose Insert > Chart, then use the…
- Google Sheets Pivot Tables: Create, Edit, and AnalyzeYes. In Google Sheets, select a range of data and choose Insert > Pivot table, then use the Pivot table editor to…
- Google Sheets: Add a Vertical Line to a ChartGoogle Sheets does not offer a one-click setting for an arbitrary vertical reference line in a chart. For a quick visual marker,…
- Google Sheets Gantt Chart Tutorial: Build a Project TimelineTo make a Gantt chart in Google Sheets, put each task and its start and end dates in columns, create a row…
- Generate an Org Chart in PowerPoint: Steps and TipsTo generate an org chart in PowerPoint for Microsoft 365 on Windows, select Insert > SmartArt > Hierarchy, choose Organization Chart, and…
- Gantt Chart for Google Sheets: Setup, Uses, and LimitsYes. You can make a Gantt chart in Google Sheets by putting tasks and dates in a table, then using conditional formatting…
- Gantt Chart in Google Sheets: Build a Reusable TemplateYes. You can make a reusable Gantt chart in Google Sheets by listing tasks and their start and finish dates, adding a…
- Edit a Pivot Table in Google Sheets: Steps and TipsTo edit a pivot table in Google Sheets, click any cell inside it to open the Pivot table editor on the right.…
- Does Google Sheets Have Pivot Tables? How to Use ThemYes. Google Sheets has pivot tables, which let you summarize and reorganize rows of data without changing the original table. In a…
- Creating an Org Chart in PowerPoint: Steps and TipsTo create an org chart in PowerPoint for Microsoft 365 on Windows, choose Insert > SmartArt > Hierarchy, select Organization Chart, and…
- Create an Organizational Chart in Google SheetsTo create an organizational chart in Google Sheets, put each person or position in the first column and that person’s manager in…
- Create a Free Gantt Chart in Google Sheets: Steps and TipsYes. You can create a free Gantt chart in Google Sheets by listing tasks and their start and end dates, building a…
- How to Create a Gantt Chart in Google SheetsTo create a Gantt chart in Google Sheets, list each task with its start and finish dates, add a row of calendar…
- Google Sheets Chart Editor: Create and Customize ChartsThe Google Sheets Chart editor is the sidebar for creating and changing charts in a spreadsheet. Select the cells you want to…
- Chart Labels in Google Sheets: Add, Edit, and FormatTo add chart labels in Google Sheets, open the chart, choose Customize in the Chart editor, then use Chart & axis titles…
- Google Sheets Chart Themes: How to Set and CustomizeIn Google Sheets, a chart’s appearance can come from the spreadsheet’s overall theme or from settings on the chart itself. To apply…
- Can You Create a Pie Chart in Google Sheets? Here’s HowYes. In Google Sheets in a web browser, select a table of category names and values, choose Insert > Chart, then set…
- Google Sheets Pivot Tables: Create, Customize, and RefreshYes, you can create a pivot table in Google Sheets using Insert > Pivot table. Select a range of well-organized data, choose…