How to Make a Chart in Excel From Your Data

To make a chart in Excel, select the cells containing your data, choose Insert > Recommended Charts, pick a chart, and select OK. Then add a clear title and check that the chart shows the right data. These steps are for Excel for Microsoft 365 on Windows; chart types and labels can also be adjusted in Excel for Mac and Excel for the web, though ribbon layouts may differ.

What You’ll Need

An Excel workbook containing the data you want to visualize.
A heading for each data column or row, plus category labels such as dates, product names, or regions.
A basic idea of what you want the chart to explain, such as a comparison, a trend over time, or the relationship between two measurements.

You do not need to calculate anything special before creating a chart. However, arranging the information in a simple rectangular table—with one header row and no completely blank rows or columns inside the data—makes it much easier for Excel to identify the categories and values correctly.

Step-by-Step

Arrange and check the source data. Put each type of information in its own column. For example, a monthly sales table could have Month in column A, North in column B, and South in column C, with one month per row beneath the headings. Keep the headings in the first row, use consistent units, and avoid merged cells. Remove accidental blank rows or columns within the table, since Excel can interpret them as boundaries between separate data ranges. If your data is already laid out this way, you can use it as is.
Select the data to chart. Click a cell inside the data range if it is a continuous, clearly structured table; Excel will often detect the full range when you insert a chart. For more control, drag across the headers and all values you want included. Include category labels as well as numbers, but do not select totals or notes unless you want them plotted. If you need to select separate ranges, hold Ctrl while selecting each range on Windows; on Mac, hold Command. Separate selections can be harder for Excel to interpret, so a single table is usually simpler.
Open the chart suggestions. On the ribbon, select Insert > Recommended Charts. Excel opens a dialog with chart suggestions based on the selected cells. Review the previews and the chart descriptions rather than accepting the first suggestion automatically. If you already know the chart you want, use the chart buttons in the Insert tab—such as Insert Column or Bar Chart—or open the chart dialog to browse the available types.
Choose a chart type that fits the question. A clustered column or bar chart is useful for comparing categories, such as sales across products. A line chart is often suitable for showing a trend across dates when the time sequence matters. A pie chart is best reserved for a small number of parts that make up one whole; many slices or similar-sized values are difficult to compare. Use a scatter chart when you want to show how two numeric variables relate. In the Recommended Charts dialog, select a suggestion and inspect its preview. Choose OK to insert it on the worksheet.
Check that Excel assigned the data correctly. Confirm that category names appear along the horizontal axis and the intended numbers appear as plotted values. If Excel has treated rows as series when you expected columns, click the chart and select Chart Design > Switch Row/Column. The command is available when it applies to the selected chart. If the wrong range was used, select Chart Design > Select Data and inspect the chart data range, series names, and category labels. Correct the range or edit a series there, then select OK.
Add a useful chart title. Click the chart title and replace the placeholder with a short description that says what is being measured and, when helpful, the period or unit. For example, use Monthly Sales by Region rather than Chart Title. If no title appears, select the chart, go to Chart Design > Add Chart Element > Chart Title, and choose a position. A title should explain the chart without repeating every detail already shown in the legend or axis labels.
Make labels and units readable. If readers need more context, select Chart Design > Add Chart Element to add axis titles, data labels, a legend, or gridlines. Axis titles are useful when the units are not obvious, such as Revenue (dollars) or Temperature (°C). Keep the legend when it distinguishes multiple series; remove it when there is only one series and it adds no information. To format a chart element, click it and use the formatting options that appear, or right-click it and choose the relevant formatting command.
Adjust the appearance and placement. With the chart selected, use the Chart Design tab to choose a chart style or change colors. Keep the design restrained enough that the values remain the focus. Drag the chart by its border to move it, or drag a corner handle to resize it without distorting the proportions. To put it on its own sheet, select Chart Design > Move Chart and choose a new chart sheet or an object in another worksheet. Save the workbook after checking the finished chart.

When the source data changes, a chart based on ordinary worksheet cells generally updates to reflect edits in those cells. If you expect to add rows regularly, consider converting the data range to an Excel table first: select a cell in the data and choose Insert > Table, confirm the range and whether it has headers, then select OK. Charts linked to a table can include added table rows as the table expands, which helps avoid manually revising the chart range each time.

Common Mistakes

