How to Make a Graph in Excel From Your Spreadsheet Data

To make a graph in Excel, arrange your information in labeled columns or rows, select the cells you want to plot, then choose Insert > Recommended Charts and select a chart. Excel for Microsoft 365 on Windows will create a chart you can edit, title, and format. A tidy data range and a chart type that suits your question are the main things you need before you start.

What You’ll Need

An Excel workbook with the data you want to show.
Clear column or row headings, such as Month and Sales, so Excel can identify the series and labels.
A basic idea of what you want readers to compare, such as values by category or change over time.

You do not need a special add-in or a formula to make a standard chart. The steps below use Excel for Microsoft 365 on Windows. On Mac, the chart commands are also on the ribbon, though their placement can vary slightly. Excel for the web offers core chart creation and editing, but some advanced formatting options may be limited compared with the desktop app.

Step-by-Step

Put the data into a simple layout. Use one header row and keep each type of information in its own column. For example, put Month in A1 and Sales in B1, then list January through April in A2:A5 and the corresponding sales values in B2:B5. Each row should describe one observation. Avoid blank rows or columns inside the data, merged cells, and totals mixed into the middle of the list. Excel can often handle imperfect layouts, but a consistent range makes it much easier to interpret the chart correctly.
Select the range, including its headings. Click the first cell and drag through the last cell, or click the first cell, hold Shift, and click the last one. In the example, select A1:B5. Including the headings helps Excel use Month as the horizontal category labels and Sales as the series name. If your data is in a continuous block, clicking any cell in the block and using Ctrl+A may select the current region; check the selection before inserting a chart, especially if nearby cells contain other data.
Open the chart recommendations. With the range selected, choose Insert > Recommended Charts. Review the suggestions in the Insert Chart window. Select a chart to see a preview based on your data, then select OK to insert it into the worksheet. Recommended Charts is a useful starting point, not a rule: Excel may suggest a chart that is technically possible but does not communicate your point well. If the suggestions are unsuitable, select the All Charts tab in that window and choose a different chart family.
Choose a chart type that fits the comparison. Use a column chart to compare separate categories, such as sales by product. A line chart is usually clearer when the horizontal labels are ordered time periods and you want to show a trend. A bar chart can make long category names easier to read. Use a scatter chart when both axes represent numeric values and you want to show how two measurements relate. Pie charts work best for a small number of parts that add up to one meaningful whole; avoid them when there are many categories or close values. For the Month and Sales example, a line chart or a column chart is a reasonable choice.
Check that Excel assigned the data correctly. Look at the category labels, series, and plotted values. For the example range A1:B5, the months should appear along the horizontal axis and the sales figures should form one series named Sales. If Excel has plotted the months as a second series, or placed the wrong labels on an axis, select the chart and choose Chart Design > Switch Row/Column. If that does not fix it, use Chart Design > Select Data to inspect the chart data range, series names, series values, and horizontal axis labels.
Add a useful title and labels. Select the chart, then choose Chart Design > Add Chart Element to add a chart title, axis titles, a legend, or data labels. You can also select the plus sign beside the chart in Windows to show or hide common chart elements. Replace a generic title such as Chart Title with a description readers can understand, such as Monthly Sales. Add axis titles when the units are not obvious; for instance, label a vertical axis Revenue ($). Keep labels concise so they do not crowd the chart.
Make the chart easy to read. Select the chart and use the Chart Design and Format tabs to adjust its appearance. Chart Design > Change Colors offers color sets, and Chart Design > Chart Styles provides preset treatments. Use a readable font and enough contrast between the series and the background. If the chart has a legend for only one series, it may be unnecessary; remove it if it adds clutter. Avoid decorative effects that make values harder to compare. Resize the chart by dragging a corner handle, and move it by dragging its border.
Confirm the chart stays connected to the right data. Change a source value and check that the displayed chart updates. If you expect to add rows regularly, consider converting the source range into an Excel table: select a cell in the data and choose Insert > Table, confirm the range, and confirm that My table has headers is selected when appropriate. Charts based on a table generally include new table rows as the table expands. Save the workbook after checking the chart, and make sure the finished chart is on the sheet where readers will expect to find it.

Common Mistakes

Selecting only the numbers: If you leave out headings, Excel may assign generic series names and use numbers instead of meaningful category labels. Include the heading row or column when selecting the source data.

Using a chart that obscures the message: A pie chart with many slices, a line chart for unrelated categories, or a 3-D chart can make comparisons less clear. Choose a chart based on the kind of comparison, not just its appearance. For precise comparisons among categories, a simple bar or column chart is often easier to read.

