Excel can turn your organized data into a chart in three steps
Once you have your data organized in columns and rows — the way you learned in the previous guide — Excel can create a graph from it without any special tools or add-ons. You select the data, click the Insert menu, choose a chart type, and Excel builds it for you. The whole process takes less than a minute for a basic chart.
The chart lives in the same spreadsheet as your data, so when you update the numbers, the graph updates automatically. You can move it around, resize it, and change how it looks without touching the original data.
Key Takeaways
- Select your data including the column headers, then go to Insert and choose Chart to start the process.
- Excel suggests a chart type based on your data shape, but you can pick a different one — column charts work for most comparisons, line charts for trends over time.
- The chart updates whenever you change the numbers in your spreadsheet, so you do not have to rebuild it.
- You can move, resize, and reformat the chart by clicking on it, without affecting the data underneath.
Select the data you want to chart
Start by highlighting all the cells that contain the numbers you want to show, plus the labels at the top of each column. If you have a spreadsheet with months across the top and product names down the left side, select from the first label all the way to the last number in the bottom right.
Click on the first cell you want to include, then hold Shift and click on the last cell. Excel will highlight everything in between. If your data is not in one rectangle — for example, if you have gaps or separate sections — you can hold Ctrl (or Command on Mac) and click to select multiple separate areas, but a single rectangle is simpler and usually what you want.
Do not include extra rows or columns beyond your data. If you have notes or totals below the data, leave those out of the selection.
Open the Insert menu and choose Chart
With your data selected, click the Insert tab at the top of the Excel window. You will see a button labeled Chart in the toolbar. Click it.
Excel will open a dialog box showing you different chart types. The first option, Column Chart, is highlighted by default. This type works well for comparing values across categories — for example, sales by region or test scores by student. If your data shows change over time, Line Chart is usually better. If you want to show parts of a whole, pick Pie Chart.
Click the chart type you want, then click OK or Create (the button name varies by Excel version). Excel will place the chart on your spreadsheet right away.
Move and resize the chart on your spreadsheet
The chart appears as a box on top of your data. You can drag it to a blank area so it does not cover your numbers. Click anywhere on the chart border and drag it to the right or below your data table.
To make it bigger or smaller, click on the chart and look for small squares at the corners and edges. Drag a corner square to resize the chart while keeping its proportions. Drag an edge square to stretch it in one direction only.
If you want to delete the chart and start over, click on it and press Delete. The data stays in place.
Change the chart title and labels
By default, Excel may label your chart "Chart Title" or leave it blank. Double-click on the chart to enter edit mode — you will see a gray border around it. Then double-click on the title text itself to edit it. Type a name that describes what the chart shows, like "Sales by Quarter" or "Monthly Website Traffic".
To change the axis labels (the text along the bottom and left side), right-click on the chart and look for an option like Edit Data or Select Data. This opens a dialog where you can confirm which column contains your category names and which contains your values. Most of the time Excel gets this right on its own, but you can fix it here if the labels are wrong.
When you are done editing, click outside the chart to exit edit mode.
Update the data and watch the chart change
The chart is linked to your original data. If you change a number in one of the cells you selected, the chart updates when ready. If you add new rows of data below your original selection, the chart does not automatically include them — you would need to edit the chart's data range to add those rows.
To add new data to an existing chart, double-click the chart to enter edit mode, right-click and choose Select Data, then adjust the range to include the new cells. This is why organizing your data in one clean block from the start makes updates easier later.
Choose the right chart type for your data
Column charts work best when you are comparing amounts across categories that do not have a natural order — regions, departments, product types. The height of each bar makes the comparison straightforward to see at a glance.
Line charts are better for data that changes over time — monthly sales, daily temperatures, quarterly revenue. The line shows the trend, making it straightforward to spot whether things are going up, down, or staying flat.
Pie charts show how a total is divided into parts — what percentage of your budget goes to each department, or how many customers fall into each age group. Use them only when you have a few categories (three to five works well; more than seven gets hard to read).
Bar charts are column charts rotated sideways. They work well when your category names are long, because there is more room to write them along the left side.
Frequently Asked Questions
Can I change the chart type after I create it?
Yes. Double-click the chart to enter edit mode, then right-click on it and choose Change Chart Type. Pick a new type and click OK. Your data stays the same; only the way it is displayed changes.
What if my data has blank cells?
Excel usually handles blank cells by leaving a gap in the chart. If you have missing data, it is better to delete the blank row or column entirely before creating the chart, rather than leaving empty cells in the middle of your data.
Can I make the chart look different — change colors or fonts?
Yes. Double-click the chart to edit it, then right-click on different parts — the bars, the title, the background — to format them. You can change colors, fonts, and styles. Most formatting options are in the right-click menu or in the Design and Format tabs that appear when the chart is selected.
How do I copy a chart to another spreadsheet or document?
Click on the chart once to select it (not double-click), then press Ctrl+C (or Command+C on Mac) to copy. Open the other spreadsheet or document and press Ctrl+V to paste. The chart pastes as an image, so it will not update if you change the original data.
What happens if I add rows to my data after the chart is made?
The chart does not automatically include new rows. Double-click the chart, right-click and select Select Data, then expand the range to include the new rows. This is why it helps to leave a few blank rows below your data when you first set it up.