The basic steps to insert a chart in Excel
To add a graph in Excel, you first select the data you want to visualize, then use the Insert menu to choose a chart type. Excel will create the chart on the same sheet as your data, and you can move it, resize it, or change how it looks.
The process takes about two minutes for a straightforward chart. You do not need to format your data in any special way — Excel reads rows and columns automatically. If your data has headers (like "Month" or "Sales"), Excel uses those as labels on your chart.
Key Takeaways
- Select your data first — include headers if you have them, but do not select empty rows or columns.
- Go to Insert > Chart, then pick a chart type that matches what you want to show (bars for comparison, lines for trends, pie for parts of a whole).
- Excel places the chart on your sheet; right-click it to change the title, add axis labels, or switch to a different chart type.
- You can move a chart by dragging it or resize it by pulling the corners — changes to your original data update the chart automatically.
How to select the right data before inserting a chart
Start by highlighting the cells that contain the numbers and labels you want to show. Click the first cell, then hold Shift and click the last cell to select the whole range. If your data is in separate blocks, hold Ctrl (or Cmd on Mac) and click each block separately.
Include your headers — the row or column that says what each number means. If your data has a blank row or column in the middle, select only the data you want to chart, not the blank space. Excel will ignore empty cells, but selecting them can confuse the chart layout.
For example, if you have months in column A and sales numbers in column B, select both columns including the header row. Do not select column C if it is empty. A straightforward rule: select only the rectangle of data you want to visualize.
Choosing the right chart type for your data
Column or bar charts work best when you want to compare amounts across categories — like sales by region or test scores by class. Bars run horizontally; columns run vertically. Both show the same information; pick whichever looks clearer to you.
Line charts show trends over time — like temperature changes through a year or website traffic month by month. They make it straightforward to see whether something is going up, down, or staying flat.
Pie charts show how parts add up to a whole — like what percentage of your budget goes to rent, food, and utilities. Use them only when you have a few categories (three to five works well; more than seven gets hard to read).
Scatter plots show whether two things are related — like whether taller people tend to weigh more. Each dot represents one data point, and you can see patterns in how the dots spread.
The step-by-step process to insert and customize a chart
| Step | What to do |
|---|---|
| 1 | Select the data you want to chart (headers included). |
| 2 | Click the Insert tab at the top of the ribbon. |
| 3 | Click Chart. A menu appears showing different chart types. |
| 4 | Click the chart type you want (Column, Line, Pie, Scatter, etc.). |
| 5 | Excel inserts the chart on your sheet. Click it to select it. |
| 6 | Right-click the chart to add a title, change colors, or edit axis labels. |
| 7 | Drag the chart to move it; pull the corners to resize it. |
When you right-click a chart, you see options like "Edit Chart Title" and "Format Chart Area." The title box lets you type a name for your chart — something like "Monthly Sales" or "Temperature by Season." Axis labels tell readers what the numbers mean.
If you change the numbers in your original data, the chart updates automatically. You do not have to recreate it. This makes charts useful for tracking information that changes — like a budget you update each month or sales figures you add to weekly.
Moving, resizing, and deleting a chart
To move a chart, click it once to select it, then drag it to a new spot on the sheet. To resize it, click it and drag one of the small squares at the corners or edges. Dragging a corner keeps the chart proportional; dragging an edge stretches it in one direction.
To delete a chart, click it and press Delete. This removes only the chart, not your original data. You can undo a deletion by pressing Ctrl+Z (or Cmd+Z on Mac) right after you delete it.
If you want to print your sheet with the chart, the chart prints along with your data. You can also copy a chart and paste it into another sheet or into a different program like Word or PowerPoint.
Common reasons a chart does not look right
If your chart looks jumbled or shows data you did not intend, you probably selected the wrong cells. Click the chart, then right-click and choose "Select Data." A window opens showing exactly which cells Excel is using. You can add or remove data ranges from there.
If the axis labels are cut off or overlapping, right-click the chart and look for "Format Axis" or "Axis Options." You can rotate the labels or make them smaller so they fit. If your chart type does not match your data — for example, you chose a pie chart for data with many categories — switch to a column or bar chart instead.
If you have blank cells in your data, Excel may skip them or create gaps in your chart. Clean up your data first: remove empty rows and columns, and make sure every cell in your range has a value or a label.
Frequently Asked Questions
Can I change a chart type after I create it?
Yes. Right-click the chart and select "Change Chart Type." A menu appears with all the options. Pick a new type and click OK. Your data stays the same; only the way it displays changes.
What if my data is in two separate columns that are not next to each other?
Hold Ctrl (or Cmd on Mac) and click each column separately to select them both. Excel will chart both columns even though they are not adjacent. Make sure you include the headers for each column.
How do I add a title to my chart?
Right-click the chart and look for "Edit Chart Title" or "Add Chart Title." Click it and type the name you want. The title appears at the top of the chart. You can also format it — change the font, size, or color — by right-clicking the title itself.
Can I use a chart to show data from multiple sheets?
Excel can pull data from other sheets, but it is easier to copy the data you need onto one sheet first, then create the chart. If you want to link to data on another sheet, you can, but the process is more complex and the chart updates only when you open the file.
What should I do if my chart has too many data points and looks crowded?
Try a different chart type — a line chart often works better than a column chart for large datasets. You can also filter your data to show only certain months or categories, then create a chart from the filtered view. Right-click the chart and adjust the axis scale to zoom in on the range that matters most.