Including totals or blank lines in the plotted range: A grand-total row can distort the scale, while blank rows may create gaps or odd category labels. Keep summary totals separate from the observations unless the total is deliberately part of the chart.

Leaving misleading labels or units: A chart titled Sales does not tell readers whether values are dollars, units, or thousands. Add the relevant period and unit, and check that the axis scale is appropriate. A truncated vertical axis can exaggerate small differences in a column chart, so inspect the scale before presenting it.

Tips

Decide what question the graph should answer before choosing a design. If it is “Which product sold the most?”, compare categories with bars or columns. If it is “How did sales change each month?”, use an ordered time axis, often with a line chart.
Keep the source data rectangular and consistent. Use one heading per column, avoid putting notes in the middle of the range, and use the same units throughout a series. Dates should be actual Excel dates rather than text that merely looks like a date.
Make important comparisons visible without relying on color alone. Use direct data labels or clear legend names when readers might have difficulty distinguishing series. A restrained palette is easier to interpret than a different bright color for every point.
For a chart that needs to travel with a report, place it near the source data or on a dedicated chart sheet. To move it, select the chart and choose Chart Design > Move Chart, then select an object in a worksheet or a new chart sheet.
Check the result at the size readers will see it. Long category names can become cramped, and a chart that looks clear while enlarged may be difficult to read when printed or pasted into a presentation.

Troubleshooting

The chart is blank or missing some values: Check that the intended cells were included in the selected range and that the values are stored as numbers, not text. A number aligned or behaving like text may not plot as expected. Also check for hidden rows or columns: some charts omit hidden data by default. Select the chart, open Chart Design > Select Data, and inspect the source range. In the Select Data Source window, the Hidden and Empty Cells options can help you control whether hidden data is displayed.

The labels and series are reversed: Select the chart and choose Chart Design > Switch Row/Column. This is useful when your categories are arranged across columns rather than down rows. If the result is still wrong, use Select Data to edit the series and category label ranges directly. Confirm that each series uses the intended heading and that the category labels do not include an unrelated row.

New rows do not appear in the graph: The chart may be based on a fixed cell range that ends above the new data. Select the chart and check Chart Design > Select Data to see the current range. Extend the range to include the added rows, or convert the source data to an Excel table before adding future records. Keep new entries directly beside or below the table so Excel can recognize them as part of it.

The chart looks crowded or the axis is confusing: Remove unnecessary data labels or gridlines, shorten category names in the source data, or make the chart wider. If dates are shown as separate text labels, check that Excel recognizes them as dates and that the chart type suits a time series. For a value axis, right-click the axis and choose Format Axis to review its bounds and units. Use a scale that makes differences understandable without overstating them.

You cannot find a command: Click the chart first; Chart Design and Format are contextual tabs and may not appear when a worksheet cell is selected. In Excel for Mac, the same chart-related tabs and options are available, but ribbon placement may differ. In Excel for the web, use the chart options that appear after selecting the chart; if a specific advanced setting is unavailable, open the workbook in the desktop version.

Frequently Asked Questions

Can I make a graph in Excel without selecting the headings?
Yes, but it is usually better to include them. Headings give the chart meaningful series names and category labels. Without them, you may need to correct generic labels or edit the data source afterward.

What is the best graph type for data over time?
A line chart is a common choice for showing a trend across ordered dates or time periods. A column chart can work well when you want to compare individual periods. Use whichever makes the changes easiest to read, and keep the time labels in chronological order.

How do I change the graph after creating it?
Select the chart and use Chart Design > Change Chart Type to switch its type. To change its plotted cells, choose Chart Design > Select Data. You can edit the title by selecting it and typing replacement text, and use Chart Design > Add Chart Element to add or remove labels and other elements.

Will the graph update when I change the source values?
Yes. A chart linked to worksheet cells updates when those values change. If you add data outside the chart’s source range, however, the new rows may not appear automatically. Expand the source range or use an Excel table for a growing list.

Can I create a graph from non-adjacent columns?
Yes. Select the first range, then hold Ctrl on Windows while selecting the additional range, including its headings. Insert the chart and inspect the result because non-adjacent selections can be interpreted differently depending on the layout. On Mac, use Command instead of Ctrl when making a multi-range selection.

Can I copy the graph into Word or PowerPoint?
Yes. Select the chart, press Ctrl+C on Windows, open the destination document, and press Ctrl+V. On Mac, use Command+C and Command+V. Depending on the paste options, the chart may remain linked to the workbook or be inserted as a picture; choose the option that suits whether it needs to update with the source data.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.