ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I build a time card with bargraph? (https://www.excelbanter.com/excel-discussion-misc-queries/136065-how-do-i-build-time-card-bargraph.html)

alwazbizy

How do I build a time card with bargraph?
 
I am looking for ways to improve my office, and was wondering if anyone knew
of how to build a timecard that automatically puts in a bar graph to show you
the hours over lapped for multiple shifts? I am not very good at excel so
any help or ideas would be greatly appreciated.
Please email me at
Sincerely,

Amy H. Michigan

Jon Peltier

How do I build a time card with bargraph?
 
You've described a Gantt chart. Here are some resources:

Gantt Charts in Microsoft Excel
http://pubs.logicalexpressions.com/P...cle.asp?ID=343

How to Create a Gantt Chart Using Hours as the Scale
http://support.microsoft.com/kb/152820

Gantt Chart Links
http://peltiertech.com/Excel/Charts/GanttLinks.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"alwazbizy" wrote in message
...
I am looking for ways to improve my office, and was wondering if anyone
knew
of how to build a timecard that automatically puts in a bar graph to show
you
the hours over lapped for multiple shifts? I am not very good at excel so
any help or ideas would be greatly appreciated.
Please email me at
Sincerely,

Amy H. Michigan





All times are GMT +1. The time now is 02:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com