Excel includes chart types for comparing categories, showing change over time, displaying parts of a whole, and exploring relationships between numbers. The best choice depends on what your data contains and the point you want readers to see; column, bar, line, and scatter charts cover many everyday needs, while other types suit more specialized data.
What Excel chart types are available?
In Excel for Microsoft 365 on Windows, chart options are on the Insert tab. The available types include column, bar, line, area, pie, doughnut, scatter, bubble, histogram, Pareto, box and whisker, waterfall, funnel, treemap, sunburst, map, stock, surface, radar, and combo charts. Some chart families offer 2-D and 3-D variations, and many let you choose clustered, stacked, or percentage-stacked layouts.
To start, select a data range and use Insert, then choose a chart family from the Charts group. For suggestions based on the selected range, choose Insert > Recommended Charts. Excel previews options, but a recommendation is only a starting point: check that the chart communicates the intended comparison and that it has assigned the data series and categories correctly.
A chart is a visual presentation of worksheet data, not a different kind of calculation. Changing a chart type does not normally change the underlying values, but it can change how Excel groups or positions them. For example, a line chart connects values in category order, while a scatter chart positions points according to numeric X and Y values.
Column and bar charts for category comparisons
Column and bar charts use rectangular bars to compare values across categories. A column chart has vertical bars; a bar chart has horizontal bars. Both are useful for questions such as which product sold the most, how departments compare, or how a total breaks down across a small set of groups.
Choose a clustered chart when you want to compare several series side by side. If a table lists quarterly revenue for three products, a clustered column chart can show each product within each quarter. A stacked column or bar chart adds the series into a total for each category, letting readers see both the total and its components. A 100% stacked chart scales each category to the same height or length, emphasizing percentage composition rather than absolute totals.
Bar charts are often easier to read when category names are long, or when there are many categories. Column charts work naturally for a short sequence such as months or years. With too many categories, either chart can become crowded; sort the categories, show a meaningful subset, or use a table alongside the visual rather than shrinking labels until they are hard to read.
Line and area charts for change over time
A line chart is a common choice for showing a trend across ordered intervals, such as monthly website visits or annual costs. Put time periods in chronological order and use separate lines for series you want to compare. A line chart connects neighboring values, so it implies continuity between points. It is less suitable when the categories have no natural order.
An area chart fills the space beneath a line. It can emphasize the size of values or totals over time. A stacked area chart shows how several series contribute to a combined total, while a 100% stacked area chart shows their shares. Because filled areas overlap and can obscure smaller series, use these variants only when the cumulative or proportional story is important. A line chart is often clearer for comparing exact trends across several groups.
Check the horizontal axis before interpreting a time chart. If dates are treated as text categories, Excel may space them evenly even when the time gaps differ. A date axis can represent time intervals more faithfully. Also look for missing periods and blank cells: how gaps appear depends on the chart and its settings, so do not assume a connecting line means measurements were recorded at every point.
Pie and doughnut charts for parts of a whole
Pie and doughnut charts show how categories contribute to one total. They work best when the data represents a meaningful whole, the values are nonnegative, and there are only a few categories. A pie chart uses slices; a doughnut chart leaves a center opening that can make room for a label, though it does not automatically make the data easier to compare.
These charts are weak choices when values are similar, when there are many small categories, or when readers need to compare changes across several periods. Comparing slice angles is harder than comparing bar lengths. A sorted bar chart is usually more legible in those situations. Do not use a pie chart if the listed figures are unrelated measures or do not add up to a sensible whole.
Excel can display data labels such as values, category names, and percentages. A percentage label describes each category’s share of the plotted total; it does not mean the source values were already percentages. Verify that the selected range contains the intended categories and values, especially if the worksheet includes a total row that should not be plotted as another slice.
Scatter and bubble charts for numeric relationships
A scatter chart, also called an XY chart, plots paired numeric values on horizontal and vertical axes. Use it to investigate a relationship such as advertising spend versus sales, height versus weight, or temperature versus energy use. Unlike a line chart with category positions, the spacing between scatter points reflects the numeric distance between their X values.
Each observation should provide an X value and a Y value. Excel may use the first selected column as X values and the next as Y values, but inspect the series setup if the result looks wrong. A trendline can help summarize a pattern, but it does not prove that one variable causes the other. Consider outliers, the number of observations, and whether a relationship is curved rather than linear.
A bubble chart adds a third numeric measure through bubble size. For example, a company might plot product margin against sales growth and use bubble size for revenue. Size is harder to compare precisely than position, so avoid using bubbles for small differences or adding too many overlapping points. Use a legend or labels to identify the bubbles when the categories are not self-evident.
Specialized charts: distributions, hierarchy, and stages
Excel’s statistical charts answer questions that ordinary category charts do not. A histogram groups numeric observations into bins to show a distribution, such as customer ages or delivery times. Bin width matters: wide bins hide detail, while narrow bins can make random variation look meaningful. A Pareto chart combines columns ordered from largest to smallest with a cumulative percentage line, which can help prioritize the largest contributors.
A box and whisker chart summarizes a distribution using quartiles and a median, with markers for possible outliers depending on its settings. It can help compare spread across groups without plotting every observation individually. Read its legend and chart options carefully, because the visual summary is not the same as a display of the raw values.
Treemap and sunburst charts display hierarchical data. A treemap uses nested rectangles; a sunburst uses concentric rings. They can show how a large total divides into departments, product groups, and individual items, but labels and small segments become difficult to read in deep or broad hierarchies. Waterfall charts show how successive increases and decreases lead from a starting value to an ending value, which is useful for explaining a bridge such as opening balance, additions, deductions, and closing balance. Funnel charts show values across sequential stages, such as a sales pipeline, but stage values should represent a comparable process rather than unrelated categories.
Maps, stock, surface, radar, and combo charts
A map chart is intended for data associated with geographic regions, such as countries, states, or postal areas. Clear location names matter: a place name that could refer to more than one location may be mapped incorrectly or left unresolved. Use consistent geographic descriptions and inspect the rendered map before sharing it. Map charts are not a substitute for a detailed route map or precise point-by-point navigation display.
Stock charts are designed for financial time-series fields such as open, high, low, and close prices, sometimes with volume. Arrange the columns in the order required by the chosen stock-chart subtype and include the correct fields; a set of ordinary category values will not automatically become meaningful stock data. A surface chart uses a grid of values to show how a measured result changes across two dimensions. It is more specialized and can be difficult to read, so use it only when the grid structure and shape are relevant.
A radar chart compares several measures across the same categories, with each measure arranged around a radial axis. It may suit a compact profile of a few entities, but overlapping shapes and axis scaling can make comparisons misleading. A combo chart combines chart types, commonly columns for totals and a line for a rate or target. A secondary axis can help when series have very different scales, but it may also exaggerate apparent relationships. Label both axes clearly and explain why the second scale is needed.
How to choose the right chart
Start with the question, not the visual style. Ask whether the reader needs to compare groups, follow a trend, understand a distribution, see a relationship, or trace a sequence of contributions. Then choose a chart that represents the data structure accurately.
- Compare values among categories: use a bar or column chart.
- Show a trend across ordered time periods: use a line chart, or an area chart when accumulated magnitude matters.
- Show shares of one total: consider a pie, doughnut, or 100% stacked chart, but keep categories limited.
- Explore two numeric variables: use a scatter chart; use bubbles only when a third measure is useful.
- Show distributions, hierarchy, or step-by-step changes: consider histogram, box and whisker, treemap, sunburst, or waterfall.
- Combine measures with different meanings: consider a combo chart, and use a secondary axis sparingly.
Keep the design restrained. Use a descriptive title, sensible axis labels, and a legend only when it helps identify multiple series. Avoid 3-D effects for ordinary comparisons: perspective changes apparent bar and slice sizes and can hide data. If precise reading matters, include data labels or a nearby table, but do not label every point when that would create clutter.
Creating and changing a chart in Excel
On Excel for Microsoft 365 for Windows, select the data and choose a chart from the Insert tab, or open Insert > Recommended Charts to review suggestions. After inserting a chart, select it to reveal the Chart Design and Format tabs. Chart Design includes options for changing the chart type, choosing a layout or style, and selecting or rearranging chart data. The exact controls shown can vary with the selected chart.
If Excel plots series in the wrong direction, use Chart Design > Switch Row/Column. To change which cells are plotted, use Chart Design > Select Data. To convert an existing chart, choose Chart Design > Change Chart Type. These commands are useful when Excel interprets rows as series but you intended columns, or when the data range accidentally includes headings or totals.
Excel for Mac has corresponding chart tools, although ribbon placement and dialog appearance can differ by version. Excel for the web supports common chart creation and editing, but some chart types and advanced formatting controls may be limited compared with the Windows desktop app. If a specialized chart or detailed formatting option is missing, open the workbook in desktop Excel.
Common chart problems and how to avoid them
A chart can look polished and still give the wrong impression. First, check the selected data range, series names, category labels, and axis units. A blank cell, an included total row, or a number stored as text can lead to missing or unexpected marks. For a scatter chart, confirm that the intended X and Y ranges are paired correctly.
Next, check the scale. A value axis that starts above zero can make small differences between bars look dramatic. That choice may be appropriate for some line charts when the focus is change, but disclose the scale and use judgment. For stacked charts, remember that only the bottom series shares a common baseline, so comparing middle segments across categories is difficult.
Finally, distinguish a chart type from a chart decoration. Changing colors, adding a trendline, or switching to 3-D does not fix unsuitable data structure. If a visual is crowded, reduce the number of series, split the display into smaller charts, or use a clearly labeled table. A straightforward chart that matches the question is usually more useful than a complex one.
Frequently Asked Questions
What is the most commonly used chart type in Excel?
Column charts are widely used for comparing category values, while line charts are common for trends over time. There is no single best chart for every task; choose based on the question and data layout.
What is the difference between a bar chart and a column chart?
Both compare categories using bars. A bar chart displays horizontal bars, which can accommodate long category labels; a column chart displays vertical bars and often suits short labels or time categories.
Which Excel chart is best for comparing two sets of numbers?
Use a scatter chart when both sets are numeric paired measurements and you want to examine their relationship. Use a clustered bar or column chart when the numbers instead represent separate series being compared across named categories.
When should I use a combo chart?
Use one when two related measures need different visual forms, such as columns for monthly sales and a line for a target. A secondary axis may be needed for different scales, but label it clearly so the comparison is not confusing.
Why does my Excel chart look different from the data table?
Excel may have selected the wrong range, treated rows and columns differently than intended, or interpreted values as text. Check Chart Design > Select Data, confirm the headings and axis labels, and verify the underlying cell values.
Related
- Power Query Editor: What It Is, How It Works, and Why
- Excel Data Validation Icon: What It Looks Like and Does
- Data Validation Multiple Selection in Excel: What Works
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- 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…
- How to Add a Formula to an Excel GraphTo add a formula’s results to an Excel graph, enter the formula in a worksheet column, fill it…
- Google Sheets Bar Chart: Create and Customize ItTo make a bar chart in Google Sheets, select your category labels and numeric values, choose Insert >…
- Enable Power Pivot in Excel: Steps and CompatibilityTo enable Power Pivot in Excel for Microsoft 365 on Windows, select File > Options > Add-ins, choose…
- Automated Gantt Chart in Excel: Setup and LimitsYes. In Microsoft Excel for Microsoft 365 on Windows, you can make a Gantt chart update automatically by…
- 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…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.