How To Make A Graph On Microsoft Excel

To make a graph in Microsoft Excel, arrange your data in labelled columns, select the cells you want to plot, and open the Insert tab. Choose a chart type, then add a descriptive title and any necessary axis labels. Save the workbook to keep the.

Arrange your data before creating the graph

Excel calls graphs charts. Before inserting one, decide what you want the reader to see: a comparison between categories, a change over time, a share of a total, or a relationship between measurements.

For a simple monthly sales graph, put Month in cell A1 and Sales in B1. Enter the months below the first heading and the corresponding sales figures beside them. Each row should describe the same period or category across all columns.

• Use clear column headings so Excel can identify the data series.
• Keep values numeric. Apply currency or percentage formatting rather than typing explanatory words into value cells.
• Keep units consistent within each series.
• Exclude totals unless you deliberately want to compare them with individual categories.
• Check missing values rather than replacing them with zero: a missing measurement and a measured zero mean different things.

Choose a chart that suits the question

The chart type determines which comparisons are easy to make. Start with a simple option rather than choosing a style for its appearance.

A line chart and a scatter chart are not interchangeable. Scatter charts use numeric values on both axes, which matters when the spacing between x values varies. Microsoft explains this distinction in its guide to scatter and line charts.

Create your first Excel graph

The following steps use the desktop ribbon. Excel for the web also creates charts from Insert, although its editing controls differ.

1. Select the data range, including its headings. For the monthly sales example, select the Month and Sales columns only as far as the last populated row.
2. Open Insert and find the Charts group.
3. Choose a chart type, such as a clustered column or line chart. Alternatively, open Recommended Charts, preview a suggestion and select OK.
4. Check that the category labels and values match the worksheet. If months appear as separate series, try Chart Design > Switch Row/Column.
5. Drag the chart to a clear area of the worksheet and resize it using its corner handles.

Microsoft's chart creation instructions cover the desktop and browser workflows. You can change the chart type later if the first choice makes comparisons difficult.

Add titles, labels and readable formatting

Name the chart and its axes

Select the chart title and replace the placeholder with a description such as Monthly sales by region. Include the reporting period where it helps the reader interpret the figures.

In desktop Excel, select the graph and choose Chart Design > Add Chart Element > Axis Titles. Add the relevant horizontal or vertical title, then type the label into its box. Include units such as Sales (AUD) or Distance (km). Pie charts have no axes, so they do not need axis titles.

Use labels and colour selectively

Choose Chart Design > Add Chart Element > Data Labels to display values directly on a desktop chart. Labels help when exact figures matter, but can overlap on a crowded graph. Keep a legend when readers need it to distinguish multiple series.

Use consistent colours for the same categories across your report. Keep text legible at the size the chart will actually appear, and avoid decorative effects that make values harder to compare. For bar and column charts, a zero baseline usually gives the clearest comparison of bar lengths.

Add a trendline when it answers a question

For a supported chart, select the data series and choose Chart Design > Add Chart Element > Trendline. A linear trendline shows a fitted straight-line pattern; a moving average smooths fluctuations. Choose a method that suits the data rather than treating the default as proof of a trend.

A trendline does not establish cause or guarantee future results. Displaying its equation is a separate option, not an automatic result of adding the line.

Update the graph when your data changes

Editing a value within the chart's existing source range updates the graph. Adding another row outside that range may require you to extend the selection.

1. Enter the new data beside or below the existing dataset.
2. Right-click the chart and choose Select Data.
3. Update the source range to include the new cells, keeping the headings included.
4. Confirm the selection and check the new categories and values on the chart.

If the graph is empty or missing a series, check that you selected numeric values as well as labels. If the legend shows unhelpful names, check the column headings and the series names in Select Data.

Save the workbook and share the graph

Save the Excel workbook to retain the editable chart and source cells. Selecting the graph before saving is unnecessary. For a report or presentation, you can copy the chart and paste it into the destination document.

For a separate image, follow Microsoft's chart picture export instructions. Keep the workbook too: an exported image will not update when the worksheet changes.

If the graph is going into a Word report with columns, the guide to typing in the second column in Microsoft Word can help with the surrounding text layout.

If you are also moving your Office setup to another computer, check the guide to transferring a Microsoft Office product key before making changes to your installation. More application walkthroughs are available in the Microsoft Office guides.

Open your worksheet, select one labelled dataset and create a simple chart. Check its plotted values against the source cells before sharing it.