Excel charts turn your numbers into pictures
A chart in Excel takes the data you have organized in rows and columns and displays it as a visual — a bar chart, line graph, pie chart, or dozens of other types. The chart updates automatically when you change the numbers underneath it, so you can build it once and keep using it as your data changes. Most charts take under a minute to create once you know where to click.
The fastest way is to select the numbers you want to show, click the Insert menu, pick a chart type, and let Excel build it. You can then move it around your spreadsheet, resize it, and change how it looks. The chart stays linked to your original data — if you update a number in your table, the chart updates too.
Key Takeaways
- Select your data first — the numbers you want to display, plus the row or column labels that describe what they are.
- Go to Insert, then Charts, then pick the type that matches what you want to show: bars for comparing amounts, lines for trends over time, pie for parts of a whole.
- Excel places the chart on your sheet; drag it to move it, or right-click it to change colors, labels, and titles.
- The chart stays connected to your data, so updating a number in your table automatically updates the chart.
- You can copy a chart to another sheet or paste it into Word or PowerPoint, and it will still update when you change the original data.
Select the data you want to show
Before you insert a chart, highlight the cells that contain the numbers and labels you want to display. Click the first cell, then drag to the last cell you want to include. If your data is not in one rectangle — for example, if you want to skip a column — hold Ctrl while you click and drag to select multiple separate areas.
Include the row or column headers (the labels that say what each number means). If your first row says "Month" and "Sales", include that row in your selection. Excel uses these labels to name the parts of your chart, so leaving them out makes the chart harder to read.
If you have a large table and only want to chart part of it, select only the columns and rows you need. For example, if you have sales data for ten products but only want to compare the top three, select just those three rows plus the header row.
Insert a chart from the Insert menu
With your data selected, click the Insert menu at the top of the screen. Look for the Charts section — it usually shows small icons of different chart types. Click on the type you want: Column (vertical bars), Bar (horizontal bars), Line, Pie, Area, or Scatter. Excel will show you variations of that type.
Pick the specific style you want — for example, a regular column chart or a stacked column chart where bars are divided into sections. Click it, and Excel will place the chart on your sheet. The chart appears as a large box with your data already plotted inside it.
If you are not sure which type to use, Column and Line are the most common. Use Column to compare amounts across categories (sales by region, for example). Use Line to show how something changes over time (temperature by month). Use Pie only if you are showing parts of a single total that add up to 100 percent.
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 sheet so it does not cover your data. Drag a corner square to resize it while keeping the same proportions, or drag an edge square to stretch it in one direction.
If the chart is too small to read, make it larger. If it takes up too much space, make it smaller. You can always adjust the size later if you change your mind. Position it where you have room — often to the right of your data table or below it.
Change the chart title and labels
Right-click on the chart and select Edit Chart (or double-click the chart to enter edit mode). At the top of the chart, you will see a text box that says "Chart Title" — click it and type a name for your chart. This title should describe what the chart shows: "Sales by Region" or "Monthly Website Visits", for example.
To add or change axis labels (the names of the sides of the chart), right-click the chart, look for Chart Elements or Axis Titles, and add text there. The vertical axis (left side) usually shows the numbers being measured. The horizontal axis (bottom) usually shows the categories or time periods. Label both so anyone reading the chart knows what they are looking at.
You can also add a legend — a box that explains what each color or bar represents. Most charts include one automatically, but you can turn it on or off by right-clicking the chart and finding the Legend option.
Change colors and chart style
Right-click the chart and look for Format Chart Area or Design options. You can change the background color, the colors of the bars or lines, and the overall style. Click on a specific bar or line in the chart to change just that element's color, or use the Design tab to change the whole chart at once.
Excel includes preset styles that change colors and fonts together. If you want your chart to match a report or presentation, pick a style that fits. You can also manually change individual colors by right-clicking a bar or line and selecting Format Data Series.
Update your chart when data changes
The chart is connected to the cells you selected. If you change a number in your original data table, the chart updates automatically — you do not have to rebuild it. This is why charts are useful for data you update regularly. Build the chart once, then update the numbers underneath whenever you have new data.
If you add new rows or columns to your data table and want the chart to include them, you need to update the chart's data range. Right-click the chart, select Edit Data, and drag to include the new cells. After that, the chart will include the new data automatically.
Copy a chart to another sheet or document
Click the chart to select it, then press Ctrl+C to copy it. You can paste it into another sheet in the same workbook, or into a Word document or PowerPoint presentation. The chart will still be connected to the original data in Excel — if you change a number in the source spreadsheet, the chart updates everywhere you pasted it.
If you want to paste the chart into a different Excel file, the connection to the original data will break. In that case, the chart becomes a static image that does not update. Copy the data table along with the chart if you want the chart to stay live in the new file.
Frequently Asked Questions
What if my data is in two separate areas of the spreadsheet?
Hold Ctrl and click-drag to select the first area, then while still holding Ctrl, click-drag to select the second area. Excel will treat both as part of the same chart data. Make sure both areas have headers so Excel knows what each column represents.
Can I make a chart that shows multiple different types at once, like bars and lines together?
Yes. Right-click the chart, select Change Chart Type, and look for Combo or Mixed chart types. You can assign different data series to bars, lines, or areas. This is useful when comparing two measurements with different scales — for example, temperature and rainfall on the same chart.
How do I remove a chart?
Click the chart to select it and press Delete. The chart disappears, but your original data stays in place. You can always insert a new chart from the same data later.
What happens to my chart if I move or delete the data it is based on?
If you delete the data, the chart will show an error. If you move the data to a different location in the same file, the chart usually updates automatically. If you move the data to a different file, the chart loses its connection and becomes a static image.
Can I print just the chart without the data table?
Yes. Click the chart to select it, then go to File and Print. Excel will print only the selected chart. If you do not select the chart first, it will print the entire sheet including the data table.