How to Make a Graph in Excel (Step by Step)
To make a graph in Excel, select your data (including the headers), open the Insert tab, and pick a chart type — for example Insert → Column or Bar Chart. Excel creates the chart instantly, and you can drag it anywhere on the sheet. Here’s the full walkthrough, plus how to fix a graph that comes out wrong.
Step by step: make your first graph
- Enter your data in two columns — for example, months in column A and sales in column B.
- Select the range, including the header row (e.g.
A1:B13). - Go to the Insert tab.
- In the Charts group, click the chart type you want — Column, Line, or Pie.
- Pick a style from the dropdown. The chart appears on the sheet.
- Drag the chart to position it, and drag its corner handles to resize.
Click once on the chart to move it, and double-click inside it to edit elements like the title, axis, or legend.
Which chart type should you use?
| You want to show… | Use |
|---|---|
| Compare values across categories | Column or Bar |
| A trend over time | Line |
| Parts of a whole | Pie (or Donut) |
| Relationship between two numbers | Scatter (XY) |
| Distribution of values | Histogram |
If you’re unsure, Column is the safest default. Excel also has a Recommended Charts button on the Insert tab that suggests a type based on your data.
Customize your graph
With the chart selected, the Chart Design and Format tabs appear:
- Chart title: click the “Chart Title” text and type your own.
- Axis titles: Chart Design → Add Chart Element → Axis Titles to label X and Y.
- Data labels: Add Chart Element → Data Labels to print numbers on the bars.
- Colors: Chart Design → Change Colors for a preset palette.
- Legend: Add Chart Element → Legend to move or hide it.
Fix a graph that looks wrong
| Problem | Fix |
|---|---|
| Categories show as 1, 2, 3 instead of names | Right-click the chart → Select Data, then set Horizontal (Category) Axis Labels to your label column |
| One bar instead of several | Put each series in its own column, not stacked in one cell |
| Chart shows the wrong range | Drag the highlighted range outline on the sheet to cover the right cells |
| Blank chart | Your selected cells hold text, not numbers — check the data |
Graph vs. chart in Excel
In Excel, chart is the official term — what most people call a graph is exactly the same object. So “how to make a graph in Excel” and “how to make a chart in Excel” are the same task. Google Sheets handles it slightly differently — see how to make a chart in Google Sheets.
Make a graph update automatically
If you’ll keep adding rows, format your data as a Table first (Ctrl + T). Charts built on a Table expand automatically as you add rows — no need to re-select the range. For large datasets, a pivot table summarises the data before you chart it, and sorting the source (see how to sort in Excel) keeps categories in a sensible order.
FAQ
How do I make a graph in Excel?
Select your data including headers, go to the Insert tab, and choose a chart type from the Charts group (e.g. Column). Excel plots it immediately.
What’s the difference between a chart and a graph in Excel?
Nothing — Excel calls them charts. “Graph” is the everyday word for the same object.
How do I add a title or axis labels to an Excel chart?
Select the chart → Chart Design → Add Chart Element → choose Chart Title, Axis Titles, or Data Labels.
Why is my Excel chart showing the wrong data?
Right-click the chart → Select Data and check the range, or drag the highlighted outline on the sheet. Text in a cell won’t plot.
How do I make a graph in Excel that updates automatically?
Format your source data as a Table (Ctrl + T) before inserting the chart. The chart then expands with new rows.
Related guides
Google Sheets Formulas for Beginners (10 You Need to Know)
The 10 essential Google Sheets formulas every beginner needs — SUM, AVERAGE, COUNT, IF, and more, with working examples.
How to Add Checkboxes in Google Sheets (Tick Boxes)
Add checkboxes in Google Sheets with Insert → Checkbox, set custom checked/unchecked values, and count ticks with COUNTIF or a progress bar.
How to Create a Drop-Down List in Excel (Data Validation)
Add a drop-down list in Excel with Data Validation — pick from a typed list or a range on another sheet, and fix the errors that stop it working.