Microsoft Office

Microsoft Excel How To Make A Graph

To make a graph in Microsoft Excel, select the cells containing your labels and values, open the Insert tab, and choose a chart type. Use a column or bar chart to compare categories, a line chart to show change over time, or a pie chart.

Which licences fit your PC setup?

Prices are an AUD snapshot, not a live quote. Confirm variant and total on the listing.



Prepare your data before inserting a chart

Arrange your data in a simple grid with a heading for each column. Put category labels, such as months or product names, in the first column and the corresponding values in the next. For several related data series, give each series its own column and heading.

For example, a monthly sales worksheet could have Month in column A, Online sales in column B, and Shop sales in column C. Keep the same unit throughout each series so that the comparisons make sense.

  • Check that amounts are stored as numbers rather than text.
  • Put dates in chronological order when showing a trend.
  • Leave grand totals out of a chart that compares the individual categories making up that total.
  • Use short, descriptive headings so the chart legend is understandable.

Choose a graph that answers your question

Choose the chart type according to what readers need to compare. The following choices reflect Microsoft's guidance on available chart types.

What you want to show Chart type When it works well
Differences between categories Column or bar Comparing sales by product, team or region. Horizontal bars give long category names more room.
Change over time Line Showing a sequence such as monthly sales or quarterly costs.
Parts of a whole Pie Showing one series with a small set of non-negative values that belong to the same total.
A relationship between numerical measurements XY scatter Plotting paired values, especially when the horizontal values are unevenly spaced.

Start with a plain two-dimensional chart. Decorative effects can make values harder to compare. If pie slices look similar, a bar chart usually makes their differences easier to judge.

Create your first graph in Excel

These steps use the desktop ribbon. Controls can differ in Excel for the web; Microsoft's chart creation guide also covers browser controls.

  1. Select the complete data range, including the column headings and category labels.
  2. Open Insert and find the Charts group.
  3. Choose a chart type. For a category comparison, select Insert Column or Bar Chart, then Clustered Column. For a time trend, choose a standard line chart.
  4. Review the inserted chart. Check that its category labels and legend match the selected cells.
  5. Drag the chart border to move it away from your data, then drag a corner handle to resize it.

For the monthly sales example, select the Month column and both sales columns to compare the two sales channels. Select only Month and one sales column if you want a single series.

To try another presentation, select the chart and use Chart Design, then Change Chart Type. You can compare alternatives without re-entering the worksheet data.

Add titles, labels and readable formatting

Explain the chart with a specific title

Click the chart title and replace the placeholder with a description of the measure and period. A title such as Monthly sales by channel gives readers more context than Sales graph.

With the chart selected, use Chart Design, then Add Chart Element to add axis titles or data labels. Axis titles describe the measure or unit; data labels show values beside individual points, columns or slices.

Use labels selectively. A crowded line chart may be clearer with a labelled axis and legend, while a pie chart benefits from category names and percentages beside its slices.

Check the scale and number format

Right-click a value axis and select Format Axis to adjust its bounds, intervals or number format. Microsoft's guidance on changing an axis scale explains these controls.

For bar and column charts, use a zero baseline so the lengths represent values fairly. Check that currency, percentages and decimal places match the source data. An axis title should make clear whether amounts are shown in dollars, thousands or another unit.

Keep the design easy to read

Choose contrasting colours and keep the same colour for the same series across related charts. Increase text size if labels become difficult to read at the intended display size. Remove heavy backgrounds and unnecessary gridlines when they distract from the data.

Fix common chart problems

  • Wrong categories or missing values: select the chart, open Chart Design and choose Select Data to review the source range.
  • Series and categories appear reversed: try Chart Design, then Switch Row/Column, where available for the chart type.
  • New rows are missing: expand the chart's source range to include them.
  • Labels overlap: enlarge the chart, shorten category names or use horizontal bars.
  • A value looks incorrect: check the underlying cell and its formula before changing the chart's appearance.

Changing a value within the chart's existing source range updates the graph. After editing the worksheet, check that the chart still includes the intended data.

Save and share the finished graph

Save the workbook to keep the graph with its source data. You can copy the chart into Word or PowerPoint; check the paste options to choose whether you need an editable chart, a link to the workbook or a static picture. For a fixed report, export to PDF and inspect the result for clipped labels.

For related spreadsheet and application tutorials, browse the Microsoft Office guides. If a separate installation issue interrupts your work, the guides to Office activation using Command Prompt and finding an Office product key using Command Prompt cover those topics.

Now select a small data range, insert the chart that fits your question, and compare its plotted values with the worksheet before sharing it.

Other editions for separate workloads

Other editions for separate workloads; prices in AUD, confirm the total on the listing.

How to check this worked

  1. Open Settings, System, Activation and confirm the edition shown.
  2. Enter the key and run activation; expect a green tick within a minute.
  3. Reboot and re-check activation survives the restart.

FAQ

What else should you know before buying?

What do I need before starting?
Read the requirements and confirm the edition first; the steps assume the machine is compatible.
How do I know the licence is genuine?
Activate on Microsoft's servers and check Settings, System, Activation. A working activation is the test.
Is this a subscription?
Keys sold here are one-time lifetime licences. Microsoft 365 plans are billed by Microsoft instead.
What if the key fails?
Email hi@ms.codes with the order number and a screenshot. Replacement or refund applies within 30 days.

Check who prepared and reviewed this guide

Written by
MS.Codes editorial
Reviewed by
Support team

Last verified: (source review; see test status above).

Recent Post