Creating a basic chart from your data
To create a chart in Excel, you select the data you want to visualize, then use the Insert menu to pick a chart type. Excel will place the chart on your worksheet right away, and you can move it, resize it, or change how it looks. The whole process takes about a minute once you know where to click.
The chart stays connected to your data, so if you change a number in your spreadsheet, the chart updates automatically. This makes charts useful for spotting trends or comparing amounts at a glance.
Key Takeaways
- Select all the data you want in the chart, including row and column headers, before you start.
- Go to the Insert tab at the top of Excel, then click the chart type you want — column, line, pie, or bar are the most common.
- Excel places the chart on your worksheet immediately, and you can drag it to a new location or resize it with the corner handles.
- Right-click the chart to add a title, change the colors, or adjust which data appears in the legend.
- If your data changes, the chart updates on its own without any extra work from you.
Step 1: Select the data you want to chart
Click on the first cell that contains data you want in the chart. Hold down your mouse button and drag to the last cell. Release the mouse. Your selection should include the labels in the first row and first column — these become the axis labels and legend in your chart.
If your data is not in one rectangle, you can select multiple separate areas by holding Ctrl (or Command on a Mac) and clicking each area. However, starting with a simple rectangular selection is easier if you are new to this.
Step 2: Open the Insert tab and choose a chart type
At the top of Excel, click the Insert tab. You will see a row of icons. Look for the one that says Chart — it usually shows a small bar graph. Click it, and a menu will open showing different chart types.
The most common types are Column (vertical bars), Bar (horizontal bars), Line (points connected by lines), and Pie (a circle divided into slices). Click the type you want, then click the specific style underneath it. Excel will insert the chart into your worksheet right away.
Step 3: Move and resize your chart
The chart appears on top of your data. Click anywhere on the chart to select it — you will see a border around it with small squares at the corners and edges. Drag the chart to move it to a blank area of your worksheet. Drag one of the corner squares to make it bigger or smaller.
If you want to print the chart on its own page or move it to a different worksheet, right-click the chart and choose Cut. Then click a blank area of the worksheet or a new sheet, right-click, and choose Paste.
Step 4: Add a title and labels
Right-click the chart and select Add Chart Element or Chart Title (the exact wording depends on your Excel version). A text box will appear at the top of the chart. Type a title that describes what the chart shows — for example, "Sales by Quarter" or "Monthly Temperature."
You can also add axis titles by right-clicking the chart, choosing Add Chart Element, and then Axis Titles. This is useful when your data is not obvious — for instance, labeling the vertical axis as "Revenue in Dollars" instead of leaving it blank.
Step 5: Change colors and other appearance options
Right-click the chart and look for options like Format Chart Area, Change Chart Type, or Select Data. These let you adjust colors, swap the chart type, or change which data appears in the legend.
If you want to change the color of one bar or line, click the chart once to select it, then click the specific bar or line a second time. Right-click it and choose a color. You can also double-click the chart to enter edit mode, where more formatting options appear in the toolbar.
Common mistakes and how to avoid them
The most common mistake is forgetting to include your headers — the row at the top and column at the left that label your data. Without these, your chart will not know what to call the bars, lines, or slices. Always select from the first cell with a label, not from the first cell with a number.
Another mistake is selecting too much data by accident. If you drag past your actual data and include empty rows or columns, the chart may look wrong or show blank entries in the legend. Double-check that your selection ends exactly where your data ends.
If your chart looks nothing like what you expected — for instance, if you wanted a line chart but got a pie chart — you selected the wrong chart type. Right-click the chart, choose Change Chart Type, and pick the one you meant to use.
Frequently Asked Questions
Can I create a chart from data that is not next to each other?
Yes. Hold Ctrl (or Command on a Mac) and click each separate area of data you want to include. Excel will combine them into one chart. This works best when the separate areas have the same structure — for instance, two tables with the same column headers.
What if I want to change which data appears in my chart?
Right-click the chart and choose Select Data. A dialog box opens showing which cells are included. You can add new cells, remove cells, or change the range. Click OK when you are done, and the chart updates immediately.
Can I make a chart that shows only part of my data?
Yes. Before you insert the chart, select only the rows and columns you want to include. If you already made a chart with all your data, right-click it, choose Select Data, and remove the rows or columns you do not need.
How do I delete a chart I no longer want?
Click the chart once to select it, then press Delete. The chart disappears, but your original data stays in place. If you delete it by mistake, press Ctrl+Z (or Command+Z on a Mac) to undo.
Can I copy a chart to another worksheet or workbook?
Yes. Right-click the chart and choose Copy. Go to the worksheet or workbook where you want it, right-click a blank cell, and choose Paste. The chart will appear in the new location. If the data is in a different workbook, the chart may lose its connection to the original data.