Dear All,
On a weekly basis (on every 1st day of the week) i share the project status (No. of work orders delivered) to my Manager.
The data that is contained is
Header: WRNo.|Estimation|Planned Delivery date|Actual Delivery date|Status|Remarks
1stRow: XYZ |10 |25/01/2010 |25/01/2010 |Green |Delivered
2ndRow: ABC |05 |27/01/2010 | |Yellow|OnTrack
3rdRow: ASD |10 |27/01/2010 | |Blue |onHold
3rdRow: QAZ |15 |27/01/2010 |26/01/2010 |RED |Delayed
The graph represents the Total No. of Man days received (10+5+10+15) to the Total No. of Man days delivered(10). Similar to Forecast Vs Actual column graph.
Currently i build the Data Tabular column by using the SUM(Estimation) and based on 'Remarks' column i SUM(Estimation) for Delivered work orders. Can this process be simplified using formulas.
Over a period of an Year i can have 250+ records and becomes difficult to SUM the delivered work orders manually based on the 'Remarks' column.
and by the by, how to get so crisp snapshot of the graphs (i attach the snap shot of the graphs created in excel into Outlook by using the Paste Special -> Bitmap and the graphs look blurred.)
Regards,
-Sravan
On a weekly basis (on every 1st day of the week) i share the project status (No. of work orders delivered) to my Manager.
The data that is contained is
Header: WRNo.|Estimation|Planned Delivery date|Actual Delivery date|Status|Remarks
1stRow: XYZ |10 |25/01/2010 |25/01/2010 |Green |Delivered
2ndRow: ABC |05 |27/01/2010 | |Yellow|OnTrack
3rdRow: ASD |10 |27/01/2010 | |Blue |onHold
3rdRow: QAZ |15 |27/01/2010 |26/01/2010 |RED |Delayed
The graph represents the Total No. of Man days received (10+5+10+15) to the Total No. of Man days delivered(10). Similar to Forecast Vs Actual column graph.
Currently i build the Data Tabular column by using the SUM(Estimation) and based on 'Remarks' column i SUM(Estimation) for Delivered work orders. Can this process be simplified using formulas.
Over a period of an Year i can have 250+ records and becomes difficult to SUM the delivered work orders manually based on the 'Remarks' column.
and by the by, how to get so crisp snapshot of the graphs (i attach the snap shot of the graphs created in excel into Outlook by using the Paste Special -> Bitmap and the graphs look blurred.)
Regards,
-Sravan