+ Reply to Thread
Results 1 to 3 of 3

Plotting 2 lines on a line graph

  1. #1
    Registered User
    Join Date
    03-15-2007
    Posts
    13

    Plotting 2 lines on a line graph

    Hi all,

    I am trying to plot 2 lines on a line graph, and I'm having trouble doing it - hoping you guys can help.

    In column A I have row numbers, counting how many entries I have.
    In column B I have cumukative profit
    In column C I have exposure

    Y axis is where I am having the problem.

    What I want is to do is have 2 lines tracked against each other. I have attched a file showing what I currently am getting, and also a jpg image in the workbook showing my current graph (that works). Essentially I want this graph to just have another line on it showing exposure, but i cant figure it out.

    Notice on the one I've tried it goes up to like $900 for some reason.

    Could anyone help me out?

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Plotting 2 lines on a line graph - should be easy (but I can't figure it out!)

    The chart is a stacked line rather than a normal line, which means 2nd series is offset from 1st rather than zero.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-15-2007
    Posts
    13

    Re: Plotting 2 lines on a line graph - should be easy (but I can't figure it out!)

    That will be why then!

    Thanks, solved.

    Andrew

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1