Excel Chart Types: How to Choose the Right Chart for Data

There is no single best Excel chart type: choose the one that makes your data’s main message easiest to see. Use a bar or column chart to compare categories, a line chart to show change over time, a scatter chart to examine the relationship between two numeric measures, and a stacked chart when the parts of a total matter.

Start With the Question Your Chart Should Answer

A chart is useful when it answers a question faster than a table can. Before choosing a design, state the question in plain language: Which product sold the most? How did monthly sign-ups change? Do higher advertising costs tend to accompany higher sales? What share of the whole belongs to each region? Those questions point toward different chart types because they involve different relationships in the data.

Also decide what the reader should notice first. A chart that displays every available measure may be technically complete but difficult to interpret. If the main point is a change over time, make the time series prominent and move secondary details to a note or separate chart. If the goal is to compare a few categories, make the category names and values easy to scan.

Compare categories: bar or column chart.
Show a trend: line chart, usually with time along the horizontal axis.
Compare two numeric measures: scatter chart.
Explain parts of a whole: stacked bar or column, or a pie chart for a simple whole.
Show a distribution: histogram or box and whisker chart.

Bar and Column Charts for Comparisons

Bar and column charts encode values as the length of a bar, making differences between categories relatively easy to judge. In Excel, a column chart has vertical bars; a bar chart has horizontal bars. Choose columns when category labels are short or when the categories follow a natural sequence, such as quarters. Choose horizontal bars when labels are long, when there are many categories, or when readers need to compare a ranked list.

A simple clustered chart works well for a few measures side by side. For example, to compare sales for four products across three regions, a clustered column chart places the regional values beside one another for each product. If the values are large or labels are lengthy, a clustered bar chart may use space more effectively. Sort categories by value when the order itself is not meaningful; retain chronological or other meaningful order when it is.

Stacked bars and columns show both a total and the contribution of each component. They are useful for questions such as how total sales and product mix changed by quarter. However, only the bottom segment shares a consistent baseline in a standard stacked chart, so comparing the other segments precisely can be hard. A 100% stacked chart emphasizes proportions rather than totals: every bar or column has the same overall height. Do not use it when readers need to compare the actual totals, because those totals are no longer visible from the bar height.

Line and Area Charts for Change Over Time

A line chart is a strong default for showing a measure across ordered time periods, such as daily temperature, monthly revenue, or annual enrollment. Connecting observations helps the reader see direction, turning points, and patterns. Put time periods in chronological order, and avoid treating a sequence of unrelated categories as if the intervals between them were meaningful.

Excel line charts generally place categories along an axis; dates may be displayed as dates, but the spacing does not work like a numeric x-axis in a scatter chart. If the exact spacing between observations matters—for instance, measurements taken after 1, 2, and 20 days—a scatter chart can represent those unequal intervals more faithfully. A line chart is often clearer when observations arrive at regular intervals.

An area chart fills the space beneath a line. It can emphasize cumulative magnitude, and a stacked area chart can show how components contribute to a changing total. Filled areas can obscure smaller series, though, especially when several values overlap. Use a line chart instead when comparing the separate trajectories is more important than emphasizing accumulated volume.

Scatter and Bubble Charts for Relationships

Use a scatter chart when each observation has two numeric values and the question concerns how they relate. For example, each point might represent a store, with advertising spend on the horizontal axis and sales on the vertical axis. Unlike a category chart, a scatter chart uses numeric values on both axes, so differences in horizontal distance have meaning. It can reveal a positive or negative association, clusters, gaps, and unusual observations.

A relationship does not by itself establish that one measure caused the other. Store size, location, season, or another factor could influence both advertising and sales. A scatter chart helps explore a pattern; it does not prove why the pattern exists. Add a trendline only when it helps describe the relationship, and explain that a fitted line is a summary rather than proof of causation.

A bubble chart adds a third numeric measure through the size of each marker. For instance, a point could show a country’s income and life expectancy, with population represented by bubble size. Bubble area is harder to judge than position, so use this form only when the third measure is important and the chart has enough room. Too many bubbles or overlapping labels can make the result unreadable.

Pie, Doughnut, and Other Part-to-Whole Charts

A pie chart can communicate simple part-to-whole data when there is one meaningful total and a small number of positive categories. It works best when the slices differ enough to be recognizable and the labels are clear. A doughnut chart uses a central hole but has the same basic limitation: people are usually better at comparing lengths along a common baseline than angles or areas. If exact comparisons matter, use a sorted bar chart instead.

Do not use pie or doughnut charts for unrelated values, negative values, multiple time periods, or categories that do not add up to a meaningful whole. A pie chart cannot show several separate series in the same straightforward way that a clustered chart can. There is no strict universal maximum number of slices, but many small slices are difficult to distinguish. Combine minor categories only when doing so is honest and useful, and label any combined group clearly.

When the purpose is to compare composition across several groups, a 100% stacked bar or column chart is usually more practical than a series of pies. It gives each group a shared scale from zero to 100%, making proportional changes easier to compare. Keep in mind that this hides differences in the groups’ total sizes.

