OZ Verified Business
Australia's No.1 Computer Support Company
The Original PC Doctor - Carbon Neutral
Need Technical Support? 1300 723 628 Call Service is open 24 Hours/ 7 Days a Week

How to Make a Graph in Excel

How to Make a Graph in Excel

Learn how to make a chart or graph in Microsoft Excel with this video tutorial and step-by-step instructions.

Excel Graphic

The best way to learn how to plot data is by example. We are going see graphically how much salary is made from 2001 to 2010.

1. Run Microsoft Excel. Put a label called “Year” in column A and “Pay” in column B.

2. Enter the data shown in the diagram. In column A, the year is entered starting with 2001. In column B, the salary was entered for the corresponding year.

Graph 1

3. Highlight the data by clicking on 2001 with the mouse and while holding the left mouse button, drag the cursor to the last data, 51800 in column B.

Graph 2

4. On the main menu, click on the Insert tab > Other Charts > All Chart Types as shown.

Graph 3

5. You will see the Insert Chart Wizard window. With the mouse, select XY Scatter and then select Scatter with Data Points Connected By Smooth Lines. Click Ok.

Graph 4

6. Your chart should look similar to the example shown. You can move the chart by clicking on it and dragging it anywhere on the Excel sheet.

Graph 5


Written by The Original PC Doctor on 15/2/2008.

Embark on a journey of connection and joy! Share this page with your loved ones on your favourite digital platform. Click one of the icons below and let the magic of sharing begin!

Join the conversation — your thoughts matter!

Your email address will not be published. Required fields are marked *


Want a Quick Quote?

Facing tech troubles? Submit your details below and receive a free, no-obligation quote from one of our helpful helpdesk staff within 30 minutes!

    Sign me up for the weekly newsletter

    We will never share your information with anyone.
    Privacy Policy.

    Customer Reviews
    The Original PC Doctor
    Average Rating: 4.5 out of 5
    *Based on 13941394 customer reviews collected via multiple sources (Word of Mouth, Product Reviews, Google Reviews and our feedback system.
    100+ Customer Reviews Milestone Badget - Word of Mouth
    The Original PC Doctor - 23 years of business excellence