Overview
To make a graph in Excel, select the cells that hold your labels and numbers, open the Insert tab, and choose a chart from Recommended Charts or pick a specific type such as line, column, or bar. Add a title and axis labels, then adjust the data range if anything looks wrong. Excel’s menus usually say “chart,” but for this task a chart and a graph mean the same thing.
That five-part workflow — select, insert, choose, label, adjust — is the backbone of every example below. Microsoft’s own documentation describes the core path the same way: select the data, then choose Insert > Recommended Charts and preview a suggestion before committing (Microsoft Support). The rest of this guide walks through preparing data first, choosing the right chart type, cleaning up labels and axes, editing the data behind a finished graph, and fixing the problems beginners hit most often. Throughout, “graph” and “chart” refer to the same general task unless a specific chart type is named.
Prepare your data before you create the graph
The quality of your graph is mostly decided before you ever click Insert. Excel reads your selected cells literally, so a stray blank row, a merged header, or a number stored as text can quietly break a series or push labels onto the wrong axis. Spending a minute on layout is the single best way to avoid rebuilding the chart later.
A few rules cover almost every beginner case. Give every column a clear header in the top row, because Excel uses those headers for the legend and axis titles. Keep related series in adjacent columns so the whole block can be selected in one drag. Avoid blank rows and blank columns inside the range, and avoid merged cells entirely — merged cells confuse the row-and-column logic Excel relies on. Make sure numbers are actually stored as numbers (right-aligned by default) rather than text, and keep dates in a consistent date format so a time axis can space them correctly.
One more habit pays off later: if your data will keep growing, consider formatting the range as an Excel table before you chart it. Microsoft notes that pre-formatted tables let charts update automatically as new rows are added (Excel graph maker), which spares you from re-editing the range every week.
Sample data layout you can copy
Use this small monthly-sales dataset to follow every step in this article without downloading a file. Type it into a blank worksheet starting at cell A1, with headers in row 1 and values below:
- A1: Month · B1: Product A Sales · C1: Product B Sales
- A2: Jan · B2: 1200 · C2: 900
- A3: Feb · B3: 1500 · C3: 1100
- A4: Mar · B4: 1400 · C4: 1300
- A5: Apr · B5: 1800 · C5: 1500
- A6: May · B6: 2100 · C6: 1700
- A7: Jun · B7: 2000 · C7: 1900
This is the worked example the rest of the guide references. Notice the shape: one label column (Month) and two value columns (Product A Sales, Product B Sales), with clean headers, no blank rows, and numbers stored as numbers. Selecting the whole block A1:C7 gives Excel everything it needs to plot two series against the same months — the exact structure you want for comparing two sets of data.
Create a basic graph in Excel
With the sample data in place, creating the graph itself takes only a few clicks. The reliable approach for beginners is to let Excel suggest a chart first, then refine it, rather than guessing at a chart type from a crowded menu. This mirrors the standard path in Excel’s documentation and in competitor tutorials alike.
Here is the click-by-click sequence using the sample dataset:
- Select the range A1:C7, including the headers.
- Go to the Insert tab on the ribbon.
- In the Charts group, click Recommended Charts to see options Excel has matched to your data (Microsoft Support).
- Preview the suggestions, then pick one — a clustered column or a line chart both work well for monthly sales — and click OK.
- If you would rather choose directly, click a specific icon in the Charts group instead (for example, the Line icon, then Line with Markers, as Excel-Easy demonstrates for a step-by-step line chart on the range A1:D7 in its example — Excel-Easy).
- Drag the finished chart to an empty part of the worksheet so it does not cover your data.
That is the entire core workflow. The graph appears as an object floating over the cells, linked live to the range you selected, so editing the numbers updates the chart. Once it is on the sheet, the next job is choosing whether the type Excel picked actually fits your goal.
Windows, Mac, and Excel for the web steps
The path is broadly the same across platforms, though the exact button labels shift a little by version, so treat the following as the common route rather than a guarantee for every release. On Windows and Mac desktop Excel, the reliable path is Insert > Recommended Charts or the individual chart icons in the Charts group. In Excel for the web, look for the Insert tab and its chart options in the browser ribbon; common chart creation is supported there, even if some advanced formatting differs.
If a menu label does not match what you see, scan the Insert tab for a Charts area — that grouping is consistent even when wording changes. When in doubt, Recommended Charts is the safest starting point on any platform because Excel reviews your selection and suggests types suited to the data (Excel graph maker). Check the exact options in your own interface rather than assuming a specific button exists.
Fast keyboard shortcuts
If you build charts often, two shortcuts skip the menus entirely. With your data range selected, pressing Alt+F1 creates a chart on the current worksheet, while F11 creates one on a separate chart sheet (Excel Charts and Graphs Tutorial). Alt+F1 is handy when you want the graph next to the numbers for a quick look; F11 suits a full-page chart you plan to present on its own. Both use Excel’s default chart type, so the result is a fast starting point you can then refine — availability can vary by version, so confirm the behavior in your copy.
Choose the right Excel graph type for your data
Excel offers many chart types, but the choice comes down to what you are trying to show, not which chart looks nicest. Competitors tend to list chart names without connecting them to a goal, which leaves beginners guessing. The matrix below maps a common analytical goal to a sensible default, using the sample sales data as a reference point.
| Your goal | Best-fit Excel graph | Notes for the sample data |
|---|---|---|
| Show change over time | Line chart | Plot Product A and Product B across the Month column to see trends. |
| Compare categories side by side | Column or bar chart | Compare monthly totals; bar (horizontal) helps when labels are long. |
| Show a numeric relationship | Scatter plot | Use two numeric columns, e.g. Product A vs. Product B, without a category axis. |
| Show parts of a whole | Pie or doughnut chart | Best only when values sum to 100% (Academy of Learning). |
| Show cumulative magnitude over time | Area chart | Emphasizes total volume rather than precise values. |
| Show a distribution | Histogram | Groups numeric values into bins to reveal spread. |
| Mix two chart types or scales | Combo chart | Useful when one series is much larger than another. |
| Summarize large or grouped data | PivotChart | Pairs with a PivotTable for interactive slicing. |
| Show a trend in one small cell | Sparkline | A tiny in-cell line or column, ideal for dashboards. |
Use the matrix as a starting point, then sanity-check the result against your actual message. If the default chart makes your point harder to read, switch types — that is a quick change, not a rebuild.
When to use line, column, bar, scatter, and pie charts
For most beginner decisions, a few plain-language rules settle the choice. Reach for a line chart when the horizontal axis is time and you want to see a trend, which is exactly why the sample month-by-month sales fit a line so well. Choose a column or bar chart when you are comparing distinct categories — column when you have a handful of categories, bar when the category names are long enough to crowd a horizontal axis.
Use a scatter plot when both axes are numeric and you want to see whether two measures move together, rather than tracking a category or a date. Save the pie chart for simple part-to-whole situations where the slices genuinely add up to 100% (Academy of Learning); once you have more than a few slices, a bar or column chart is almost always easier to read. When in doubt, comparing values is usually clearer as bars than as pie slices.
Customize the graph so it is easy to read
A freshly inserted graph is rarely finished. The goal of customization is readability, not decoration — every element you add should help someone understand the data faster, and anything that does not is clutter. Select the chart to reveal the contextual Chart Design and Format tabs, plus the small + (Chart Elements) button beside the chart in desktop Excel, which is where most quick edits live.
Work through the essentials in order: confirm the chart title says what the graph shows, add axis titles if the units are not obvious, check that the legend correctly names each series, and turn on data labels only where exact values matter. Then adjust colors or apply a chart style so related charts across a report look consistent. Resist the urge to add 3D effects or heavy gradients; they distort proportions and make values harder to compare.
Titles, labels, legends, and gridlines
Each chart element answers a specific reader question, so add the ones that help and remove the ones that do not. The chart title tells the reader what they are looking at — to add a chart title in Excel, click the placeholder title and type, or add it from the Chart Elements menu. Axis labels clarify what each axis measures, which matters when the numbers could be dollars, units, or percentages. The legend maps colors to series, so with the sample data it distinguishes Product A from Product B.
Gridlines and data labels are where restraint helps most. Light gridlines aid reading a value against the axis, but dense gridlines plus data labels plus a legend often compete for attention. If your chart already shows exact numbers through data labels, you can usually drop most gridlines. Remove any element that repeats information already visible elsewhere.
Axes, scales, dates, and number formats
Axes are where a technically correct graph can still mislead, so give them a deliberate check. First confirm the value axis scale is honest: a bar chart whose axis starts above zero can exaggerate small differences, so start value axes at zero unless you have a clear reason not to. Double-click an axis to open its formatting options and set the minimum, maximum, and units.
Next, check dates and number formats. If your horizontal axis holds real dates, Excel can treat it as a date axis that spaces points by actual time, versus a category axis that spaces them evenly regardless of gaps — Excel-Easy walks through switching between these axis types in its line-chart example (Excel-Easy). Finally, match the number format to the meaning: apply currency to sales figures, percent to shares, and whole numbers to counts, so the axis and any data labels read the way your audience expects.
Edit the data behind an existing graph
Once a graph exists, you almost never need to delete it and start over to change what it shows. Excel keeps the chart linked to a source range, and you can edit that link directly. This is one of the most useful skills for real work, because reports change and charts should adapt without a rebuild.
The main entry point is the Select Data dialog. Click the chart to select it, open the Chart Design tab, and choose Select Data to see exactly which range feeds the chart, which series are plotted, and which cells supply the horizontal-axis labels. From here you can widen the range, add a series, remove a series, or swap what is plotted on each axis — all without touching the chart’s formatting.
Change the source range, add a series, or switch rows and columns
These three edits cover most day-to-day changes, and each uses the sample dataset so you can practice on it directly:
- Change the source range: Select the chart, open Chart Design > Select Data, and edit the Chart data range so it covers the cells you want — for example, extend it from A1:C7 to include a new month in row 8.
- Add a series: In the same Select Data dialog, click Add under Legend Entries (Series), then point the series values at a new column such as a third product’s sales.
- Switch rows and columns: With the chart selected, click Switch Row/Column on the Chart Design tab to flip whether months or products define the horizontal axis — a fast way to answer “how do I switch the X-axis and Y-axis” for category data.
After any of these edits, glance at the legend and axis to confirm Excel labeled the new arrangement correctly. If a series lands on the wrong axis or picks up a stray header, reopen Select Data and adjust the specific series rather than rebuilding.
Make the graph update when new rows are added
A classic frustration is adding a new row of data and watching the graph ignore it. This happens because the chart is tied to the fixed range you originally selected, so anything below that range sits outside the chart’s view. Manually extending the range each time works but is easy to forget, especially in a report others edit.
The cleaner fix, where it applies, is to format your data as a structured Excel table before charting, since Microsoft notes that pre-formatted tables let charts update as data is added (Excel graph maker). Select your range, use Insert > Table or the Format as Table option, then build the chart from the table. Behavior can still vary by chart type and Excel version, so after adding a row, confirm the new point actually appears before relying on the graph in a presentation.
Fix common Excel graph problems
If you followed the basic steps and the result looks wrong, the cause is usually the data selection or an axis setting, not a bug. Work through this quick checklist before rebuilding anything:
- Blank or nearly empty chart: you likely selected empty cells or text-formatted numbers.
- Missing series or points: a column was left out of the range, or rows are hidden or filtered.
- Wrong axis orientation: rows and columns are swapped — use Switch Row/Column.
- Odd date spacing: the horizontal axis is set to category instead of date, or the reverse.
- Overlapping or crowded labels: too many categories or too many pie slices.
- Chart ignores new data: the new rows fall outside the source range.
Most of these are one-setting fixes once you know where to look. The two sections below cover the causes that trip up beginners most.
Blank graph or wrong data range
A blank or half-empty graph almost always traces back to what was selected. The most common cause is highlighting a range that includes empty cells, or selecting only the numbers and leaving out the header row so Excel has nothing to label. Reselect a clean, continuous block like A1:C7 and re-insert the chart.
The subtler cause is numbers stored as text, which Excel will not plot as values. Text entries sit left-aligned in a cell and are treated as labels rather than data, which can produce a flat or empty series. Convert them to real numbers, and note the specific quirk Excel-Easy flags: if your first cell holds a numeric label, clearing cell A1 before creating the chart can stop Excel from misreading it as a data series (Excel-Easy).
Wrong dates, categories, hidden rows, or overlapping labels
These issues do not blank the chart — they quietly distort what it says. If dates bunch up or space unevenly, the axis type is usually the culprit: a date axis spaces points by real time and will show gaps for missing dates, while a category axis spaces every entry evenly. Double-click the horizontal axis and switch between date and category to match how you want time represented.
Hidden or filtered rows are another silent trap, because by default some charts omit data in hidden cells, so a filtered table can leave points out of the graph without warning. Before presenting a chart, unhide rows or check the chart’s hidden-and-empty-cells setting. For crowded labels, reduce the number of categories, angle the axis labels, or switch a busy pie chart to a bar chart:
- Too many pie slices: small slices overlap or get auto-omitted, so switch to bars.
- Dense category labels: rotate them or thin the categories shown.
- Filtered data: confirm whether hidden rows should be plotted or ignored.
Use the finished graph outside Excel
Most graphs are made to be shared, and the right destination depends on how fixed the message is. For a report or slide deck, the simplest route is to copy the chart from Excel and paste it into Word or PowerPoint; Microsoft notes that Excel charts can be pasted into those apps as images, and that charts linked to live tables can update as the underlying data changes (Excel graph maker). Pasting as a picture keeps the formatting locked, while pasting with a link keeps it current — choose based on whether you want the visual frozen or connected.
Beyond documents, a finished graph can travel as a PDF export through your normal document workflow, or as an image for email and chat. The key decision is whether your audience only needs to see one fixed view, or whether they will want to poke at the numbers themselves.
Static graph or shareable dataset page
When your audience just needs to read a conclusion in a fixed report, a static Excel graph is the right tool — it is stable, self-contained, and easy to drop into a deck or PDF. The tradeoff is that a static image cannot be filtered, sorted, or explored; the reader sees only the slice you chose.
When others need to explore the data — filter rows, inspect the full table, or view generated charts themselves — a shareable interactive dataset page fits better than a flat image. TablePage is one grounded example of that workflow: you can drag and drop CSV, TSV, XLSX, or XLS files, and it instantly generates a public dataset page where anyone can explore charts, insights, and a filterable table with no signup needed, as shown on its demo page. Think of it as an optional next step after Excel, not a replacement for the graphing steps above: build and check your graph in Excel first, then decide whether the finished output should stay a static picture or become a page others can interact with.
FAQs
What is the difference between a chart and a graph in Excel?
In practice, there is no meaningful difference for this task. Excel’s interface and documentation almost always use the word “chart,” while many users say “graph” for the same visual, so the two terms are interchangeable here. The only time the distinction matters is when you name a specific type — a “line graph,” “bar graph,” or “scatter plot” — which points to a particular chart in Excel’s Charts group.
How do I make a graph in Excel with two sets of data?
Put your category column first, then place both value columns directly beside it, exactly like the sample layout with Month, Product A Sales, and Product B Sales in columns A, B, and C. Select the whole block including headers (for example A1:C7), then go to Insert and choose Recommended Charts or a line or column chart. Excel plots both value columns as separate series against the shared category column, and the legend labels them from your headers.
How do I make a graph from non-adjacent cells in Excel?
Select the first range normally, then hold Ctrl (or Cmd on Mac) while selecting the additional ranges you want, so Excel treats the separated cells as one selection before you insert the chart. Make sure each piece lines up — the same number of rows or matching categories — or the series can misalign. For beginners, keeping data in adjacent, well-labeled columns is usually easier to build and maintain, so reorganize the sheet first if you can rather than repeatedly wrangling scattered ranges.
Can I make a graph in Excel for the web?
Yes. Excel for the web supports common chart creation through the Insert tab, so you can select a range and add a standard graph in the browser without the desktop app. That said, some advanced formatting and options differ from desktop Excel and can change by version, so if a specific feature is missing, check your current interface or open the file in desktop Excel for the full set of tools.