How to Make a Chart in Excel: A Clear Step-by-Step Guide

To make a chart in Excel, arrange your information in labeled rows or columns, select the data, then choose Insert > Recommended Charts and pick a chart that suits the comparison. Add a clear title and check that the labels and values appear correctly. The steps below are for Excel for Microsoft 365 on Windows; most ribbon commands are similar on Mac and Excel for the web, though their layout can differ.

What You’ll Need

An Excel workbook with the data you want to visualize. A small, clean table is easiest to chart.
One column or row of labels, such as months, product names, or regions, and one or more columns or rows of numbers.
A question the chart should answer, such as which month had the highest sales or how several categories compare.

You do not need to calculate chart values separately: Excel uses the selected cells as the chart’s source. If the data is spread across unrelated areas, consider arranging it into a single table first. That makes it easier to create the chart and update it later.

Step-by-Step

Arrange and check the data. Put each category in one row, with a header at the top of each column. For example, a simple monthly sales table might have Month in A1 and Sales in B1, followed by January and its value in row 2, February in row 3, and so on. Keep each record on one row, avoid blank rows or columns inside the table, and use consistent number formats. Make sure values that should be numbers are not stored as text; a text value may be plotted as zero or omitted. A chart can include several number columns, such as sales and expenses, as long as each column has a clear heading.
Select the cells to chart. Drag across the headers and all relevant data cells, including the labels. For the example, select A1:B13 if the table contains a header and 12 months. You can select a range by clicking its first cell, holding Shift, and clicking its last cell. If you want to chart separate ranges, select the first range, then hold Ctrl while selecting the next range on Windows. On Mac, use Command instead of Ctrl for this selection. Nonadjacent selections can be harder to interpret, so combining the data into one rectangular table is usually more reliable.
Insert a recommended chart. With the range selected, go to Insert > Recommended Charts. Review the suggested previews and select one to see how Excel maps your labels and series. Choose the chart that makes the comparison easiest to understand, then select OK. If you prefer to choose directly, use Insert and select a chart type from the Charts group, such as Insert Column or Bar Chart or Insert Line or Area Chart. Excel inserts the chart into the worksheet, usually near the selected cells. You can drag its border to move it.
Choose a chart type that fits the data. Use a column or bar chart to compare amounts across categories, such as sales by product. A line chart is useful for showing a trend over time, especially when the categories are in date order. A pie chart can show how a small number of parts make up one whole, but it is difficult to compare many slices or similar values. A scatter chart is appropriate when you want to compare two numerical measurements, such as advertising spend and sales. If Excel recommends a chart that does not communicate your point well, cancel the dialog and choose another type from Insert.
Check how Excel has assigned the labels and series. Click the chart and look at the category labels and legend. The categories should identify the items along the axis, and each series should represent a meaningful set of values. If Excel has treated months as separate series or placed the wrong labels on the axis, select the chart and go to Chart Design > Switch Row/Column. Check the preview after switching; this is a quick fix when data orientation is interpreted the wrong way, but it is not appropriate for every table.
Add a descriptive chart title. Select the chart, then use Chart Design > Add Chart Element > Chart Title and choose a position, such as Above Chart. Click the title placeholder and type a short description that explains what is being measured and, where helpful, the time period. For example, “Monthly Sales, 2026” is more informative than “Sales.” Avoid leaving the default words “Chart Title” in a finished chart. If the chart already shows a title placeholder, you can click it directly and replace the text.
Add or refine labels and other chart elements. With the chart selected, open Chart Design > Add Chart Element to add axis titles, data labels, a legend, gridlines, or other available elements. Add an axis title when the units are not obvious, such as “Revenue ($)” or “Temperature (°C).” Data labels can help readers see exact values, but they can crowd a chart with many points. Keep a legend when multiple series need identification; remove it if there is only one series and the chart is already clear. Use these elements selectively rather than adding every option.
Make the chart readable. Select the chart and use the Chart Design tab to try a suitable chart style or color variation. To change a particular item, click it and use the Format tab or right-click it for relevant formatting options. Keep text large enough to read, use colors with good contrast, and avoid relying on color alone to distinguish important groups. If the chart has long category names, a horizontal bar chart may be easier to read than narrow columns. Resize the chart by dragging a corner handle; dragging a side handle changes only its width or height.
Verify the result and source range. Compare the chart with the table: confirm that all intended categories appear, the series are correct, and the scale does not mislead. To inspect or adjust the data range, select the chart and choose Chart Design > Select Data. In the Select Data Source dialog, review the chart data range, legend entries, and horizontal axis labels. If a heading was accidentally left out, include it in the source range so Excel can use it as a series or category name instead of displaying a generic label.
Test how the chart will behave as data changes. If you expect to add rows regularly, consider formatting the source range as an Excel table: select the data and choose Insert > Table, then confirm that the table has headers. Charts based on an Excel table can include newly added table rows as the table expands. Check the chart after adding a test row, especially if the workbook has other formulas or filters. If the data is a one-time snapshot, a normal cell range may be all you need.

