Excel Charts: How to Choose and Create the Right Chart

Charts & pivot tables · Updated November 18, 2026

Excel charts turn worksheet data into visual summaries that make comparisons, trends, and relationships easier to see. To create one in Microsoft Excel for Microsoft 365 on Windows, select a range that includes its labels, choose Insert > Recommended Charts, select a chart, and click OK; then add a clear title and check that the chart tells the story your data actually supports.

What Excel charts do

A chart represents values from worksheet cells as visual marks such as columns, lines, points, or slices. It is linked to its source data, so editing a plotted value normally updates the chart. The chart does not replace the table: the worksheet remains the place to inspect exact values, while the chart helps readers grasp a pattern or comparison quickly.

Excel charts are useful for routine reports, project updates, budgets, survey summaries, and many other datasets. A chart can reveal that sales rose over several months, that one category accounts for most of a total, or that two measured variables move together. It can also mislead when the selected data, chart type, or axis scale gives the wrong impression, so choosing and checking the chart matters as much as inserting it.

Choose a chart type for the question

Start with the question you want the chart to answer, not with a favorite visual style. The same data can produce several valid charts, but only some make the intended comparison easy to read.

  • Compare categories: Use a clustered column or bar chart to compare values such as sales by product or responses by department. Bars are often easier to read when category names are long.
  • Show change over time: Use a line chart for an ordered time series, such as monthly website visits. Put dates in chronological order and use a consistent interval where possible.
  • Show parts of a whole: A pie or doughnut chart can work for a small number of categories that add up to one meaningful total. With many slices or similar-sized values, a bar chart is usually easier to compare.
  • Show a relationship between two numeric measures: Use an XY (Scatter) chart, such as for advertising spend and leads. It treats both axes as numeric values rather than treating the horizontal axis as a sequence of categories.
  • Show variation or distribution: A histogram groups numeric observations into ranges. A box-and-whisker chart summarizes a distribution and can help compare groups, though readers may need an explanation of its markers.

These are starting points, not rules that make a chart automatically correct. For example, a line chart is generally appropriate when the horizontal values represent an ordered progression, such as dates. Connecting unrelated product categories with a line can imply a continuous sequence that does not exist. A stacked chart is helpful when both totals and components matter, but changes in middle segments can be hard to compare because they do not share a common baseline.

Prepare worksheet data before charting

Good chart structure begins with a clean, rectangular data range. A simple monthly sales table might have one header row with Month, North, and South, followed by one row per month. Excel can use the first column for category labels and the remaining columns as separate data series.

  • Use one clear header for each column and avoid blank header cells.
  • Keep each observation on its own row, with consistent units and a single kind of information in each column.
  • Enter real dates and numbers where appropriate, rather than values stored as text. A number stored as text may not plot as expected.
  • Remove totals or notes from the selected range unless you intend to chart them. A grand total included as another category can distort a comparison.
  • Check for blank rows, duplicate labels, and accidental selection of unrelated cells.

For data that will grow, consider turning the range into an Excel Table with Insert > Table. Tables provide column headers and can expand when you add rows; charts built from table data can include newly added table rows. Still, check the chart after adding data, especially if it uses a specific date range or a manually adjusted selection.

Create and edit a chart in Excel

  1. Select the data, including the row and column headings. If the data is in an Excel Table, select a cell in it or select the relevant table range.
  2. Choose Insert > Recommended Charts. Review the previews, or open the All Charts tab to browse chart families, then select the chart that fits the comparison and click OK.
  3. Click the chart title and replace the placeholder with a descriptive title. A title such as “Monthly Sales by Region” gives more useful context than “Sales.”
  4. Select the chart to show the Chart Design tab. Use Chart Design > Add Chart Element to add or adjust elements such as axis titles, a legend, gridlines, and data labels.
  5. If Excel grouped the data in the wrong direction, choose Chart Design > Switch Row/Column. Use Chart Design > Select Data to review the chart’s data range, series names, and category labels.
  6. Resize and position the chart, then inspect it at the size readers will see. Check that labels are legible and that no series or categories are missing.

Recommended Charts is a suggestion tool, not a data-quality check. It may propose a reasonable chart but cannot know which conclusion matters to your audience. For a simple category comparison, for instance, compare the suggested chart with a bar or column chart and ask whether readers can identify the largest and smallest values without effort.

Excel for Mac also offers chart insertion from the Insert tab, though ribbon labels and layout can differ slightly by release. In Excel for the web, chart creation and editing are available, but some formatting controls may be more limited than in the desktop application. The basic principle is the same: select the source data, insert a chart, and verify the series and labels.

Make the chart easier to understand

A chart should communicate its point without requiring readers to decode decoration. Use a specific title, concise labels, and a legend only when it helps identify multiple series. If the chart has one series, a legend that repeats the series name may be unnecessary. Axis titles can clarify units, such as “Revenue (thousands of dollars)” or “Temperature (°C).”

Keep colors consistent and purposeful. Use distinct colors for series that need to be compared, but avoid relying on color alone to distinguish important information; some readers have color-vision differences, and charts may be printed in grayscale. Direct labels, different marker shapes, or clear line styles can provide additional cues. Remove visual elements that do not help interpretation, but keep enough gridlines or axis markings to estimate values accurately.

Be careful with axis scales. A column chart whose value axis starts far above zero can exaggerate small differences because the bars are judged by their length from the baseline. A line chart may use a narrower scale when the goal is to examine modest variation, but the axis should remain visible and its range should not obscure the size of the changes. If the chart uses a secondary axis, label it clearly: two scales can make unrelated series appear to track each other.

Common chart problems and how to fix them

If a chart shows the wrong labels or values, first check the selected source range. Select the chart and choose Chart Design > Select Data to inspect its series and category labels. A frequent issue is that Excel reads rows as series when columns were intended, or vice versa; Chart Design > Switch Row/Column can correct that arrangement.

  • Dates appear as evenly spaced categories: Check whether the cells contain real Excel dates and whether the chart type treats the horizontal axis as dates. A line chart can display a date axis; an XY (Scatter) chart is useful when spacing must reflect numeric date intervals.
  • A series is missing: Check whether its cells fall inside the chart data range, and look for text values, blanks, or hidden rows and columns. Use Select Data to review the source.
  • The chart includes totals that dwarf the other values: Remove the total row or column from the plotted range unless the total is intentionally being compared with the individual categories.
  • Labels overlap: Widen the chart, shorten category names, reduce the number of categories, or use a horizontal bar chart. Rotating labels may help, but it should not be the first fix for an overcrowded chart.
  • Blank cells create confusing gaps: Select the chart, open Chart Design > Select Data, and use Hidden and Empty Cells to choose how empty cells are displayed. The available choices depend on the chart type; a gap may be more honest than connecting values across missing observations.

Do not treat missing data as zero unless zero is the true measured value. A blank might mean that a measurement was not collected, while zero means a measured amount of none. Those meanings produce different charts and potentially different conclusions.

Charts, PivotCharts, and other ways to visualize data

A standard chart plots a selected range or table. A PivotChart is associated with a PivotTable and is useful when readers need to summarize or filter larger datasets by fields such as region, product, or date. Its structure depends on the PivotTable, so changing the PivotTable fields can change the chart. For a short, fixed comparison, a standard chart may be simpler; for an interactive summary, a PivotChart may be a better fit.

Not every visual needs to be a chart. Conditional formatting can emphasize values directly in cells, such as using data bars to compare amounts while retaining the table’s exact numbers. A formatted table may be clearest when readers need to look up many precise values. For a presentation or report, a chart can be copied from Excel, but check how it appears in the destination because fonts, sizing, and colors can change.

Frequently Asked Questions

How do I make an Excel chart from data?
Select the data, including its headers, then choose Insert > Recommended Charts. Select a chart, click OK, and review the title, labels, and plotted series.

Which Excel chart is best for comparing data?
For a small set of categories, a clustered bar or column chart is usually a clear starting point. Choose bars when category names are long, and confirm that the categories and units make the comparison meaningful.

Why is my Excel chart not showing all the data?
The source range may omit rows or columns, or some values may be blank or stored as text. Select the chart and choose Chart Design > Select Data to inspect its range, series, and category labels.

Will an Excel chart update when I change the data?
Changes to cells in the chart’s source range normally update the chart. If you add rows outside that range, they may not appear; using an Excel Table as the source can help a chart include added table rows.

Can I make a chart from non-adjacent data?
Yes. Select the first range, then hold Ctrl on Windows while selecting additional ranges, and insert the chart. Because separate selections can be interpreted unexpectedly, use Chart Design > Select Data afterward to confirm the series and labels.

What is the difference between a chart and a graph in Excel?
In everyday use, people often use “chart” and “graph” to mean the same visual. Excel’s ribbon uses “chart” for its visualizations, including column, line, pie, and XY (Scatter) charts.

Related

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.