• Time scale in graph (2003 sp2)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Time scale in graph (2003 sp2)

    Author
    Topic
    WScchambers@work
    AskWoody Lounger
    June 28, 2007 at 6:44 pm #443535

    I’m having a problem with the Y-axis of a time-based graph. Because of when the processing is started, I cannot have a traditional 0-24 hour scale. I need something a little different. I have a sample attached of how I would like to have the layout displayed. Can you take a look and let me know where I’m stuck?

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSHansV
      AskWoody Lounger
      June 28, 2007 at 7:06 pm #1070065

      See the attached version. I inserted two columns that calculate the time from the start of the day to the landmark and to the SLA, and used those in the chart.

      Reply | Quote
      • WScchambers@work
        AskWoody Lounger
        July 31, 2007 at 4:05 pm #1074405

        Sorry it took so long to confirm. This worked perfectly. I was trying to overcomplicate it. Thanks again!

        Reply | Quote
    Viewing 0 reply threads
    Reply To: Reply #1074405 in Time scale in graph (2003 sp2)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




    Cancel
DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    May 2025
    S M T W T F S
     123
    45678910
    11121314151617
    18192021222324
    25262728293031

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.