Charts & pivot tables
Build, format and fix charts and pivot tables.
- Auto Refresh Pivot Tables in Excel: Options That WorkIn Excel for Microsoft 365 on Windows, a PivotTable does not normally update itself the moment its source data changes. Refresh it…
- Combo Charts in Sigma: How They Work and When to Use ThemYes. Sigma supports combo charts, which combine visual forms such as bars and lines in one chart so you can compare measures…
- Access Power Pivot Add-In: Use Access Data in ExcelYou cannot add Power Pivot to Microsoft Access: Power Pivot is an Excel add-in, not an Access feature. To analyze Access records…
- AG Grid Pivot Table: Setup, Features, and Common IssuesAn AG Grid pivot table is a data view that groups records into rows and generates columns from distinct values in selected…
- Power Pivot Date Table: Setup, Marking, and Best PracticesA Power Pivot date table is a dedicated table with one row for every date in the reporting period, used to connect…
- How to Move the Y-Axis to the Right in ExcelTo move a chart’s vertical (Y) axis to the right in Excel for Microsoft 365 on Windows, select the horizontal (X) axis,…
- P Chart in Excel: Build Control Limits and Read ResultsTo make a p chart in Excel, calculate each subgroup’s fraction nonconforming, find the overall fraction and three-sigma control limits, then plot…
- Schedule Gantt Chart in Excel: A Step-by-Step GuideTo make a schedule Gantt chart in Excel, place each task, its start date, and its duration in separate columns, then insert…
- How to Left Align a Pie Chart in ExcelTo left align a pie chart in Excel, select the chart’s outer border and drag it until its left edge meets the…
- How to Insert a Bar Graph in Excel: A Step-by-Step GuideTo insert a bar graph in Excel, select your category labels and values, then choose Insert > Insert Column or Bar Chart…
- How to Insert a Treemap Chart in Excel: Step by StepTo insert a Treemap chart in Excel, arrange your data in columns from broad category to specific item, followed by a numeric…
- Gantt Chart in Excel: How to Insert One Step by StepTo insert a Gantt chart in Excel, arrange each task with a start date and duration, then insert a 2-D Stacked Bar…
- How to Import a Chart Template in Excel and Apply ItTo import a chart template in Excel for Microsoft 365 on Windows, copy its .crtx file into your Excel chart templates folder,…
- How to Make a Pareto Chart in ExcelTo make a Pareto chart in Excel, select your data and choose Insert > Insert Statistic Chart > Pareto. That built-in option…
- How to Create a Sunburst Chart in Excel Step by StepTo generate a Sunburst chart in Excel, arrange your data in columns from the highest level of the hierarchy to the lowest,…
- How to Format a Doughnut Chart in Excel for ClarityTo format a doughnut chart in Excel, select the chart and use the Chart Design tab to change its colors, style, labels,…
- How to Flip a Stacked Bar Chart in Excel: Axes and SeriesTo flip a stacked bar chart in Excel, first decide what you want to change: use Chart Design > Change Chart Type…
- How to Flip a Bar Graph in Excel: Reverse Its OrderTo flip the order of bars in an Excel chart, right-click the category axis, choose Format Axis, and select Categories in reverse…
- How to Fix a Chart in Excel: Common Problems and StepsTo fix a chart in Excel, select it and check its source range, chart type, and formatting in the Chart Design and…
- Find a Pivot Table in Excel: Locate It Across SheetsTo find an existing PivotTable in Excel, search the workbook for a label or value you know appears in it, then select…
- Year to Date in Google Sheets Pivot Tables: How It WorksTo show year-to-date (YTD) figures in a Google Sheets pivot table, add a helper column to your source data that marks dates…
- COUNTA in Google Sheets Pivot Tables ExplainedIn a Google Sheets pivot table, COUNTA counts how many non-empty values appear in a selected field for each group. Add the…
- Wedding Seating Chart in Google Sheets: A Practical GuideYes. You can make a wedding seating chart in Google Sheets by keeping guest details and table assignments in a sortable list,…
- View Pivot Table Fields in Google SheetsTo view pivot table fields in Google Sheets, click any cell inside the pivot table; the Pivot table editor opens on the…
- How to Update Pivot Table Data in Google SheetsGoogle Sheets pivot tables update automatically when cells in their source range change. If you add rows or columns outside that range,…
- Timeline Chart in Google Sheets: Create and Customize OneTo make a timeline in Google Sheets, use Insert > Timeline if you want an interactive date-based view, or create a stacked…
- Sort Pivot Tables in Google Sheets: Steps and TipsTo sort a pivot table in Google Sheets, click inside it and use the Pivot table editor: under Rows or Columns, choose…
- Sales Dashboard in Google Sheets: Build and Track ResultsYes—a sales dashboard in Google Sheets can summarize revenue, closed deals, sales by representative, and trends in one shareable view. Start with…
- Room Chart in Google Sheets: Build One Step by StepYes. You can make a room chart in Google Sheets by arranging cells as rooms or seats, then adding names, reservations, or…
- Radar Chart in Google Sheets: How to Create and Read OneTo make a radar chart in Google Sheets, put category names in the first column and each data series in its own…