Results 1 to 7 of 7
  1. #1
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: multiple time scales on 1 time scale (XLS 07)

    Can you save and attach a copy saved in an earlier version or does the example use XL2007 features that will not translate.

    [I do not use XL2007 nor do I have a converter since the converter requires admin privileges to install so I am not allowed to do it on my work computer...]

    Steve

  2. #2
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Calgary, Alberta
    Posts
    205
    Thanks
    0
    Thanked 1 Time in 1 Post

    multiple time scales on 1 time scale (XLS 07)

    Hi Lounge,

    Has anyone got a solution for dealling with graphing data on multiple time scales?

    I have 3 different sets of data recorded over time different color for each set...attached.

    I am tring to plot the rate colume for each set comparing against the flowtime, but as you will see the sample time steps are takin at different intervals, which is a problem because the chart only wants one X axis.. Any way to make this work over one?
    Attached Files Attached Files

  3. #3
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Calgary, Alberta
    Posts
    205
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: multiple time scales on 1 time scale (XLS 07)

    updated the attachment, i hope this works

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: multiple time scales on 1 time scale (XLS 07)

    Something like this?

    Steve
    Attached Files Attached Files

  5. #5
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Calgary, Alberta
    Posts
    205
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: multiple time scales on 1 time scale (XLS 07)

    yes, do anything special?

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: multiple time scales on 1 time scale (XLS 07)

    Not really.

    Highlight data from B/C and create an XY chart (NOT a line chart)
    Then select data in E/F, copy to clipboard. Then select chart, edit - paste special and make sure "Categories (x values) in first column" is checked
    Then select data in H/I, copy to clipboard. Then select chart, edit - paste special and make sure "Categories (x values) in first column" is checked

    Using the XY chart and adding them separately, adds each data set as separate XY datasets instead of using the same X values for all the sets as you would get with a line chart.

    [You probably should format the flowback hours to [h]:mm to get the elapsed time since it goes over days (I did this in the chart). Personally I would change your Flowback formulas to take the difference and multiply by 24 to have it in DAYS instead of hours (format as number with 1 or 2 decimals) I prefer 0- 5 days instead of 0 - 120 hours, but this is my preference with such high number of hours...]

    Steve

  7. #7
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Calgary, Alberta
    Posts
    205
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: multiple time scales on 1 time scale (XLS 07)

    Well thanks steve! big help here x-y plot it is

    Cheers

Posting Permissions

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