Histograms, Box Plots, and Specialized Charts

A histogram groups numeric observations into ranges, or bins, and shows how many observations fall in each range. Use it to inspect a distribution, such as delivery times or exam scores. The bin width affects the shape that readers see: overly wide bins can hide structure, while very narrow bins can make random variation look like a pattern. Excel’s histogram chart options let you adjust bin settings; check the axis labels so the ranges are understandable.

A box and whisker chart summarizes a distribution using quartiles, a median, and whiskers; Excel may also show individual points or outliers depending on the chart settings. It is useful for comparing distributions across groups, such as response times for several teams. It does not show every value as a histogram does, so use it when a compact summary is more useful than the detailed shape of each distribution.

Other chart families serve narrower purposes. A waterfall chart shows how sequential increases and decreases lead to a final value, making it useful for explaining a bridge from starting balance to ending balance. A combo chart can put different series in one chart, such as columns for units sold and a line for a rate. A map chart can display geographic values when Excel recognizes the location data, but ambiguous place names may be mapped incorrectly. Specialized charts are not automatically clearer; confirm that the chart’s visual structure matches the question.

Choose a Chart in Excel for Microsoft 365

For a quick starting point in Excel for Microsoft 365 on Windows, arrange the data with clear headers, select the relevant range, and choose Insert > Recommended Charts. Review the previews and select one that represents the data correctly. Recommended Charts can suggest a useful option, but it cannot know the point you want readers to take away, so treat its suggestion as a starting place.

Put each category or time period in a column or row and give each series a descriptive header. Keep the data contiguous where practical, and avoid merged cells in the chart source.
Select the data range, including headers, then open Insert > Recommended Charts. You can also use the chart buttons on the Insert tab to select a chart family directly.
Check that Excel assigned the categories and series correctly. If it did not, select the chart and use Chart Design > Switch Row/Column, or use Chart Design > Select Data to review the source ranges.
To change the chart family, select the chart and choose Chart Design > Change Chart Type. For a combo chart, choose Combo in the Change Chart Type dialog and assign each series an appropriate type.
Add only the elements that help interpretation. With the chart selected, use Chart Design > Add Chart Element for items such as axis titles, data labels, and a legend. Give the chart a specific title and check that units and time periods are clear.

Excel for Mac has similar chart families and ribbon controls, although the arrangement and labels can vary slightly by release. Excel for the web also supports common chart creation and editing, but some advanced chart options may be more limited than in the desktop app. If a particular chart setting is missing, open the workbook in the desktop version rather than assuming the chart data is wrong.

Common Chart Problems and How to Fix Them

A chart can be the right type and still mislead or confuse. The first check is the source range: confirm that it includes the intended rows and columns, that headers are not being plotted as values, and that blanks or totals are not creating an unintended series. If Excel puts months in the legend and measures on the horizontal axis when you expected the reverse, inspect the series assignment before changing chart styles.

Too many series: Split the chart into focused views or filter to the most relevant measures. A crowded legend makes comparisons slow.
Unclear axes: Add units and descriptive axis titles. For a bar chart, a value axis that does not start at zero can exaggerate differences in bar lengths; use a zero baseline when length is the visual measure.
Overloaded labels: Remove unnecessary data labels, gridlines, and decorative effects. Keep labels for values that readers need to identify, not simply because Excel can display them.
Misleading time spacing: Use a scatter chart if the horizontal intervals are genuinely uneven and their distances matter. Otherwise, use a time-ordered line chart.
Unhelpful 3-D effects: Prefer a flat chart for comparisons. Perspective can make values look larger or smaller depending on their position.

One common misconception is that a chart type is a design choice made after the data is finished. In practice, the layout of the data, the question, and the intended comparison all matter together. A chart that looks attractive but changes the meaning—such as using 100% stacked columns to compare totals—does not serve the reader. Check the axis scale, labels, and series as carefully as the color and layout.

Frequently Asked Questions

What is the best Excel chart for comparing data?
A bar or column chart is usually a good choice for comparing category values. Use horizontal bars for long labels or a ranked list, and columns when labels are short or categories follow a natural order.

Which Excel chart is best for showing trends over time?
A line chart is a common choice for regularly spaced dates or periods. If the time intervals are irregular and their spacing matters, consider a scatter chart with time values on the horizontal axis.

When should I use a pie chart in Excel?
Use one for a small set of positive values that make up a single meaningful total. If there are many slices or precise comparisons matter, a sorted bar chart is often easier to read.

How do I change a chart type in Excel?
Select the chart, then choose Chart Design > Change Chart Type. Select the desired family in the dialog and confirm that the series and axes still communicate the intended comparison.

Why does Excel recommend the wrong chart?
Excel bases its recommendation on the selected range and its layout, not on the question you want to answer. Check headers, category labels, series orientation, and the selected cells, then choose a chart that fits the message.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.