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

Call us now

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.

Share this page on your favourite platform by clicking one of the icons below:

Share your thought - leave a comment below:

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

*

Want a Quick Quote?

If you are experiencing any problems with your technology please enter your details below and one of our helpful helpdesk staff will contact you back in 30 minutes or less.

    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 918 customer reviews collected via multiple sources (Word of Mouth, Product Reviews, Google Reviews and our feedback system.
    The Original PC Doctor reviews