Consulting | Excel Examples

GANTT Chart for Scheduling Resources

Keywords: GANTT, Resources, Time, Bar Chart

Description: Create a GANTT chart showing when resource is scheduled using a bar chart and Visual Basic for Applications procedure.

Tip: You can create a Visual Basic for Applications procedure that uses a list of start and stop times on a worksheet to build a table of durations for a bar chart. The bar chart can display the date in a resource usage GANTT format.

Guide to the Example: The raw time data is contained in sheet "TimeData". Click on the button on the TimeData worksheet to call the the procedure "CreateTimeChartData" and update the ChartData and TimeChart sheets.

Download File: Click Here
Tip: Click on the link above and choose "Save" to download the xls workbook to your hard drive or "Open" to open the workbook inside of your browser.


Last modified: May 21, 1996