How to Make a Chart in Excel From a Table: Steps That Work

To make a chart from a table in Excel, click a cell in the table, choose Insert > Recommended Charts, select a chart style, and click OK. Excel builds a chart from the table’s headings and values. Before you start, check that each column has a clear heading and that the rows contain the data you want to compare; a tidy source table makes the chart easier to create and understand.

What You’ll Need

Microsoft Excel for Microsoft 365 on Windows. The steps also work in recent desktop versions of Excel, although ribbon labels can vary slightly.
A worksheet table with one header row and data beneath it. You can use an ordinary cell range, but converting it to an Excel table makes it easier to manage as the data changes.
At least one category or label column and one column of values. For example, a monthly sales table could have Month and Sales headings.

Step-by-Step

Arrange and check the source data. Put each kind of information in its own column, and give every column a short, descriptive heading such as Month, Product, or Revenue. Keep each record on one row. Remove completely blank rows or columns within the data, because they can cause Excel to select only part of the information. Check that values intended to be numbers are stored as numbers, not text. For example, a number aligned left or preceded by an apostrophe may not behave like a numeric value.
Convert the range to an Excel table if needed. Click a cell in the data, then choose Insert > Table. Confirm the range in the dialog box and make sure My table has headers is selected if the first row contains column names. Click OK. On Windows, Ctrl+T also opens the Create Table dialog; on Mac, use Command+T. If you already have an Excel table, you can skip this step. Table formatting is optional, but the table structure helps Excel identify the complete data set when you create a chart.
Select the table or the data you want to chart. Click any cell inside the table to start a chart using the table’s data. Excel generally detects the full table automatically, including its headings. To chart only some columns, select the headings and values for those columns instead; hold Ctrl while selecting separate ranges on Windows, or Command on Mac. Selecting nonadjacent ranges can be fiddly, so for a simple result it is often easier to make a small helper table containing just the columns you need.
Open the chart suggestions. On the ribbon, choose Insert > Recommended Charts. Review the options Excel displays, then click a chart thumbnail to see a larger preview. A chart suggestion is a starting point, not a requirement: you can choose another chart type from the chart dialog if the suggested styles do not communicate your data well. If you do not see Recommended Charts in your Excel version, use Insert and choose a chart type from the Charts group.
Choose a chart type that fits the table. For values across time, such as sales by month, a line chart is useful for showing a trend; a column chart is also a clear option when you want to compare individual months. For comparisons among a few categories, use a column or bar chart. Use a pie chart only when the categories are parts of one whole and there are only a few of them. Avoid choosing a chart just because it looks attractive: the reader should be able to make the intended comparison quickly.
Insert and position the chart. After choosing a chart in the preview, click OK. Excel places the chart on the worksheet, usually over the cells near the source table. Drag the chart’s border to move it, or drag a corner sizing handle to change its size. If you want the chart on a separate sheet, select the chart, open the Chart Design tab, and choose Move Chart. Choose New sheet for a dedicated chart sheet, or Object in to place it on another worksheet in the workbook.
Check that Excel plotted the fields correctly. Look at the horizontal axis, legend, and plotted values. In a monthly sales chart, the month names should usually appear along the horizontal axis and sales should appear as the data series. If Excel has treated rows as series instead of columns, select the chart and choose Chart Design > Switch Row/Column. If a heading is missing or the chart uses the wrong cells, choose Chart Design > Select Data to inspect or adjust the chart’s data range and series.
Add a title and make the chart readable. Select the chart, then use the Chart Design tab to choose Add Chart Element > Chart Title and select a title placement. Click the title on the chart and type a specific description, such as Monthly Sales by Product, rather than leaving the generic Chart Title text. Add axis titles or data labels only when they help explain the values. Use the chart’s formatting controls to adjust colors or text size, and make sure labels remain legible at the chart’s final size.
Test the chart after changing the table. If the chart comes from an Excel table, add a sample row at the bottom and check whether the chart includes it. Charts created from table data commonly expand with the table, but verify the result in your workbook, especially if the source was a manually selected range or the chart has been customized. Remove the test row if it is not real data. Save the workbook when the chart looks right.

Common Mistakes

