How to make a chart in Excel
Interactive walkthrough — 4 steps. Click through at your own pace.
Your version:
AutoSave ●Book1 — Excel—▢✕
HomeInsertPage LayoutFormulasDataViewReviewDraw
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
A1fx
Sheet1Ready100%
Simplified simulation — your Excel may show more buttons.
1
Select the data you want to chart, including the header row — here the range A1:C4 is highlighted.
Steps in text
- Select the data you want to chart, including the header row — here the range A1:C4 is highlighted.
- With the data still selected, click the Insert tab.
- Click Charts and pick a chart type — Column is the most common starting point.
- Excel generates the column chart from your selection — each bar is a row's Sales value.