How to Make a Chart in Excel (Step by Step)
To make a chart in Excel, select your data, open the Insert tab, and pick a chart type from the Charts group — or use Recommended Charts to let Excel choose. Here is how to build, choose, and format the right chart.
A chart turns a wall of numbers into something people can understand at a glance. The good news: Excel builds one for you in just a few clicks, and you rarely have to start from scratch. Here is the fastest way to do it, plus how to pick a chart that actually fits your data.
How to insert a chart in Excel
- Select the data you want to chart, including the row and column headers.
- Go to the Insert tab on the ribbon.
- In the Charts group, click a chart type (Column, Line, Pie, and so on), or click Recommended Charts to let Excel suggest the best fit.
- Pick a style from the preview and click OK. The chart appears on your sheet, ready to move and resize.
Choosing the right chart type
The chart type matters more than the colors. Match it to the story your data tells:
| Chart type | Best for |
|---|---|
| Column or Bar | Comparing values across categories (sales by product) |
| Line | Showing a trend over time (revenue by month) |
| Pie | Parts of a whole, with only a few slices (budget split) |
| Scatter (XY) | The relationship between two numbers (price vs. sales) |
Format and customize your chart
Once the chart is on the sheet, click it to reveal the chart tools. Two controls do most of the work:
- The + (Chart Elements) button next to the chart adds or removes titles, data labels, gridlines, and the legend.
- The Chart Design tab lets you change the chart type, swap colors and styles, and switch the rows and columns if the axes look wrong.
Always give the chart a clear title that states the takeaway ("Sales grew 20% in Q4"), not just the data name. A good title is what makes a chart useful to someone who did not build it.
Chart from a summary, not raw data
Charts look best when they sit on top of a clean summary rather than hundreds of raw rows. The easiest way to build that summary is a pivot table in Excel, which groups and totals your data for you. You can then chart the pivot table directly. If you are pulling values from another sheet to build that summary, VLOOKUP is the tool for the job.
Frequently asked questions
What is the fastest way to make a chart in Excel?
Select your data and press Alt+F1. Excel instantly creates a default column chart on the same worksheet, which you can then change or format. Press F11 instead to put the chart on its own dedicated sheet.
How do I change the chart type after creating it?
Click the chart, open the Chart Design tab, and choose Change Chart Type. Pick a new type from the gallery and click OK — your data stays the same, only the visual changes.
Why is my Excel chart empty or wrong?
Usually the wrong range is selected, or text is mixed in where numbers should be. Click the chart, choose Select Data on the Chart Design tab, and confirm the range covers your headers and values with no stray text cells.