How to make a graph in Excel
To make a graph in Excel, select your data including the headers, go to Insert > Recommended Charts and pick one. Excel draws it on the sheet, and you can change the title, colors and labels afterwards. This guide shows the steps, how to choose between column, line and pie charts, and how to fix the most common problems.
In Excel, a graph and a chart are the same thing. Practice picking the right type and cleaning up the result in the chart lessons linked at the end.
1. Lay out the data
Put the labels in the first column, such as months or product names, and the values in the columns next to them, with a header above each column. Keep the block free of blank rows and total rows, because Excel would draw those as bars too. For one series, two columns are enough. For several lines, add one column per series.
2. Insert the chart
Select the whole block, then go to Insert and click a chart type, or click Recommended Charts to see a preview with your own data. The fastest route is to press Alt+F1, which draws a column chart on the same sheet, or F11, which puts a chart on a new sheet of its own.
3. Pick the right chart type
Use a column or bar chart to compare categories, such as sales by region. Use a line chart for a trend over time, such as sales by month. Use a pie chart only for parts of one whole with a few slices, and make sure the values add up to a total that makes sense. Use a scatter chart to see whether two numbers move together. If the type looks wrong, select the chart and choose Chart Design > Change Chart Type.
4. Label and clean up
Click the chart, then click the plus button next to it to add or remove elements. Give the chart a title that says what the reader should see, add axis titles when the units are not obvious, and delete the legend if there is only one series. Format the axis numbers with the same number format as your cells, such as a currency or a percent sign. Remove gridlines and extra colors that do not help.
5. Keep the graph in step with the data
A chart follows its cells, so changing a number moves the bar. To make new rows appear automatically, turn the data into an Excel table (Ctrl+T) before you insert the chart. The chart then grows with the table. To copy the chart into a slide or a document, paste it as a picture if you do not want it to change.
Common mistakes
Years plotted as a data series. When the first column holds numbers such as years, Excel draws them as a line of their own.
Fix: Store the years as text, or choose Select Data and set the years as the horizontal axis labels.
A pie chart with too many slices. More than five or six slices cannot be read.
Fix: Use a bar chart sorted from largest to smallest instead.
Including the total row. The total is drawn as a bar that dwarfs the others.
Fix: Select only the rows you want to compare, and keep totals outside the chart range.
Frequently asked questions
How do I switch the rows and columns of a chart?
Click the chart and choose Chart Design > Switch Row/Column. Excel swaps which data is drawn as the series and which as the categories.
How do I add a second axis?
Select the series, open Format Data Series and choose Secondary Axis. Use it when two series have very different scales, such as revenue and a percent.
Can I make a chart with a formula result?
Yes. A chart reads the values of its cells, whether they are typed or calculated, so it updates when a formula such as SUM changes.
Related functions
- SUMSUM adds up numbers, cells and whole ranges in one formula.
- AVERAGEAVERAGE returns the arithmetic mean of numbers or a range, skipping text and empty cells.
- ROUNDROUND rounds a number to a set number of digits; ROUNDUP and ROUNDDOWN always round away from or toward zero.
- TEXTTEXT turns a number or date into text in the format you choose, such as 2 decimals, 12,500 or 2026-03-18.
More on Excel charts
The guide covers the steps and the main chart types. This piece adds how to choose the data for a chart so it draws correctly, how to make the message clear, and how to keep a chart from lying.
Shape the data so the chart draws itself
Most chart problems start in the cells. Excel reads the first row as the series names and the first column as the labels, and it expects numbers everywhere else. A blank corner cell is normal. A total row, a note in the middle of the block or numbers stored as text will each break the chart in a different way.
If you need a calculated column, such as a margin, add it next to the data with a formula like =B2-C2 and include it in the selection. The chart will follow the formula result when the source numbers change.
Make the chart say one thing
- Write a title that states the point, such as "Sales fell in March", instead of the label "Sales".
- Sort bar charts from largest to smallest unless the categories have a natural order, such as months.
- Remove what does not help: gridlines, a legend for a single series, and decorative effects.
- Use one color for the data and a second color only for the bar you want the reader to notice.
Do not let the axis mislead
Excel may start a column chart's axis above zero, which makes a small change look huge. Right-click the vertical axis, choose Format Axis and set the minimum to 0 for bar and column charts. Lines can use a tighter range, but then say so in the title. A second axis can make two unrelated series look related, so use it only when the units truly differ.
To practice, open [the charts lesson](/learn/charts) and then see how [number formats](/learn/number-formats) change the axis labels.