Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: How to make a line graph?

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I apologize that this is probably the easiest question ever posted on this board, but I haven't used excel since I was in highschool. Ok, my problem is that I'm trying to create a line graph. I have numbers in column A and numbers in column B that I want to be my X and Y axis respectively. I always thought that I highlight all the numbers in the 2 columns and click on the chart wizard and go from there. Well, what it is doing is creating 2 graphs for me, and I only want one. Please help out.

    chuckyD

  2. #2
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-24 16:08, chuckyD wrote:
    I apologize that this is probably the easiest question ever posted on this board, but I haven't used excel since I was in highschool. Ok, my problem is that I'm trying to create a line graph. I have numbers in column A and numbers in column B that I want to be my X and Y axis respectively. I always thought that I highlight all the numbers in the 2 columns and click on the chart wizard and go from there. Well, what it is doing is creating 2 graphs for me, and I only want one. Please help out.

    chuckyD
    Hi chuckyD:
    Welcome to the club ... we are all here to learn from each other. For your line chart, you are already half-way home, when you said you want one series to be along the x-axis, and the other series along the y-axis.
    So, after you highlite the data in the two columns, you can select XY scatter (don't worry about the scatter part). As you will notice there are options in that group for solid lines as well.

    HTH
    Please post back if it works for you ... otherwise explain a little further and let us take it from there!

    _________________
    Yogi Anand
    Edit: Deleted inactive web site reference from hard coded signature

    [ This Message was edited by: Yogi Anand on 2003-01-19 15:20 ]

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yogi, that was exactly what I needed. I was going to the line graph wizard and not the XY scatter. I really appreciate your help, this site rocks.

    -chuckyD

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •