+ Reply to Thread
Results 1 to 4 of 4

Automatic & Logical Duration Axis Adjustments

  1. #1
    Registered User
    Join Date
    04-16-2019
    Location
    South Dakota, United States
    MS-Off Ver
    2013
    Posts
    50

    Automatic & Logical Duration Axis Adjustments

    Hello all,

    Working on a productivity analysis spreadsheet that measures movements in seconds and does some summation. There is a ton of data from April-YTD and depending on what time frame I am looking at, I want it to adjust the Y-axis for me into something that is logical. For example, if I am looking at it for a day, it ranges from 1 hour to 3.5 hours. No problem there, data looks fantastic! However, if I want to look at it over a week or month, it makes no sense at all. It will start at 30days, then moving up along the y-axis, it will go to 1 day and then at the top, it will say 3 days. If I filter it my different months, it will continue to give me confusing data.

    I have spent hours adjusting the number format option under value field settings, using various suggestions for "custom" and I still can't get it to show how I want it to.

    Any thoughts?

    Thanks,

  2. #2
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    8,454

    Re: Automatic & Logical Duration Axis Adjustments

    Please read the yellow banner to add a sheet. Thanks
    And while you are at it:
    although we value privacy as much as anyone else, it could be important that members have a rough idea of your location. You might in the future post questions which are bound to your regional settings.
    So, please update your profile to something more precise than "SD" ( country will suffice, no need to be more precise).
    Thank you for helping us to help you
    You really don't have to give me rep points for moderating. It's part of the job. Keep rep points for those who find solutions

  3. #3
    Registered User
    Join Date
    04-16-2019
    Location
    South Dakota, United States
    MS-Off Ver
    2013
    Posts
    50

    Re: Automatic & Logical Duration Axis Adjustments

    Ended up finally getting it solved!

  4. #4
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    8,454

    Re: Automatic & Logical Duration Axis Adjustments

    Care to share your solution with your fellow members?

+ 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