Creating a time chart

  • Thread starter Thread starter Don Rountree
  • Start date Start date
D

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
 
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
 
Back
Top