+ Reply to Thread
Results 1 to 2 of 2

Timeslots/box and whisker

  1. #1
    Registered User
    Join Date
    06-06-2017
    Location
    Copenhagen, Danmark
    MS-Off Ver
    2013
    Posts
    3

    Timeslots/box and whisker

    Hello,

    I am working on a box/whisker-chart with random timeslots between 08:00-11:30 during the workdays.

    When I enter a timeslot before 09:30, it completely alters the looks of the actual chart.

    Here is what I want it to look like (with a few altered timeslots, so there is none before 09:30)

    Chart 1.png

    Here is what it looks like when I have the correct timeslots - it shows timeslots from 00:00-12.00 instead of the timeslots that is actually in use.

    chart 2.png

    What might the problem of that be/how can I solve it without altering with the timeslots?

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

    Re: Timeslots/box and whisker

    If I understand correctly then you can select the vertical axis, right click the mouse and select format axis.
    Set the minimum to be fixed at 0.3395833333
    Set the maximum to be fixed at 0.5
    For future reference please upload a sample file with desensitized data.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] Classroom Problem - Sums of Rows With Overlapping Timeslots
    By ARec3 in forum Excel General
    Replies: 7
    Last Post: 10-16-2017, 08:59 AM
  2. Distribute timeslots efficiently
    By Matze in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-05-2016, 06:32 AM
  3. Replies: 0
    Last Post: 10-03-2013, 03:30 PM
  4. Box and Whisker Plot
    By marshymell0 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-08-2013, 10:32 PM
  5. General info and problems about timeslots sum
    By blak24 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-08-2013, 04:55 PM
  6. box and whisker plots
    By Les Clifford in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-18-2008, 01:09 PM
  7. box and whisker
    By MrMike888 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-02-2006, 04:40 PM

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