LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,814
Default Bars for various ranges of workhours

I have equipment operators with various starting and ending times. E.g. Some
at 5:00, some at 6:00, and some at 7:00. The 5s work 5:00 -1:30, the 6s
work 6:00 €“ 2:30, and the 7s work 07:00-3:30 , all 8 1/2/ hour blocks.
Id like to bar the range theyre working, e.g. a bar for Employee A running
from 5-1:30, Employee B from 6 €“ 2:30, etc. so that I could easily, visually
see the amount of time they overlap.
Something like below, so I could see that I have 3 employees that overlap
from 7:00 €“ 1:30, etc.
5 7 9 11 1 3
A Xxxxxxxxxxxxxxxxxxxxxxx
B Xxxxxxxxxxxxxxxxxxxxxxx
C Xxxxxxxxxxxxxxxxxxxxxxxxx

I'm not very versed in charting, but I can chart the start time and the end
time, Ijust can't figure out how to chart the 8 1/2 hours working at a
particular starting time. Any help would be appreciated.

Thanks,

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Workhours Calculation Mashuganah Excel Worksheet Functions 5 August 31st 07 05:44 PM
How can I change a graph with 2 bars,2 lines to 3 bars, 1 line? IOWAJulie Charts and Charting in Excel 3 October 19th 05 11:13 PM
bars KH Charts and Charting in Excel 1 September 21st 05 01:12 AM
Lost all my menu bars and tool bars CathyJ Excel Discussion (Misc queries) 3 August 8th 05 12:49 PM
of Named Ranges, Dynamic Charts and scroll bars... z.entropic Charts and Charting in Excel 2 May 20th 05 07:16 PM


All times are GMT +1. The time now is 02:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"