What a chart does and when to use one
A chart in Excel is a visual picture of your numbers — a bar graph, line graph, pie chart, or other shape that shows patterns your eyes can spot faster than reading a list. If you have organized your data into rows and columns (the way the previous guide showed), Excel can convert that data into a chart in three steps: select the numbers, pick a chart type, and place it on your sheet.
Charts work best when you want to compare amounts across categories (sales by month, expenses by department), show how something changes over time (temperature through the year), or display what fraction each part makes of a whole (market share by company). A chart does not replace your data — it sits on the same sheet and updates automatically if you change the numbers underneath.
Key Takeaways
- Select your data including the row and column headers before inserting a chart, because Excel uses those headers to label the chart automatically.
- The Insert menu holds the Charts section, where you choose a type like Column, Line, or Pie based on what story your numbers tell.
- Excel places the chart on top of your sheet by default, but you can drag it to a blank area or move it to its own sheet to avoid covering your data.
- After you create a chart, you can change its type, add a title, or adjust the data it shows without starting over.
Selecting the data Excel will turn into a chart
Before you insert a chart, you must tell Excel which cells hold the numbers you want to visualize. Open your spreadsheet and look at the data you organized — for example, a list of monthly sales figures with month names in one column and amounts in another, or a table showing product names across the top and sales regions down the left side.
Click on the first cell that contains data you want in the chart. Hold down your mouse button and drag to the last cell, or click the first cell, hold Shift, and click the last cell. Your selection should include the headers (the row or column that names what the numbers represent) because Excel uses those names to label the chart. If your data is scattered across non-adjacent cells, hold Ctrl while clicking each separate block, but this is rare — most organized data sits in one rectangle.
Once the cells are highlighted in blue, you are ready to move to the Insert menu. Do not click elsewhere or the selection will disappear.
Inserting a chart and choosing its type
With your data still selected, click the Insert menu at the top of the Excel window. Look for a section labeled Charts — in newer versions of Excel this appears as a button showing a small bar graph icon. Click it and a menu of chart types will open.
Excel offers several common types. Column charts (vertical bars) work well for comparing amounts across categories — for instance, sales by product or revenue by quarter. Line charts show trends over time, like temperature changes through a year or website traffic month by month. Pie charts display how a whole is divided into parts, such as what percentage of your budget goes to each expense category. Bar charts are horizontal columns, useful when category names are long. Start with Column or Line unless you have a specific reason to choose differently.
Click the chart type you want. Excel will show you subtypes — for example, a basic column chart, a stacked column chart (where bars are divided into segments), or a 3D column chart. The basic version is almost always the right choice. Click it, and Excel will place the chart on your sheet.
Moving and resizing your chart
Excel places the new chart on top of your data by default, which can cover the numbers you just visualized. Click on the chart once to select it — you will see a border around it with small squares at the corners and edges. To move the chart, click anywhere inside it (but not on a specific element like a bar or label) and drag it to an empty area of your sheet, or to the right of your data if space allows.
To resize the chart, click and drag one of the small squares at the corners or edges. Dragging a corner square keeps the chart's proportions the same. Dragging an edge square stretches it in one direction only. Make the chart large enough to read clearly — too small and the labels become hard to see.
If you want the chart on its own sheet separate from your data, right-click the chart, select Move Chart, and choose New Sheet. Excel will create a sheet that holds only the chart. You can switch between sheets using the tabs at the bottom of the window.
Adding a title and labels to your chart
A chart without a title leaves readers guessing what they are looking at. Click the chart to select it, then look for a Chart Design or Design tab that appears in the menu bar — this tab only shows when a chart is selected. Click it and look for an option called Add Chart Element or Chart Title. Click that option and choose Above Chart to place a title at the top.
A text box will appear where you can type a title. Type something that describes what the chart shows — "Monthly Sales 2024" or "Expenses by Department" — then click outside the chart to finish. The title will appear on the chart itself.
You can also add labels to the axes (the lines at the bottom and left side of the chart) to clarify what the numbers represent. In the same Add Chart Element menu, look for Axis Titles and add them the same way. These steps are optional but make your chart much clearer to anyone reading it.
Changing the chart type or data after creation
If you create a chart and then decide a different type would work better, you do not need to start over. Click the chart to select it, then right-click on it and choose Change Chart Type. The same menu of types will open, and you can pick a new one. Excel will redraw the chart when ready using the same data.
If you want to change which cells the chart uses — for example, to include a new column of data or remove a category — right-click the chart and select Select Data. A dialog box will open showing which cells are included. You can add or remove ranges by clicking buttons in that dialog. This is faster than deleting the chart and creating a new one.
If you change the numbers in your original data, the chart updates automatically. You do not need to do anything — Excel watches the cells and redraws the chart whenever a value changes.
Common mistakes and how to avoid them
The most common mistake is selecting data without headers. If you highlight only the numbers and forget the row or column names, Excel will label the chart with generic names like "Series 1" and "Series 2" instead of meaningful labels. Always include the header row or column in your selection.
Another mistake is choosing the wrong chart type for your data. A pie chart only works if your numbers add up to a meaningful whole — use it for budget breakdown or market share, not for sales by month. A line chart works best for data collected over time in order; if your categories have no time sequence, a column chart is usually better.
A third mistake is placing the chart so it covers your data, then forgetting where the data is. Move the chart to the side or below your numbers, or put it on its own sheet. This keeps your data visible and makes it easier to update the numbers later.
Frequently Asked Questions
Can I create a chart from data in different sheets?
Yes, but it is more complex. Select the data on the first sheet, insert the chart, then right-click and choose Select Data. In the dialog that opens, you can add ranges from other sheets by typing the sheet name, an exclamation point, and the cell range — for example, Sheet2!A1:B10. Most of the time, it is simpler to copy the data you need into one sheet first.
What if my chart shows the data sideways from how I intended?
Excel sometimes guesses wrong about whether your categories are in rows or columns. Right-click the chart, select Select Data, and look for a button labeled Switch Row/Column. Click it and the chart will flip. If that fixes it, you are done. If not, click it again to switch back.
Can I print just the chart without the data?
Yes. Click the chart to select it, then go to File and click Print. Excel will print only the selected chart on its own page. If the chart is on its own sheet, you can print that sheet normally and the data sheet will not print.
How do I delete a chart I no longer need?
Click the chart once to select it, then press the Delete key. The chart will disappear, but your data underneath will remain untouched. If you delete a chart by mistake, press Ctrl+Z to undo.
Can I make a chart from data that is not in a neat rectangle?
Not easily. Charts work best when your data is organized in rows and columns with no blank cells in the middle. If your data is scattered, copy the parts you need into a new area of the sheet arranged in a rectangle, then create the chart from that organized version.