How do I draw a floating cluster Gantt Chart with VBA.
- From: u473 <u473@xxxxxxx>
- Date: 26 Apr 2007 06:20:58 -0700
In this case, I want to use VBA only. No Scheduling tools.
My field of application is Construction where you repeatedly compare
Schedule of Estimated Data, Actual Data and Final Forecast.
The following data would drive a floating cluster of 3 bars,
Estimated, Actual and Forecast Finish from the current Report Date.
Activity# | Estimated Start | Estimated Finish | Actual Start
| Actual Finish | Forecast Finish | % Complete
Dim's .....
Set Series = .......
Set ReportDate = ....
For I = 1 to Ser.Points.Count
Draw Estimated bar from Estimated Start to Estimated Finish [Blue
1/4" or 6mmThick]
If Point# is 100% Complete
Draw Actual Bar from Actual Start to Actual Finish [Red
3/16" or 5mm Thick]
Else
Draw Actual Bar from Actual Start to Current Reporting
Date [Red 3/16" or 5mm Thick]
Draw Final Forecast Bar from Current Reporting Date to
Final Forecast [Yellow 3/16" or 5mm Thick]
End If
Next I
Draw Reporting Date Vertical marker
Thank you for your help or clues on these floating clusters
Have a good day,
J.P.
.
- Follow-Ups:
- Re: How do I draw a floating cluster Gantt Chart with VBA.
- From: Jon Peltier
- Re: How do I draw a floating cluster Gantt Chart with VBA.
- Prev by Date: Re: Bars and Area at the same time
- Next by Date: Re: Need Dynamic Data source help
- Previous by thread: dual x-axis problem
- Next by thread: Re: How do I draw a floating cluster Gantt Chart with VBA.
- Index(es):
Relevant Pages
|
