Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2010
    Location
    Coon Rapids, Mn
    Posts
    199
    Thanks
    22
    Thanked 4 Times in 4 Posts

    A vexing Chart issue

    Can anyone tell me why the Service Time line in this chart is out of place? The data points are accurate but they aren't locating on the chart as they should. The Wait Time line is fine and located properly, but I can't get the Service Time line to move down to where it should fit on the vertical axis. I'm sure it is something simple, but I am not finding an answer. Any ideas? And thanks! :^)
    Attached Files Attached Files

  2. #2
    3 Star Lounger
    Join Date
    Apr 2012
    Posts
    240
    Thanks
    3
    Thanked 24 Times in 24 Posts
    It looks like there's a problem with the formula - it's adding the times together. I changed the Service Times all to one minute, which then caused the Service time to match the Wait time, but one minute "higher".

    Copy of Series Chart Issue.xlsx

  3. #3
    2 Star Lounger
    Join Date
    Feb 2010
    Location
    Coon Rapids, Mn
    Posts
    199
    Thanks
    22
    Thanked 4 Times in 4 Posts
    Quote Originally Posted by BigMac56 View Post
    It looks like there's a problem with the formula - it's adding the times together. I changed the Service Times all to one minute, which then caused the Service time to match the Wait time, but one minute "higher".

    Copy of Series Chart Issue.xlsx
    That is what it is doing alright, adding them. I'll try redoing the formula, though, in the series, you can't remove the 1 or 2 at the end of the formula without getting an error message. I'll poke around that idea. Thanks!

    I fixed it. Decided to start over, and this time, from the chart types, I used the first example, not the second in the dialog box and it worked as intended, though the formula is identical. Something underlying in the line chart code MS uses, I guess. But it is working as intended. Thanks.
    Last edited by genej313; 2014-05-10 at 12:16. Reason: Solved

  4. #4
    3 Star Lounger
    Join Date
    Apr 2012
    Posts
    240
    Thanks
    3
    Thanked 24 Times in 24 Posts
    Likely you had selected a stacked chart format.

    Glad you worked it out.

    Doug

  5. #5
    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
    BigMac56 is correct. It was NOT a problem with any formula but the chart type chosen. A "stacked line" was chosen. This plots the values for series 1, then series 2 is plotted as the sum of Series 1 + series 2, if a series 3 had been added it would have been the sum of Series1 + Series2 + series3. This is by design, it is how a stacked chart works.

    Steve

Posting Permissions

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