Excel charts turn rows of numbers into pictures you can actually read
A chart in Excel takes the data you've organized in columns and rows and displays it as a bar graph, line graph, pie chart, or other visual format. Instead of scanning a spreadsheet of monthly sales figures, you see at a glance whether sales went up or down. Excel does the drawing for you once you select your data and pick a chart type — you don't need to be able to draw or use separate software.
The basic process takes about two minutes: highlight the cells containing your numbers and labels, click the Insert menu, choose a chart type, and Excel creates it on your spreadsheet. You can then move it, resize it, and change how it looks. Most people use charts to spot trends, compare amounts, or show someone else what the data means.
Key Takeaways
- Select your data first — include the row or column labels that explain what the numbers represent, because Excel uses these as chart labels.
- Go to Insert > Chart, pick your chart type (bar, line, pie, or column are the most common), and Excel creates it when ready on your sheet.
- Click the chart once to select it, then drag it to move it or use the corner handles to resize it without distorting the image.
- Right-click the chart to add a title, change colors, or adjust the axis labels so someone reading it understands what they're looking at.
- Save your file as you normally would — the chart saves with it and updates automatically if you change the numbers in your data.
Select the data you want to chart before you start
Open the spreadsheet containing your data. Highlight all the cells you want to include in the chart — this should be the numbers themselves plus the labels that describe them. For example, if you have months listed in column A and sales amounts in column B, select both columns including the header row.
You can select non-adjacent cells by holding Ctrl (or Command on Mac) and clicking each section, but for most charts it's easier to select one continuous block. Excel will use the text in your first row or column as the chart labels, so make sure those cells contain clear descriptions like "January," "February," or "Product A," "Product B" rather than blank cells or abbreviations you'll have to decode later.
Insert a chart and choose the type that fits your data
With your data selected, click the Insert menu at the top of the screen. Look for the option labeled Chart (in newer versions of Excel it may say "Insert Chart" or show a small chart icon). Click it, and a dialog box opens showing different chart types.
The most common types are: Column (vertical bars, good for comparing amounts), Bar (horizontal bars, useful when category names are long), Line (shows trends over time), and Pie (shows parts of a whole, like percentages that add to 100%). Click the type you want, then click the specific style within that type if options appear. Excel creates the chart and places it on your spreadsheet.
Move and resize your chart to fit your layout
The chart appears as a box on your spreadsheet. Click once on the chart to select it — you'll see a border around it with small squares at the corners and edges. To move it, click and drag the chart itself to a new location. To resize it, click and drag one of the corner squares — dragging a corner keeps the chart proportions correct, while dragging an edge stretches it in one direction.
Most people place charts to the right of their data or below it, leaving the original data visible so someone can see both the numbers and the visual. If your chart covers important data, move it to an empty area of the sheet or to a different sheet in the same file.
Add a title and labels so the chart makes sense
Right-click on the chart and select Add Chart Title (or look for a "Chart Elements" button if you're using a newer version). Type a clear title like "Monthly Sales 2024" or "Budget vs. Actual Spending." This title appears at the top of the chart and tells anyone looking at it what they're seeing.
You can also right-click to add axis titles — for example, labeling the vertical axis as "Sales in Dollars" or the horizontal axis as "Month." These labels prevent confusion about what the numbers represent. If your chart has a legend (a box showing what each color or bar represents), you can move or hide it by right-clicking and selecting legend options.
Change colors and formatting if the default doesn't work for you
Right-click the chart and look for options like Format Chart Area or Change Colors. You can change the background color, the color of individual bars or lines, and the font used for labels. Most of the time the default colors work fine, but if you're printing in black and white or presenting to a specific audience, you may want to adjust them.
You can also double-click specific parts of the chart — like a bar or a line — to format just that element. For instance, double-clicking one bar lets you change only that bar's color, which is useful if you want to highlight a particular month or category that stands out.
Update your chart when your data changes
If you go back and change any of the numbers in the cells you originally selected, the chart updates automatically. You don't have to delete it and create a new one. This is why it's important to keep your data and chart on the same sheet or in the same file — Excel watches the original cells and redraws the chart whenever those numbers change.
If you need to add more data (for example, a new month of sales), select the chart, right-click, and choose Select Data. You can then expand the range of cells the chart is using, and the new data appears in the chart when ready.
Frequently Asked Questions
Can I make a chart from data on different sheets?
Yes. When you select your data, you can include cells from multiple sheets by holding Ctrl and clicking cells on each sheet before inserting the chart. Excel will pull data from all the sheets you selected and combine them into one chart.
What if my chart looks wrong or shows the data sideways?
Right-click the chart and select Select Data. You'll see which cells Excel is using for the chart. If rows and columns are swapped, look for a Switch Row/Column button and click it. This flips how Excel interprets your data.
Can I delete a chart without deleting my data?
Yes. Click the chart once to select it, then press Delete. The chart disappears but your original numbers stay in the spreadsheet. If you delete it by mistake, press Ctrl+Z (or Command+Z on Mac) to undo.
How do I copy a chart to another file or email?
Click the chart to select it, press Ctrl+C to copy, then open the other file or email and press Ctrl+V to paste. The chart appears as an image in the new location. If you paste it into another Excel file, you can edit it the same way.
What's the difference between a column chart and a bar chart?
Column charts have vertical bars (good for time periods or short category names), while bar charts have horizontal bars (better when your labels are long). Both show the same data — it's just a matter of which direction makes your chart easier to read.