Select your data first, then insert the chart
To create a graph from a table in Excel, you highlight the cells containing your data, then use the Insert menu to pick a chart type. Excel reads the layout of your table — which row or column holds labels, which holds numbers — and builds the graph automatically. The whole process takes about a minute once you know where to click.
The most common mistake is selecting too much or too little. You want the headers (the row or column that names what each number represents) plus all the data rows or columns below it. Do not include empty cells or totals rows unless you want them in the graph.
Key Takeaways
- Highlight your table including headers, then go to Insert > Chart and pick your chart type — most tables work best as column or line charts.
- Excel automatically detects which row or column contains labels and which contains numbers, so you do not have to tell it.
- After the chart appears, you can change the title, axis labels, and chart type by right-clicking the chart and selecting Edit Data or Chart Title.
- A chart stays linked to your table, so if you change a number in the table, the graph updates when ready.
- You can move or resize the chart by clicking it and dragging, or delete it by clicking it and pressing Delete.
Step 1: Highlight the cells that hold your data
Click the first cell of your table — usually the top-left corner where a header sits. Hold down the mouse button and drag to the last cell that contains data. Release. You should see a blue or colored border around all the cells you selected.
If your table is large, you can click the first cell, then hold Shift and click the last cell instead of dragging. This is faster and more accurate. Make sure you include the row or column that names what each number means — Excel needs those labels to build a readable graph.
Step 2: Open the Insert menu and choose Chart
At the top of the Excel window, click the word Insert. A dropdown menu appears. Look for the option that says Chart (or sometimes Insert Chart) and click it. A dialog box opens showing different chart types.
Do not worry about picking the perfect type right now. Column charts and line charts work for most tables. You can change the type later if the first one does not look right.
Step 3: Pick a chart type and click OK
The dialog shows icons for different chart shapes — columns (vertical bars), lines, pie slices, and others. For most tables with numbers across months or categories, a column chart is the clearest choice. Click the column chart icon, then click the OK button at the bottom of the dialog.
Excel builds the graph and places it on your spreadsheet. The chart sits on top of your table, so you may need to move it to see both clearly. Click the chart and drag it to an empty area of the spreadsheet.
Step 4: Add or fix the chart title
The chart may have a generic title like "Chart Title" or no title at all. To add or change it, click the chart once to select it, then right-click and choose Edit Chart Title (or double-click the title area itself). Type the name you want — something like "Sales by Quarter" or "Monthly Expenses".
You can also right-click the chart and select Chart Title to turn the title on if it is missing, or off if you do not want one. The same menu lets you add labels to the axes (the left side and bottom of the chart) so readers know what the numbers represent.
Step 5: Resize or move the chart as needed
Click the chart once. Small squares appear at the corners and edges. Drag any square to make the chart bigger or smaller. Drag the middle of the chart to move it to a different spot on the spreadsheet. When you click elsewhere on the spreadsheet, the chart stays in place.
If you want to delete the chart, click it once and press the Delete key. The table stays untouched — only the graph disappears.
What happens if you change a number in the table
The chart is linked to your table, which means it watches for changes. If you edit a number in one of the cells you selected, the graph updates automatically within a second or two. You do not have to rebuild the chart or click anything — Excel handles it.
This link only works for cells you included in the original selection. If you add new rows or columns to your table after creating the chart, the graph does not include them unless you edit the chart to add those cells. To do that, right-click the chart, choose Select Data, and add the new range.
Frequently Asked Questions
Can I change the chart type after I create it?
Yes. Right-click the chart and choose Change Chart Type. Pick a different shape — line, pie, bar, area — and click OK. The same data now displays as a different chart type. This is useful if your first choice does not show the pattern you expected.
What if my table has text and numbers mixed together?
Excel treats text as labels and numbers as data to graph. If a column contains both, Excel may skip it or treat it as a label. The safest approach is to keep text in one column (for row names) and numbers in the columns you want to graph. If you have mixed data, create the chart, then right-click it and choose Select Data to tell Excel which columns to use.
How do I add a second set of data to an existing chart?
Right-click the chart and select Select Data. A dialog opens showing which cells are currently in the chart. Click Add and select the new cells you want to include. The chart now displays both sets of data, usually as separate colored bars or lines.
Can I print just the chart without the table?
Yes. Click the chart to select it, then go to File > Print. Excel prints only the selected chart on its own page. If you do not select the chart first, it prints the entire spreadsheet including the table.
What if the chart looks crowded or hard to read?
Make the chart larger by dragging its corners. Right-click the chart and choose Format Chart Area to change colors, fonts, or the background. You can also right-click the axis labels (the numbers on the left or bottom) and choose Format Axis to rotate them or change their size if they overlap.