+ Reply to Thread
Results 1 to 6 of 6

24h Chart start at 06

  1. #1
    Registered User
    Join Date
    04-02-2014
    Location
    Sverige
    MS-Off Ver
    Excel 2010
    Posts
    52

    24h Chart start at 06

    Hi, I'm looking for some help on this. I know how to do a chart from 00:00 to 24:00 but I'm struggeling on how to make it start at 06:00 and end at 06:00, any ideas?

    Also, is it possible to have a 2 day chart? 00-24 and then 00-24 again?

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

    Re: 24h Chart start at 06

    what sort of chart?

    setting the axis min/max should do it.

    for multiple days you would need to include the date.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    04-02-2014
    Location
    Sverige
    MS-Off Ver
    Excel 2010
    Posts
    52

    Re: 24h Chart start at 06

    It's a stacked bar chart. Im currently using min 0 and max 1 and major 0.08339 and minor 0.01. Using this i get a 00-24 chart. The bars that are shown is a decimal of an hour. Therefor min 0 max 1.

  4. #4
    Registered User
    Join Date
    04-02-2014
    Location
    Sverige
    MS-Off Ver
    Excel 2010
    Posts
    52

    Re: 24h Chart start at 06

    I changed the max to 2 and got 2 days. But I still trying to figure out to change the start from 00 to 06
    Last edited by Fredma; 09-24-2014 at 08:42 AM.

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

    Re: 24h Chart start at 06

    you need to enter time values

    so 6am is 6/24 = 0.25

  6. #6
    Registered User
    Join Date
    04-02-2014
    Location
    Sverige
    MS-Off Ver
    Excel 2010
    Posts
    52

    Re: 24h Chart start at 06

    Added 0.25 to the min value and now it starts at 0600. Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Start workday,Gantt chart
    By daredan in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-29-2014, 07:18 AM
  2. Replies: 6
    Last Post: 02-04-2012, 05:19 PM
  3. Chart start time for overlap
    By Mothman in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-04-2010, 09:20 AM
  4. Breakeven chart - won't start at zero
    By Doogle in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 01-14-2007, 06:37 AM
  5. Chart to start @ Value 8
    By dixonpeter in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-22-2005, 11:00 AM

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