On Mac, the Insert and Chart Design tabs provide comparable chart tools, although some controls may be grouped or positioned differently. In Excel for the web, select the data and use Insert to choose a chart; some advanced formatting and editing options may be less extensive than in the desktop app. If a command is not visible, make sure the chart itself is selected and look for the chart-specific tabs.

Common Mistakes

Selecting only the numbers. Without the header and category labels, Excel may assign generic names or create categories that are not meaningful. Include the relevant headings and labels in the selection.
Leaving blank rows or columns in the source. Gaps can split the data range or make the chart omit categories. Remove unnecessary gaps, or deliberately select only the cells you want represented.
Using the wrong chart type. A pie chart with many categories, for example, is difficult to read. Match the chart to the question: compare categories with bars or columns, show a time trend with a line, or explore a relationship between two numeric measures with a scatter chart.
Putting unlike measurements on one scale. Sales dollars and a percentage, for instance, can have very different ranges. If one series appears nearly flat, check the units and scale before changing the chart. A secondary axis can sometimes help, but it can also make comparisons confusing; explain it clearly if you use one.
Adding too much decoration. Excessive gridlines, labels, colors, and effects compete with the data. Remove elements that do not help the reader understand the comparison.
Assuming a chart updates from any new data. A chart linked to a fixed cell range may not include information pasted beyond that range. Expand its source through Chart Design > Select Data or use an Excel table when the data will grow.

Tips

Decide what the reader should notice first, then make that comparison easy to see. A chart with one clear message is usually more useful than one showing every available measure.
Sort categories when ranking matters, such as arranging product sales from highest to lowest. Keep dates in chronological order when the goal is to show a timeline.
Use a descriptive title and label units. A reader should not have to search the worksheet to work out whether values are dollars, units, percentages, or something else.
Keep colors consistent when several charts in the same workbook show the same categories. A familiar color scheme makes comparisons across charts faster.
For a presentation or report, widen the chart enough that labels are readable. Preview the worksheet at the size where it will be viewed or printed; a chart that looks clear on a large monitor may be cramped on a printed page.
Keep the source data near the chart or on a clearly named worksheet. This makes it easier for another person to verify where the chart values came from.

Troubleshooting

The chart is blank or missing categories. Check that the selected range includes the values and labels, and look for blank cells or numbers stored as text. Select the chart, open Chart Design > Select Data, and verify the chart data range. If the source range is correct, inspect the cells for errors or unexpected spaces in category labels.

The labels and series are reversed. Select the chart and choose Chart Design > Switch Row/Column. If the result is still wrong, open Select Data and check each legend entry and horizontal axis label range. The table layout may need clearer headers or a different selection.

The chart shows generic names such as Series1. The source range may not include the header row, or the heading cell may be blank. Include the header row in the chart range or edit the series name in the Select Data Source dialog. A clear heading will also make the legend easier to understand.

New rows do not appear in the chart. Select the chart and use Chart Design > Select Data to extend the data range to include the added rows. For recurring updates, use an Excel table as the source and add new records directly beneath the existing table so it expands.

The chart looks crowded or values are hard to read. Remove unnecessary data labels or gridlines, enlarge the chart, shorten long category names, or choose a bar chart for categories with lengthy labels. If the chart has many unrelated series, create separate charts or show only the series needed for the comparison.

The chart type or formatting controls are missing. Click the chart area once to select the chart; chart-specific tabs appear only when a chart is selected. If you are using Excel for the web or a smaller window, some controls may be in a collapsed ribbon menu. Widen the window or open the workbook in desktop Excel if you need a formatting option that is not available in the web version.

Frequently Asked Questions

How do I make a chart in Excel from two columns?
Select both columns, including their headers, then choose Insert > Recommended Charts and select a suitable option. Excel normally uses one column for categories and the other for values. Review the labels before keeping the chart.

Can I create a chart without selecting the data first?
You can insert a chart first, but Excel will create a blank chart or ask you to provide a data range. Selecting the source cells before inserting the chart is generally quicker and reduces the chance of choosing the wrong range.

How do I change a chart after creating it?
Select it and use Chart Design to change the chart type, switch rows and columns, select data, or add chart elements. Select an individual chart item, such as its title or axis, to format that item. You can also move or resize the chart on the worksheet.

How do I make an Excel chart update when I add data?
For a growing list, format the source data as a table using Insert > Table and build the chart from that table. Add records within the table so it can expand. If you are using an ordinary range, update the chart source with Chart Design > Select Data.

Can I put a chart on a separate worksheet?
Yes. Select the chart, go to Chart Design > Move Chart, choose New sheet, and enter a name. This creates a chart sheet that displays the chart without the usual worksheet grid. Choose Object in if you want to place it on a different existing worksheet instead.

Which Excel chart should I use?
Use columns or bars to compare categories, lines to show change over an ordered timeline, pies for a small set of parts that make up one whole, and scatter charts to compare two numeric variables. Choose the simplest type that makes the intended pattern easy to see.

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.