Creating a graph from Excel data in three steps
Excel can turn your spreadsheet numbers into a visual chart without any special software or skills. You select the data you want to show, click the Insert menu, choose a chart type, and Excel builds the graph for you. The whole process takes about two minutes for a basic chart.
The graph appears on the same sheet as your data, and you can move it, resize it, or change how it looks afterward. If your numbers change, the graph updates automatically. This is useful when you are organizing files because a chart can show patterns in your data that rows of numbers hide — you might spot a trend in sales, expenses, or inventory at a glance.
Key Takeaways
- Select the cells containing your data before you insert a chart, including the row or column headers that label what the numbers mean.
- Excel offers column charts, line charts, pie charts, and bar charts as the most common types; column and line charts work best for data that changes over time.
- After you insert a chart, you can click it to edit the title, change the chart type, or adjust which data it displays.
- Charts stay linked to your spreadsheet, so if you update a number in your original data, the chart reflects the change automatically.
Select your data before you insert the chart
Open your Excel file and look at the data you want to graph. The data should be organized in columns or rows, with a header row or column that labels what each number represents. For example, if you have months across the top and sales numbers below, that layout works. If your data is scattered randomly across the sheet, reorganize it into a straightforward table first.
Click on the first cell of your data and drag to the last cell that contains a number you want to include. Your selection should form a rectangle. If your data has a header row with labels like "January," "February," "March," include that row in your selection — Excel uses those labels to identify what each part of the chart represents. Do not select empty cells or data you do not want graphed.
Insert a chart from the Insert menu
With your data selected, click the Insert tab at the top of Excel. Look for a button labeled Chart or Insert Chart — the exact name varies slightly depending on your Excel version. Click it, and a dialog box opens showing you different chart types.
Excel highlights a column chart by default, which is the right choice for most data. A column chart displays your numbers as vertical bars, making it straightforward to compare values. If your data shows change over time — like sales month by month — a line chart works better because it shows the trend as a connected line. A pie chart shows how parts add up to a whole, useful for showing percentages. A bar chart is the same as a column chart but with horizontal bars instead of vertical ones. Choose the type that matches what your data shows, then click OK or Insert.
Move and resize your chart on the sheet
Excel places the new chart on your spreadsheet, usually overlapping your data. Click the chart once to select it — you will see a border around it with small squares at the corners and edges. Click and drag the chart to move it to an empty area of your sheet where it does not cover your numbers. Drag one of the corner squares to resize the chart larger or smaller.
If you want the chart on its own separate sheet instead of mixed with your data, right-click the chart and look for an option like Move Chart. This opens a dialog where you can choose to put the chart on a new sheet by itself. This is useful if your spreadsheet is large and you want to keep your data and graph separate for printing or sharing.
Edit the chart title and labels
Double-click the chart to enter edit mode — the border changes and you see additional options. Look for the chart title at the top of the graph. Click on the title text to select it, then type a new title that describes what the chart shows. For example, change a generic title to "Monthly Sales 2024" or "Quarterly Expenses by Department."
You can also click on the axis labels — the numbers running up the side or across the bottom — to format them. Right-click any part of the chart to see options for changing colors, fonts, or the legend (the box that explains what each bar or line represents). When you are done editing, click outside the chart to exit edit mode and return to your normal spreadsheet view.
Update your chart when your data changes
If you go back and change a number in your original spreadsheet, the chart updates automatically. You do not have to recreate it or do anything special. This is why charts are useful for tracking data over time — you can add new months or new sales figures to your spreadsheet, and the graph grows with it.
If you want to add more data to an existing chart, click the chart to select it, then right-click and choose Edit Data or Select Data. This opens a dialog where you can expand the range of cells the chart includes. Select a larger area of your spreadsheet, and the chart will incorporate the new numbers.
Choose the right chart type for your data
The chart type you pick should match what your data is trying to show. A column or bar chart works best when you are comparing amounts across categories — like sales by region, or expenses by department. A line chart is better for trends over time, like temperature changes through the year or website traffic month by month. A pie chart shows percentages of a whole, useful for showing what portion of your budget goes to each expense category.
If you pick the wrong type, you can change it. Click the chart, right-click, and look for Change Chart Type. Select a different type and click OK. Your data stays the same; only the visual format changes. Experiment with different types to see which one makes your data easiest to understand at a glance.
Frequently Asked Questions
Can I create a chart from data that is not in one continuous block?
Excel works best with data in a single rectangle, but you can select non-adjacent cells by holding Ctrl (or Cmd on Mac) while clicking separate areas. However, this often confuses the chart. It is simpler to rearrange your data into one continuous block first, then create the chart.
What if my chart does not show all my data?
Click the chart, right-click, and choose Select Data. A dialog opens showing which cells the chart is using. Expand the range to include the data you want. Make sure you selected enough cells when you first created the chart, including all rows and columns you wanted graphed.
Can I print just the chart without the spreadsheet data?
Yes. Click the chart to select it, then go to File and Print. Excel will print only the selected chart. If you want to print the chart on its own page, move it to a separate sheet first using the Move Chart option.
How do I change the colors in my chart?
Double-click the chart to enter edit mode. Click on one of the bars or lines in the chart itself, right-click, and choose Format Data Series or Format Data Point. A panel opens where you can pick new colors, change the fill style, or adjust other visual elements.
What happens if I delete the original data after creating a chart?
The chart will break because it no longer has data to display. Always keep your original spreadsheet data intact. If you want to hide the data from view, move the chart to a separate sheet instead of deleting the numbers.