Creating a time chart

[Don Rountree]

Can someone tell me if this is possible. I want to be able to create a
chart that represents a week. There will be seven bars and each bar will
represent the day my business is open. I want to be able to enter starting
times in one column, let's say column B and a quitting times in column C.
These two columns represent Sunday. I want D and E to represent Monday.
I'll do this for all seven days. Is there a way I can create a stacking bar
chart (or any chart) that will place a bar representing that employee's
shift in the chart. All bars will not start on the horizontal axis, but
will appear in the chart according to the starting and quitting time I
enter. If this can't be done, please, someone let me know. Thanks in
advance...

Don Rountree

 

[Nicky]

Hi Don,
Creating a horizontal stacked bar chart, and then making the first ba
invisible by setting colour for fills and lines to none, might be wha
you're after - see attached.
Nick

Attachment filename: time charts.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=44119

 

[Tushar Mehta]

I thought I understood your problem. But then, along came the employee
surprise and you lost me totally.

Seven bars represent 7 days. So far OK. What role does the employee
information play in creating the bars?

Also, is the goal to create what XL calls a column chart (vertical
bars) or a bar chart (horizontal bars). What's on the horizontal axis?
On the vertical axis?

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions