Excel Chart Creation: Steps, Choices, and Fixes

Yes—Excel makes chart creation straightforward: select your data, choose Insert > Recommended Charts, pick a chart, and select OK. You can then use the Chart Design and Format tabs to add labels, change the style, and make the chart easier to read. The best results depend on choosing a chart that fits the question and arranging the source data clearly.

How to create a chart in Excel

These steps apply to Excel for Microsoft 365 on Windows. Start with a simple range that has a heading for each column or row, then select the data, including those headings. Go to Insert > Recommended Charts, review the previews, select a chart, and choose OK. Excel inserts the chart on the worksheet, where you can drag it to reposition it or use its corner handles to resize it.

If you already know which type you want, use the chart buttons on the Insert tab instead. For example, choose Insert > Insert Column or Bar Chart for a column or bar chart, or Insert > Insert Line or Area Chart for a line chart. The available buttons and chart choices can vary with the selected data and Excel version.

After selecting the chart, use the contextual Chart Design tab to change its type, layout, colors, or source data. To add a title or data labels, choose Chart Design > Add Chart Element, then select the element and placement you want. You can also click the chart title or another chart element directly to edit it. In Excel for Mac, the same general process uses the Insert tab and chart-specific ribbon controls; the exact ribbon arrangement can differ slightly.

Prepare the source data first

Excel needs to identify which values are categories and which are series. A clear layout makes that easier and reduces the chance of a chart with incorrect labels. For example, a monthly sales table might have months in the first column and sales regions in the next columns:

Put a descriptive heading at the top of each column, such as Month, North, and South.
Keep each row focused on one category, such as a month, product, or department.
Use consistent units within a series. Mixing dollars and percentages in one series makes the result misleading.
Avoid merged cells, decorative blank rows, and totals inside the main data range when they do not belong in the chart.

Suppose the table lists January through June in column A and sales for two regions in columns B and C. Selecting the full range lets Excel use the months as the category axis and the two region headings as series names. If the chart instead shows the regions along the horizontal axis and each month as a series, select the chart and choose Chart Design > Switch Row/Column. This changes how Excel interprets the same data; it does not rearrange the worksheet.

Choose a chart type that fits the question

A chart is useful when its visual form supports the point you want to communicate. There is no universally best chart type, and a visually polished chart can still confuse readers if its form does not suit the data.

Column or bar: Compare values across categories. Bars are especially helpful when category names are long; columns work well for a modest number of categories.
Line: Show a pattern over an ordered sequence, commonly time. A line chart is usually clearer than a column chart when the main interest is how a measure changes across many dates.
Scatter: Examine the relationship between two numeric variables, such as advertising spend and sales. Unlike a standard line chart, a scatter chart positions both axes according to numeric values.
Pie or doughnut: Show parts of one whole when there are only a few categories and the values add up to a meaningful total. Many slices or similar-sized values are difficult to compare.
Histogram: Show how a set of numeric observations is distributed across ranges, or bins. This answers a different question from a column chart of named categories.
Combo: Display different series using different chart forms, such as columns for revenue and a line for margin. A secondary axis may help when the units or scales differ, but it should be clearly labeled because it can exaggerate apparent relationships.

For example, use a line chart to show monthly orders over several years, but use a bar chart to rank product categories by annual orders. If the question is whether order value tends to rise with delivery time, a scatter chart is the more appropriate choice.

Make the chart understandable

Once the chart exists, remove anything that makes the message harder to see. Give it a specific title, such as “Monthly Orders by Region,” rather than leaving the default title or using a vague label like “Results.” Add axis titles when readers might not know what the values or units represent. To do so, select the chart and choose Chart Design > Add Chart Element > Axis Titles.

Data labels can help when exact values matter, but displaying a label on every point in a large chart can create clutter. A legend is useful when several series appear; if there is only one series, it may be unnecessary. Gridlines can help readers estimate values, but strong or numerous gridlines compete with the data. Use Chart Design options for preset layouts and styles, then use the Format tab or formatting pane when you need more control over a selected element.

Be cautious with three-dimensional effects, crowded legends, and too many colors. They can make comparisons less precise or make categories look more distinct than they are. Keep units visible—for example, state that values are in thousands of dollars—and avoid relying only on color to distinguish series if the chart will be printed or viewed by people with color-vision differences.

Keep charts connected to changing data

