Results 1 to 6 of 6

Thread: charts (2003)

  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    charts (2003)

    I have a table of names (rows, col 1) and start and end times (cols 2 and 3) associated with each name and want to plot a bar chart (horizontal) that shows a bar for each person and have it cover the range from the start time to the end time (e.g., 10 a.m. - 4 p.m.). I can't seem to get just one bar for each person and the x-axis (time) seems to have a mind of its own when I really would like it to be in, say, 30 minute tick marks from midnight to midnight.

    Thanks in adance for any suggestions or solutions.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: charts (2003)

    Insert an empty column between columns 2 and 3.
    Fill this column with formulas that calculate end time - start time, i.e in C2, the formula will be =D2-B2.
    Create a stacked bar chart based on columns 1 to 3.
    Double click the first series (start times) and make it transparent, i.e. no line, no fill.
    Double click the horizontal axis.
    Activate the Scale tab.
    Set the minimum to 0.
    Set the maximum to 1 (=24 hours)
    Set the major unit to (for example) 0.0833333333333 (=2 hours)
    Set the minor unit to (for example) 0.0208333333333 (=30 minutes)
    Activate the Pattern tab.
    Specify secundary tick marks.
    Click OK.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: charts (2003)

    Here is an example (attached).
    Attached Files Attached Files

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Re: charts (2003)

    Thanks, Hans...as usual, that's a good solution. However, I have to avoid using a 24 hour clock and need a.m. and p.m.
    Is it easy to change the calc and the x-axis scale to reflect that?

  5. #5
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: charts (2003)

    Try changing the format of Column B and D to h:mm AM/PM. This will change the chart as well
    Jerry

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: charts (2003)

    What Jezza says, or double click the horizontal axis, activate the Number tab of the Format Axis tab and specify your favorite time format there (this will automatically clear the "Linked to source" check box).

Posting Permissions

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