Including totals in the plotted data: A grand total is not another category to compare with the individual rows. Including it can make the other columns or bars look tiny. If the table has a total row, check whether Excel included it; adjust the chart’s data range if necessary.

Leaving blank rows or unclear headers: Blank lines can interrupt the detected range, while empty or duplicated headings make it harder to identify series. Give each column a distinct heading and keep the data block continuous.

Using the wrong chart for the question: A pie chart with many categories is hard to read, and a line chart can imply a continuous sequence when the categories are unrelated. Choose a chart based on what you want people to compare, not just on the shape of the source table.

Mixing units or text with numbers: Values such as 10, 20, and “about 30” cannot be plotted consistently as numeric values. Standardize units and keep notes in a separate column. Also check for numbers stored as text, which Excel may omit or treat unexpectedly.

Tips

Make the chart answer one clear question. If the table contains dozens of products and several years, charting every field at once may create a crowded legend. Filter the table, make a smaller summary table, or create separate charts for different comparisons. For a time series, put dates in chronological order so the chart reads naturally from left to right.

Use direct labels and a descriptive title where possible. A chart called Sales by Month is more useful than Chart 1, and a vertical axis that shows dollars or units helps readers interpret the scale. Avoid excessive gridlines, decorative effects, and too many colors. Keep the source table in the workbook so someone can check where the chart’s figures came from.

If the chart will be shared or printed, check it at the size people will actually see. A legend that fits on a large screen may become unreadable in a report. You can resize the chart, move the legend, or simplify the data selection. In Excel for Mac, the same main approach is available from Insert and the chart tools; the ribbon layout and some dialog details can differ. In Excel for the web, use Insert > Chart; some chart formatting and data-source controls may be more limited than in the desktop app.

Troubleshooting

The chart is blank or has no useful values: Check whether the source values are numeric. Select a suspicious cell and look at the formula bar; if the entry includes text or an apostrophe, convert it to a number. Also check that the chart’s source range includes the value columns and that the relevant rows are not filtered out or empty.

The labels appear as data, or the legend looks wrong: Excel may have guessed the orientation incorrectly. Select the chart and choose Chart Design > Switch Row/Column. If that does not fix it, choose Chart Design > Select Data and review the chart data range, series names, and category labels. Make sure the headings are included once, not accidentally plotted as an extra row of values.

New rows do not appear in the chart: First confirm that the new row was added directly below the Excel table and that the table expanded to include it. If you used an ordinary cell range, select the chart and choose Chart Design > Select Data to update the range. When possible, convert the source range to a table before creating the chart, then test that added rows are included.

The chart type is unavailable or hard to read: Some chart types need a particular arrangement or number of data series. Try selecting a simpler subset of the table, then choose Insert > Recommended Charts again. If category names overlap, enlarge the chart, reduce the number of categories, or use a bar chart so longer labels have more room.

The chart includes the wrong cells: Select the chart and open Chart Design > Select Data. Check the range shown in the dialog and edit it to include the intended headings and data only. You can also delete the chart and create it again after selecting the correct table; deleting a chart does not delete its source data.

Frequently Asked Questions

Can I make a chart from a formatted Excel table?
Yes. Click a cell inside the table and choose Insert > Recommended Charts. Excel uses the table headings and data to create the chart. You do not need to select every cell manually for a basic chart.

Does a chart update when I add rows to the table?
Charts based on Excel table data commonly expand to include rows added to the table. Check the chart after adding data, because manually selected ranges or customized sources may not expand as expected. A regular range may need its chart data range updated.

How do I make a chart from only two columns?
Select the two columns, including their headings, and insert a chart. If the columns are not next to each other, select one range and then the other using Ctrl on Windows or Command on Mac. If Excel plots them incorrectly, use Chart Design > Select Data to set the labels and series.

Can I change the chart type after creating it?
Yes. Select the chart and choose Chart Design > Change Chart Type. Pick another type and confirm the change. Your source table remains unchanged, so you can compare chart styles without rebuilding the data.

How do I put the chart on a separate worksheet?
Select the chart, then choose Chart Design > Move Chart. Select New sheet to give it a dedicated chart sheet, or choose Object in and select a worksheet to embed it there. The chart stays linked to its 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.