Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I draw a floating cluster Gantt Chart with VBA.
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
More than one value on a cluster colum chart | Charts and Charting in Excel | |||
Stack & Cluster columns in same chart | Charts and Charting in Excel | |||
cluster & stacked & line in one chart | Charts and Charting in Excel | |||
Widening Cluster Chart Columns | Charts and Charting in Excel | |||
how do I create a cluster chart? | Charts and Charting in Excel |