Converting Excel data to a graph takes three steps: select the numbers you want to show, pick a chart type, and place it on your spreadsheet
A graph turns rows and columns of numbers into a picture your eye can read in seconds. Excel can build that picture for you automatically. You choose which data to include, Excel chooses where to put the bars or lines, and you can move or resize the result just like any other object on the page.
The process works the same way in Excel on Windows, Excel on Mac, and Google Sheets. The names of the buttons change slightly, but the three core steps stay identical: select, insert, and adjust.
Key Takeaways
- Select the cells containing the numbers and labels you want the graph to show before you insert the chart.
- Excel works best when your data has labels in the first row or first column — it uses those labels for the graph's axis and legend.
- A bar chart works for comparing amounts across categories; a line chart works for showing change over time.
- After you insert the chart, you can move it, resize it, or double-click it to change the title, colors, or data included.
Select the data you want to graph
Click on the first cell that contains a number or label you want in the graph. Hold down the mouse button and drag to the last cell. When you release, all the cells in between are highlighted in blue. This selection is what Excel will turn into a graph.
Include the row or column that holds your labels — the words that describe what each number means. If your data has months across the top (January, February, March) or product names down the left side (Apples, Oranges, Bananas), include those cells in your selection. Excel uses these labels to build the axis and legend, which makes the graph readable without you having to add them by hand.
If your data is scattered across the sheet with empty cells in between, select only the block you need. Excel will graph whatever you highlight, so a messy selection makes a messy graph.
Insert the chart and let Excel choose the type
In Excel on Windows, go to the Insert tab at the top of the screen. You will see a button labeled Chart (or sometimes Recommended Charts). Click it.
Excel will show you a list of chart types: Column, Bar, Line, Pie, Area, and others. For most data, a Column chart (vertical bars) or Bar chart (horizontal bars) is the right choice. A Column chart works well when you are comparing amounts across categories — sales by region, test scores by class, rainfall by month. A Line chart works when you want to show how something changes over time — temperature rising through the day, website visits growing week by week.
Click the chart type you want. Excel will insert it into your spreadsheet right away. The chart appears as a box with your data displayed inside. You can now move it, resize it, or change what it shows.
Move and resize the chart on your spreadsheet
Click anywhere on the chart border (the edge of the box). Four arrows appear in the corners and middle of each side. Drag a corner arrow to make the chart bigger or smaller while keeping its shape. Drag a side arrow to stretch it in one direction only.
To move the chart to a different spot on the sheet, click on the chart and drag it. The chart stays selected (you will see the border and arrows) until you click somewhere else on the spreadsheet.
Change the chart title and other details
Double-click the chart to open it for editing. The chart border turns a different color and you see new buttons appear at the top of the screen. Click on the title text at the top of the chart to select it, then type a new title that describes what the graph shows.
Right-click on any part of the chart — the bars, the axis numbers, the legend — to see options for changing colors, fonts, or what data is included. For most purposes, the default colors and layout work fine. Change them only if the graph is hard to read or if you need it to match a specific style.
When you are done editing, click somewhere outside the chart to close it. The chart is now part of your spreadsheet and will move or copy along with it if you move or copy the data.
Choose the right chart type for your data
A Column chart uses vertical bars to compare amounts. Use it when you have categories (regions, products, time periods) and want to see which one has the most or least. It is the most common chart type and usually the first choice.
A Bar chart is the same as a Column chart but with horizontal bars instead of vertical ones. It works better when your category names are long — "Northeast Region" and "Southwest Region" fit more easily on a horizontal axis than a vertical one.
A Line chart connects points with lines instead of showing bars. Use it when your data moves over time and you want to see the trend — whether something is going up, down, or staying flat. Line charts are harder to read when you have only two or three data points, so use them when you have at least five or six.
A Pie chart shows how a total is divided into parts. Use it only when your numbers add up to a meaningful whole — percentages of a budget, market share, or how time is spent. Do not use a pie chart to compare unrelated amounts.
Fix common problems with your chart
If the chart shows the wrong data, double-click it to open it for editing. Look for a button labeled Select Data (in Excel on Windows) or Data Range (in Google Sheets). Click it and you can change which cells the chart includes. Select the correct range and click OK.
If the axis numbers or labels are cut off or hard to read, double-click the chart and right-click on the axis itself (the numbers along the bottom or left side). Choose Format Axis and you can change the font size, angle, or range of numbers shown.
If you have multiple sets of numbers and the chart is too crowded, you may need to use a different chart type. A Line chart often works better than a Column chart when you are comparing three or more series of data, because lines do not overlap the way bars do.
Frequently Asked Questions
Can I change the chart type after I insert it?
Yes. Double-click the chart to open it for editing, then right-click on the chart itself and choose Change Chart Type. Pick a new type from the list and click OK. Your data stays the same; only the way it is displayed changes.
What if my data has text and numbers mixed together?
Excel will graph only the numbers. Text in the cells you selected becomes labels on the axis or legend. If a cell contains both text and numbers (like "50 units"), Excel will ignore that cell. Separate your text labels from your numbers into different cells.
Can I add a chart to a document outside of Excel?
You can copy a chart from Excel and paste it into Word, PowerPoint, or Google Docs. Right-click the chart in Excel, choose Copy, then go to your document and paste it. The chart becomes an image in the new document, so changes you make in Excel later will not update the copy.
How do I add a second set of data to an existing chart?
Double-click the chart to open it for editing, then click Select Data. In the dialog box, click Add to add a new series. Select the cells containing the new data and give the series a name. Click OK and the new data appears on the chart.
What is the difference between a chart and a graph?
In everyday use, the words mean the same thing. In Excel, the word "chart" is official — you will see it in menus and buttons. A chart is any visual display of data, whether it uses bars, lines, pie slices, or other shapes.