Selecting only the numbers: Without the heading and category cells, Excel may use generic labels or guess incorrectly. Select the headings and labels along with the values.
Including totals in the plotted range: A grand total can dwarf the individual values and make their differences look tiny. Leave summary rows out unless comparing the total is part of the point.
Choosing a chart for its appearance rather than its purpose: Three-dimensional effects and crowded pie charts can make comparisons harder. Prefer a simple chart that suits the data and question.
Using inconsistent or unclear labels: A chart with dates stored as text, mixed units, or abbreviated series names may be confusing. Make labels consistent and explain units in the heading or axis title.
Assuming Excel guessed correctly: A chart can be created successfully while showing the wrong categories, series, or range. Check the axes, legend, and plotted values before sharing it.

Tips

Start with the comparison you want readers to make. Use bars or columns for category comparisons, lines for a sequence over time, and scatter plots for relationships between two numeric measures. For a time trend, put dates in a single column and make sure Excel recognizes them as dates.
Keep the source table simple. One header row and one record per row make it easier to extend the data later. Avoid inserting decorative text or blank rows in the middle of the range.
Use a chart title that carries meaning on its own. Mention the measure and scope, such as Quarterly Website Visits, rather than a vague label such as Results. Add the year or unit if a reader might otherwise have to search the worksheet for it.
Make direct comparisons easy. If a chart has several series, use clear names in the source headers and retain a readable legend. If the labels are long, a horizontal bar chart may fit them better than vertical columns.
Use the keyboard for a quick default chart. On Windows, select the data and press Alt+F1 to create an embedded chart on the current worksheet. Press F11 to create a chart on a separate chart sheet. These shortcuts create a default chart, so review its type and data afterward. On Mac, shortcut behavior can vary with the keyboard and Excel settings; use the Insert tab if the Windows shortcuts do not apply.
Know where the controls are on other platforms. In Excel for Mac, select the data and use the Insert tab to add a chart; chart-specific design controls appear when you select it. Excel for the web also offers chart insertion and formatting from its ribbon, but some advanced formatting options may be limited compared with the Windows desktop app.

Troubleshooting

The chart is blank or missing some values: Recheck the selected range and look for numbers stored as text, blank cells, or formulas returning an empty string. Select Chart Design > Select Data to verify the data range and series. If the source cells contain filtered or hidden data, check the chart’s hidden and empty cell settings in the Select Data Source dialog if that option is available for the chart.

The categories and series are reversed: Select the chart and choose Chart Design > Switch Row/Column. If the result is still wrong, open Chart Design > Select Data and check which range is used for each series and for the horizontal category axis labels. This often happens when the data is arranged across rows rather than down columns, or when the selection includes an extra heading.

The chart includes an unwanted total or blank category: Use Chart Design > Select Data to edit the range, or revise the source selection and insert the chart again. Check for stray spaces or text in cells that you thought were blank. If the chart is based on an Excel table, confirm that the table itself does not include notes or summary rows that should remain outside the chart.

Dates appear as separate labels or in the wrong order: Check that the source entries are real Excel dates, not text that merely looks like a date. You can test a cell by changing its number format; a valid date changes display while retaining its underlying date value. Then check the axis options by right-clicking the horizontal axis and choosing Format Axis. Depending on the chart and data, choosing a date axis or adjusting the axis bounds can improve the display.

The chart looks cramped or labels overlap: Enlarge the chart, reduce unnecessary labels, or use a bar chart for long category names. You can also change the text size by selecting the labels and choosing a font size on the Home tab. Avoid shrinking text until it is difficult to read; it is usually better to simplify the chart or give it more space.

Frequently Asked Questions

How do I make a chart in Excel with two columns of data?

Select both columns, including their headers and category labels, then choose Insert > Recommended Charts. Excel will use one column for categories and the other for values when it recognizes the layout. Check the preview and confirm the chart’s axes before using it.

Can I make a chart without selecting the data first?

You can insert a blank chart, but you will then need to assign its data range using Chart Design > Select Data. Selecting the data first is usually quicker and reduces the chance of leaving out a series or label.

How do I change the chart type after creating it?

Select the chart and choose Chart Design > Change Chart Type. Pick a suitable type in the dialog and select OK. Review the chart afterward, because some types display series and categories differently.

Will my chart update when I change the worksheet data?

Changes to cells within the chart’s source range normally appear in the chart automatically. If you add data outside that range, the chart may not include it. Expand the range through Chart Design > Select Data, or use an Excel table when you regularly add rows.

How do I copy an Excel chart into Word or PowerPoint?

Select the chart and press Ctrl+C on Windows, then paste it into the other Office app with Ctrl+V. On Mac, use Command+C and Command+V. Depending on the paste option you choose, the pasted chart can remain linked to the workbook or become a static picture; check the paste options if you need the destination chart to update with the source data.

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.