A chart created from worksheet cells is linked to its source range. When values in that range change, the chart normally updates. However, if you add new rows beneath a fixed source range, Excel may not include them automatically. One practical way to reduce that problem is to format the source as an Excel table: select the data, choose Insert > Table, confirm the range, and indicate whether it has headers. Charts based on a table generally expand as you add rows to that table.

For a chart that already exists, select it and choose Chart Design > Select Data to inspect or change the chart’s data range, series, and category labels. This is also useful when Excel has included an unwanted total row or missed a column. If the source is on another worksheet, the same command can help you verify the range without rebuilding the chart.

For a report that needs a chart to reflect filtered or summarized records, consider a PivotChart. PivotCharts are tied to a PivotTable and can be controlled by its fields and filters. That makes them useful for exploring categories, but they work differently from a standard chart: changing the PivotTable layout or refreshing its source can affect what the chart displays.

Common chart problems and how to fix them

A chart that looks blank, has the wrong labels, or contains unexpected series is often a data-selection issue rather than a failure of the chart feature. Check the selected range, headings, blank cells, and the chart’s data settings before recreating it.

Excel plots categories as series, or the reverse: Select the chart and use Chart Design > Switch Row/Column. If that does not help, open Select Data and check the series names and category-label range.
Dates appear as separate text labels: Check that the source cells contain actual dates rather than text that only looks like dates. You may also need to format the horizontal axis or adjust its date-axis settings.
New data does not appear: Use Chart Design > Select Data to check whether the source range includes the new cells. For future additions, a table-based source can help.
One series seems almost flat: The series may have values on a very different scale from the others. A combo chart with a clearly labeled secondary axis can sometimes help, but consider separate charts if the comparison would otherwise mislead.
Too many categories make the chart unreadable: Filter or summarize the data, use a bar chart for long labels, or show only the categories relevant to the question.

Also check for totals included as if they were another category. A grand total added to the source range can distort a chart of individual months or products. Keep summary figures outside the plotted range unless the total is genuinely part of the comparison.

Standard charts, PivotCharts, and other tools

Standard Excel charts are a good fit for a fixed, clearly defined range and for charts that need individual formatting. They are relatively simple to maintain: edit the source cells, and the linked chart reflects those changes. PivotCharts are better suited to interactive summaries where readers may want to filter or regroup larger datasets. They depend on PivotTable behavior, so they may require refreshing when their source data changes.

Excel also offers Recommended Charts, which suggests chart types based on the selected data. Treat the suggestions as a starting point, not an automatic guarantee that the chart answers your question. Check whether the axis, series, and categories match your intended comparison. If a chart needs elaborate annotation, a custom interactive dashboard, or publication-grade design, a dedicated visualization tool may offer more specialized controls. For many workplace reports, however, an Excel chart is convenient because it stays close to the underlying worksheet data.

Sharing and accessibility

Before sharing a workbook, check that chart titles, axes, units, and legends make sense without explanation from the person who built it. Add alternative text where appropriate so people using assistive technology can get a description of the chart’s purpose and key takeaway. In Microsoft 365 for Windows, select the chart, open its context menu, and choose View Alt Text or Edit Alt Text, depending on the interface shown.

If you need the chart in a presentation or report, you can copy it from Excel and paste it into another Office app. Consider whether the recipient should be able to edit the chart and its data or whether a static image is sufficient. A linked or embedded chart can preserve editability but may carry workbook data with it; an image is easier to distribute but will not update when the worksheet changes. Check the destination document after pasting, since resizing can affect readability.

Frequently Asked Questions

Can Excel create a chart automatically?
Excel can suggest chart types through Insert > Recommended Charts after you select a data range. You still need to review the suggestion and confirm that the labels, series, and chart type fit your purpose.

Can I create a chart without selecting data first?
Yes. Insert a chart from the Insert tab, then select it and choose Chart Design > Select Data to specify the worksheet range and series. Selecting the data first is usually quicker for a basic chart.

Why does my Excel chart not update when I add data?
The chart may use a fixed range that does not include the new cells. Check Chart Design > Select Data, or use a source formatted as an Excel table so added table rows can be included in the chart.

Can an Excel chart show two different scales?
Yes. A combo chart can place one series on a secondary axis. Label both axes clearly and use this option only when readers can understand the units and scale of each series.

Can I make a chart in Excel for the web?
Excel for the web supports creating and editing many common chart types, though some controls and advanced options can differ from the Windows desktop app. If a particular chart feature is unavailable in the browser, open the workbook in the desktop version of Excel.

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.