Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Dashboard Templates: How to Choose and Build OneAn Excel dashboard template is a pre-built workbook layout for summarizing data with charts, key performance indicators (KPIs), and sometimes filters. In…
- How to Open a Pivot Table in Excel: View and Edit ItTo open an existing PivotTable in Excel, open the workbook, select the worksheet that contains it, then click any cell inside the…
- How to Insert a Line Graph in Word: A Step-by-Step GuideTo insert a line graph in Word, select Insert > Chart > Line, choose a line-chart style, and click OK. Replace the…
- Google Sheets: How to Move a Chart to Its Own SheetTo move a chart in Google Sheets to a new sheet, select the chart, click its three-dot More menu, and choose Move…
- Google Sheets Log Scale Charts: Setup and TroubleshootingTo make a log scale chart in Google Sheets, select your data, choose Insert > Chart, then open Customize in the Chart…
- Google Sheets Line Chart: Add and Format Multiple LinesTo make a Google Sheets line chart with multiple lines, put the shared labels (such as dates) in the first column and…
- Google Sheets Jira Dashboard: Setup, Sync, and ReportingYes. You can build a Jira dashboard in Google Sheets by connecting a spreadsheet to Jira with an available add-on or third-party…
- Yes/No Chart in Excel: How to Create OneYes, you can make a yes/no chart in Excel. Put the responses in a column, count each answer in a small summary…
- Yearly Comparison Chart in Excel: Build It ClearlyTo make a yearly comparison chart in Excel, put each year in its own column and each measure or category in a…
- Yearly Gantt Chart Excel Template: Build and Use OneYes. A yearly Gantt chart Excel template can show tasks against the 12 months of a selected year: enter each task’s start…
- Year-Long Gantt Chart Template in Excel: Setup GuideTo make a year-long Gantt chart in Excel, list each task with its start and finish dates, create a row of weekly…
- Year-on-Year Comparison Chart Excel Template GuideA year-on-year comparison chart Excel template puts the same measures for two or more years side by side, calculates the change, and…
- Word Bubble Chart in Excel: Build One Step by StepExcel does not have a built-in word-cloud chart, but you can make a word bubble chart by plotting each word as a…
- Radar Charts in Excel: Why and When to Use ThemA radar chart in Excel is used to compare several measures for one or more items across the same set of categories.…
- Funnel Chart in Excel 2013: Where It Is—and What to UseExcel 2013 does not include a built-in funnel chart, so there is no menu or ribbon location where you can insert one.…
- Excel Pivot Table Spill Error: Meaning, Causes and FixesIn Excel, a spill error is the standard #SPILL! error: a dynamic-array formula cannot put all of its results into the cells…
- Weekly Gantt Chart Excel Template: Build Your ScheduleA weekly Gantt chart Excel template lays out tasks against dates so you can see when work is scheduled and how long…
- Drop Lines in Excel Area Charts: Meaning, Uses, and LimitsDrop lines in an Excel area chart are vertical lines drawn from a plotted data point down to the chart’s horizontal category…
- Visio Org Chart Excel Template: Import and Format DataTo make a Visio org chart from Excel, prepare a worksheet with one row per person and columns for each person’s name…
- Vertical and Circular Bullet Charts in Excel ExplainedExcel has no built-in chart type called a vertical or circular bullet chart. To make one, use stacked columns or bars for…
- Variable Width Column Chart in Excel: How It WorksExcel does not include a native variable-width column chart type: ordinary column-chart bars share the same width. You can make a proportional-looking…
- Treemap Chart in Excel: Create and Format OneTo create a treemap chart in Excel for Microsoft 365 on Windows, arrange your data in columns with category levels followed by…
- Use Excel Data to Create an Organization Chart in VisioYes. In the Visio desktop app for Windows, prepare an Excel worksheet with each person’s name and the name of their manager,…
- Excel for Visio Org Charts: How to Import Your DataYes. You can use an Excel workbook as the source for an organization chart in the Visio desktop app: arrange employee names…
- Turn Excel Data Into an Org Chart: Steps and OptionsYes. You can use Excel for Microsoft 365 to turn employee information into an org chart by arranging it as a reporting…
- Turn an Excel List Into an Org Chart: Steps & OptionsYes. In Excel for Microsoft 365 on Windows, turn a small employee list into an org chart by choosing Insert > SmartArt…
- Tree Chart in Excel: Create and Format a TreemapIn Excel, a “tree chart” usually means a Treemap: a chart that displays hierarchical categories as nested rectangles sized according to their…
- Tree Map Chart in Excel: Create, Read, and Format OneTo create a tree map chart in Excel for Microsoft 365 on Windows, arrange your data in columns from broad category to…
- Thermometer Chart in Excel: How to Create and Format ItTo create a thermometer chart in Excel, calculate the completed portion and the amount remaining, then plot them as a 2-D stacked…
- Radar Chart Line Titles in Excel: Add Series NamesIn an Excel radar chart, each plotted line is a data series, and its title is the series name shown in the…