+ Reply to Thread
Results 1 to 9 of 9

Help with graphing second data series.

  1. #1
    Registered User
    Join Date
    11-18-2010
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    41

    Help with graphing second data series.

    I have a graph where the x axis is time (changes between 6A.M. - 8P.M. to 6P.M.-8A.M.) and y axis that, depending on the data selected, can go as high as 7000 (units vary in the legend). I have no problem with that graph, it's a smooth line scatter plot. I have other data, however, that gives one point: a time, and a corresponding percentage. What I'd like to do is have a vertical line that is at that corresponding time to be graphed on the same graph as my other data, with the legend describing what the percentage is. I'm not sure if this is possible. My graph has check boxes that allow me to select different parameters to be graphed, and their values aren't always similar (some values are as low as 100 to as high as 7000), hence why I want a vertical line to show the intersection at certain times. Anyone have any ideas on how I could do this?

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

    Re: Help with graphing second data series.

    You might be able to use an additional series and y-error bars.

    Can you post example file.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    11-18-2010
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    41

    Re: Help with graphing second data series.

    Sure thing:
    NorthvsSouth.xlsm

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

    Re: Help with graphing second data series.

    Add a single point series to the secondary axis. Secondary vertical scale min=0 max=1
    Apply minus 100% Y error bar.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-18-2010
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    41

    Re: Help with graphing second data series.

    That is exactly what I am looking for, however, when I try to do it myself, it makes all of my other data change and now that won't graph horizontally now. This is the first time I've dealt with using secondary axis stuff.

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

    Re: Help with graphing second data series.

    I had to alter the time value for the single data point as it included a date which caused all the existing data to be scrunched to the left of the axis.

    Post work attempt.

  7. #7
    Registered User
    Join Date
    11-18-2010
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    41

    Re: Help with graphing second data series.

    That's the problem I'm running to and can't figure out. What did you do to the time value so that it would work out?
    Here's the attempt I made:
    NorthvsSouth.xlsm

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

    Re: Help with graphing second data series.

    Date/Time in O30 is 21/07/2012 07:03:07

    Where as your other data is just Time, which means the Date/Time value is actually

    00/01/1900 06:00:00

    Just delete the Date part from the value in O30

  9. #9
    Registered User
    Join Date
    11-18-2010
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    41

    Re: Help with graphing second data series.

    Of course I would miss something so simple. Thanks for the help, much appreciated!

+ 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