How to Create Charts and Graphs in Excel: Every Type, Step by Step
Published October 18, 2026 · By Ahmad Parvez
Making a chart in Excel and making a good chart in Excel are two different skills. The mechanics are easy — select, insert, done. The part that trips people up is choosing the wrong type: a pie chart with twelve slices, a line graph for categories, a column chart for a timeline. This guide covers both: the 60-second method, a decision table for which chart fits which data, and honest step-by-step instructions for every chart type people actually search for — pie, bar, line, scatter, Gantt, waterfall, combo, and the statistical charts.
Everything here works in desktop Excel (Microsoft 365 / Excel 2021 / 2019 / 2016). Excel for the web handles the core charts (column, bar, line, pie, scatter) the same way; the built-in statistical charts and a few power features are desktop-only, and those are flagged below.
The 60-second method: insert a chart in Excel
- Lay out your data. One column of labels (categories, dates, or names), one or more columns of numbers, headers in the first row. If your numbers are buried in raw rows, summarize them first — totals by category with
SUMIFS, or let our Excel Formula Builder write the summary formula for you. - Select the range, headers included. To plot a graph from a table, just click any cell inside a formatted Excel Table — the chart will even grow automatically when you add rows.
- Go to Insert → Charts and click a chart type. Not sure which? Click Recommended Charts — the beginner shortcut. Excel scans your data, suggests chart types with live previews, and you click the one you like.
- Polish it. With the chart selected, two new tabs appear: Chart Design (styles, layouts, Switch Row/Column, Move Chart) and Format (colors, effects, sizes). The + button at the chart's top-right (Chart Elements) adds titles, labels, legends, and trendlines.
Two keyboard shortcuts worth memorizing: Alt+F1 turns the selected data into a column chart on the same sheet instantly, and F11 creates the chart on a brand-new chart sheet.
Which chart type should you use?
This is the decision most guides bury. Use this table before you insert anything — it covers the chart-vs-graph question at a glance (in Excel, "chart" and "graph" mean the same thing):
| What you're showing | Use this | Avoid |
|---|---|---|
| Comparing totals across categories | Column or bar chart | Pie — slices can't be ranked at a glance |
| Change over time | Line graph (dates on the x-axis) | Pie chart; columns work but lines show trends better |
| Parts of one whole | Pie or doughnut, 5–6 slices max | More than 6 slices — switch to a bar chart |
| Relationship between two numbers | Scatter (XY) plot | Line chart — lines imply a sequence that may not exist |
| Two series on very different scales | Combo chart (column + line, secondary axis) | Two separate charts side by side |
| How values are distributed | Histogram | Column chart — it looks similar but counts categories, not bins |
| Project schedule / task timeline | Gantt chart (stacked-bar workaround) | Line chart — timelines aren't trends |
| How a total builds up or drains away | Waterfall chart | Stacked bars — waterfalls show the running total better |
How to make a column or bar graph in Excel
Columns are vertical, bars are horizontal — that's the only difference. Use columns when categories run left to right (especially time), and bars when your category labels are long (they read better on the side). To build one: select your labels and values, go to Insert → Column or Bar Chart, and pick a style.
- Clustered column / bar: the default. Compares values side by side — e.g., sales by region, or two years next to each other (this is the "double bar graph").
- Stacked column / bar: stacks the parts in one column so you see the total and the mix at once. Use the 100% stacked variant when you care about shares, not totals.
- Bar graph with two variables: put both value columns next to the label column and use a clustered bar — or jump to a combo chart if the scales differ.
If your columns came out as the series and your series came out as the columns, click the chart and hit Chart Design → Switch Row/Column. That fixes most "my bar chart looks wrong" problems in one click.
How to make a line graph in Excel
Line graphs show change over time: one date column, one or more value columns. Select the range, Insert → Line Chart, and pick Line with Markers if you want the data points visible. To plot multiple lines, just include more value columns — Excel draws one line per column.
Dates on the x-axis need real dates. If your line jumps evenly across months even though some months are missing from the data, Excel is treating your dates as text categories. Convert them to real date values (Text to Columns works, or DATEVALUE), then right-click the axis → Format Axis → set Axis Type to Date axis.
A line graph with two variables on wildly different scales gets unreadable — that's the cue for a combo chart instead.
How to make a pie chart in Excel
Select one column of labels and one column of values, then Insert → Pie Chart. Keep it to about five slices; merge the small ones into an "Other" slice so the chart stays readable.
- Explode a pie chart: click a slice, click it again (two single clicks, not a double-click) so only that slice is selected, then drag it outward. Or right-click the slice → Format Data Point → set Point Explosion.
- Rotate a pie chart: right-click the pie → Format Data Series → change the Angle of first slice.
- Change pie chart colors: select the chart → Chart Design → Change Colors, or format individual slices via Format Data Point → Fill.
- Donut (doughnut) chart: Insert → Pie → Doughnut. Same idea as a pie with a hole in the middle — useful when you want the total in the center.
If your pie has more than six categories, don't fight it: a bar chart sorted largest to smallest communicates the same data far better.
How to make a scatter plot (XY graph) in Excel
An XY graph and a scatter plot are the same thing in Excel. Put your x-values in the first column and y-values in the second (both numeric — no text), select both columns, and go to Insert → Scatter. Excel plots each row as a point, which is exactly what you want when you're looking for a correlation.
- Trendline + equation: click a series → Chart Elements (+) → Trendline → More Options → tick Display Equation on chart and Display R-squared value on chart. Need the slope as a reusable number? The
SLOPEfunction gives it to you — our Excel Formula Builder can write it. - Graph a function or plot an equation: make an x column (say −10 to 10), a y column with your formula, and use Scatter with Smooth Lines. That's how you draw any
y = f(x)curve. - Bubble chart: Insert → Scatter → Bubble. A third column controls the bubble size — population on a GDP-vs-life-expectancy plot is the classic example.
How to make a Gantt chart in Excel
Honest answer first: Excel has no built-in Gantt chart. The standard method is a stacked-bar workaround, and it works well:
- Build three columns: Task, Start date, Duration (days). Duration is just
=End − Start— have the Excel Formula Builder write it if date math isn't your thing. - Select Task + Start + Duration → Insert → Bar Chart → Stacked Bar.
- Click the Start-date series → Format Data Series → No fill. It becomes invisible, leaving only the duration bars floating at the right start positions.
- Click the vertical axis → Format Axis → check Categories in reverse order, so Task 1 sits at the top instead of the bottom.
- Tidy the horizontal axis (it's a date axis — set sensible bounds) and add data labels if you want durations shown on the bars.
The same stacked-bar skeleton builds burndown-style timelines too — see the waterfall section below.
Statistical charts: histogram, box & whisker, and Pareto
Excel 2016 and later (including Microsoft 365) ships built-in statistical charts under Insert → Statistic Chart. These are desktop features — if the menu is missing in Excel for the web, use the desktop app.
- Histogram: select a single column of numbers → Insert → Statistic Chart → Histogram. Excel bins the values automatically; right-click the bars → Format Data Series to change bin width or bin count.
- Box and whisker plot: select grouped numeric data → Insert → Statistic Chart → Box and Whisker. Shows the five-number summary (min, quartiles, median, max) plus outliers per group — the standard for comparing distributions.
- Pareto chart: select categories + values → Insert → Statistic Chart → Pareto. Excel sorts the bars descending and overlays the cumulative-percentage line — the 80/20 analysis chart, ready made.
Stem-and-leaf plot: Excel has no built-in one. The honest options are a small formula table that bins your values, or — for most purposes — a histogram, which answers the same "what does the distribution look like?" question. A residual plot is simpler: it's just a scatter plot of residuals versus predicted values, built with the scatter method above.
How to make a waterfall chart in Excel
Waterfall charts show how a starting value builds up or drains to an ending value — cash flow, inventory, profit bridges. Select your category and value columns, then Insert → Waterfall, Funnel, Stock, Surface, or Radar Chart → Waterfall (Excel 2016+). Select the final column's point → Format Data Point → check Set as total so it renders as the total bar. (A "bridge chart" is the same thing under a different name.)
Burndown chart: build a small table with your dates, an "Ideal" column (straight line from total to zero), and an "Actual" column (remaining work per day), then insert a line chart. Two series, one story: are you above or below the ideal line?
Combo charts: two data sets, two axes
When you need to graph two sets of data with different scales — revenue in millions and conversion rate in percent — a combo chart puts them on one chart with two y-axes:
- Put both series in one table and insert any chart.
- Right-click the chart → Change Chart Type → open the Combo tab.
- Pick a chart type per series (e.g., Clustered Column for revenue, Line for conversion rate) and tick Secondary Axis for one of them.
This is also how you combine (overlay) two graphs into one, and how you add a vertical or horizontal line to a chart: add a helper column holding a constant value (a target, an average, a deadline date), then make that series a line on the combo chart. The same trick draws target lines and average lines on any chart type.
Customize your chart: labels, titles, legends, error bars
Select the chart and click the + (Chart Elements) button at its top-right — most customization lives there:
- Chart title / axis titles: Chart Elements → check Chart Title and Axis Titles, then click the text to type. Double-click any title to format it.
- Data labels: Chart Elements → Data Labels → choose position, or More Options for number formatting and label contents.
- Legend (the key): Chart Elements → Legend → position (top, bottom, left, right). To add a legend to a chart that has none, or to rename legend entries, see below.
- Change legend text / rename a series: right-click the chart → Select Data → pick the series → Edit → type a name or click a cell containing it. Legend text comes from series names, so editing the column header in your source data works too.
- Change chart style: Chart Design → Chart Styles gallery, plus Change Colors for palettes. To format anything deeper, right-click it → Format (axis, data series, plot area, chart area).
- Tick marks and gridlines: right-click an axis → Format Axis → Tick Marks (major/minor, inside/outside/cross); gridlines come from Chart Elements → Gridlines, with spacing set under Format Axis → Units.
- Change the axis scale: right-click the value axis → Format Axis → set Bounds (min/max) and Units (major/minor). For a logarithmic or semi-log graph, tick Logarithmic scale here.
- Alt text: right-click the chart → Edit Alt Text, so screen readers (and search engines) can describe it.
- Move a chart: drag it anywhere on the sheet, or Chart Design → Move Chart to put it on its own chart sheet.
- Lock it in place: once a dashboard looks right, lock the sheet so charts can't be dragged or resized by accident.
How to add error bars in Excel
Select the chart → Chart Elements (+) → Error Bars → More Options. The Format Error Bars pane gives you the full menu: Fixed value, Percentage, Standard deviation(s), Standard error, or Custom — where you can specify different positive and negative values, even individual error bars for single data points. Direction can be Both, Minus, or Plus, and bar charts can show horizontal error bars as well as vertical ones. This is the same machinery behind forest plots: a scatter chart with custom error bars.
Edge cases that break Excel charts (and the fixes)
- Blank cells create gaps. Right-click the chart → Select Data → Hidden and Empty Cells → choose Gaps, Zero, or "Connect data points with line." Lines with missing weeks are the classic victim.
- Hidden rows aren't plotted. Excel excludes hidden rows and columns from charts by default. Tick "Show data in hidden rows and columns" in the same Hidden and Empty Cells dialog to include them — and see our unhide guide if you can't find the missing rows.
- Dates on the x-axis must be real dates, not text. Text dates get spaced evenly like categories, which silently distorts time series. Convert with Text to Columns or
DATEVALUE, then set the axis to Date axis. - Pie charts with more than ~6 categories are unreadable. Merge small slices into "Other," or switch to a sorted bar chart.
- Duplicates inflate your chart. Repeated rows double-count in bar heights and pie slices. Clean them with our remove-duplicates guide before you chart.
- Charts refresh themselves. Charts are live-linked to their data — change a number and the chart updates instantly. There is no manual refresh button, and you don't need one. To widen the data feeding a chart, click it and drag the blue selection border, or right-click → Select Data → edit the Chart data range.
Twelve more charts, briefly and honestly
Donut chart
Insert → Pie → Doughnut. A pie with the middle cut out — handy when you want the total or a KPI sitting in the center.
Radar chart
Insert → Other Charts → Radar. Compares several variables on spokes from a center point — the classic skills-profile chart.
Org chart
Not a data chart at all: Insert → SmartArt → Hierarchy. Pick a layout, type names into the text pane, done.
Flow chart
Also drawn, not plotted: Insert → Shapes → Flowchart shapes, then connect with arrows. For data-driven process visuals, a timeline scatter works better.
Control chart
Build it from a line chart: add helper columns for the average and the upper/lower control limits, then plot all three as lines.
Thermometer chart
One value versus a goal: make a 100% stacked column with the value and the remainder, then hide the remainder series. Instant fundraising thermometer.
Bell curve
Add a NORM.DIST column beside your x-values and plot with Scatter with Smooth Lines. Have the Excel Formula Builder write the NORM.DIST formula.
Population pyramid
A mirrored bar chart: make one side's values negative, plot as a bar chart, and format the axis to show positive labels on both sides.
Sunburst chart
Insert → Hierarchy Chart → Sunburst (2016+). Multi-level parts-of-a-whole — like a pie chart that handles hierarchy.
Timeline chart
Put dates in one column and event names in another, then use a scatter plot with a date axis — or SmartArt's timeline layouts for a quick visual.
Supply & demand graph
Two crossing line series: quantity on the x-axis, price on the y-axis, one line per curve. Straight from any economics textbook.
Dot plot
A scatter plot with categories on one axis and values on the other — cleaner than a bar chart when you have many categories.
A few honest notes on the long tail: a "football field" valuation chart is just a stacked-bar visual with extra formatting — the combo-chart method above is the starting point. Graph paper in Excel isn't a chart at all: square up the cells (match row height to column width) and the gridlines do the rest. And Lineweaver–Burk plots are double-reciprocal scatter plots with a trendline — the scatter section covers the mechanics.
Want an interactive chart — a dropdown that switches the data being plotted? Build the selector with our dropdown-lists guide, point the chart at the dropdown-driven cells, and the chart updates when the selection changes.
Frequently asked questions
How do I add error bars in Excel?
Click the chart, then click the "+" (Chart Elements) button in the top-right corner of the chart and check "Error Bars." Choose "More Options" to open the Format Error Bars pane, where you can use a fixed value, a percentage, standard deviations, or fully custom values - even different values for each data point. Vertical error bars are the default; bar charts can also show horizontal ones.
How do I change the series name or legend text in an Excel chart?
Right-click the chart and choose "Select Data." Pick the series in the list, click "Edit," and either type a new name or click a worksheet cell that contains the name. The legend updates automatically, because legend text comes from your series names - so the fastest fix is often to just edit the column header in your source data.
How do I move a chart to its own sheet in Excel?
Click the chart, go to the Chart Design tab, and choose "Move Chart." Select "New sheet," name it, and click OK. Excel moves the chart to a dedicated chart sheet that prints cleanly on its own page. Use the same button to move it back onto your data sheet.
How do I combine two graphs into one chart in Excel?
Put both data series in one table and insert any chart from it. Then right-click the chart and choose "Change Chart Type." Open the "Combo" tab and assign a different chart type to each series - for example, clustered column for one and line for the other. If the series use very different scales, tick "Secondary Axis" for one of them so both stay readable.
Can I chart data that has blank cells or hidden rows?
Yes. For blank cells, right-click the chart, choose "Select Data," and click "Hidden and Empty Cells." You can show blanks as gaps, as zeros, or connect the line across them. Hidden rows and columns are left out of charts by default - tick "Show data in hidden rows and columns" in the same dialog if you want them included.
How do I add a trendline and show the equation on a graph in Excel?
Click a data series, then click the "+" (Chart Elements) button and check "Trendline." Click the small arrow next to "Trendline" and choose "More Options." In the Format Trendline pane, tick "Display Equation on chart" and "Display R-squared value on chart." If you need the slope as a number you can reuse elsewhere, build it with the SLOPE function - our Excel Formula Builder can write that formula for you.
How do I save an Excel chart as an image?
Right-click the outer border of the chart - not the plot area inside it - and choose "Save as Picture." Save as PNG for the cleanest result. It is the fastest way to drop an Excel chart into a presentation, a document, or a web page.
How do I add data to a chart I already made?
Click the chart and drag the blue selection border on your worksheet to cover the new rows or columns - Excel expands the chart instantly. Or right-click the chart, choose "Select Data," and edit the "Chart data range" box, or click "Add" to attach a brand-new series.
How do I switch the x and y axes in an Excel chart?
On the Chart Design tab, click "Switch Row/Column." This swaps which dimension becomes the data series and which becomes the categories, and it fixes most mixed-up charts. For a scatter plot where you need to swap the actual x and y value ranges, right-click the chart, choose "Select Data," select the series, click "Edit," and swap the "X values" and "Y values" boxes.
Related guides
- Excel Formula Builder — build the SUMIFS, SLOPE, and NORM.DIST formulas that feed your charts.
- How to Remove Duplicates in Excel — clean your data before charting so totals aren't inflated.
- How to Create Dropdown Lists in Excel — build an interactive selector that drives your charts.
- How to Lock and Protect Sheets in Excel — stop finished charts from being dragged or resized.
- How to Unhide Rows and Columns in Excel — find the hidden data your chart is ignoring.