Excel 2003 Tutorial-Creating Progress S curve

Progress S curve can be easily created in excel 2003. It is normally used for graphical presentation of accumulation data. For example, weekly or monthly progress of engineering drawings and documents, production of sheet metal plates, construction of pipe rack and so on. Suppose the monthly plan progress, forecast progress and actual progress are available as shown in Fig-1.
(1) Click the chart wizard menu on the standard tool bar ,,"Chart Wizard-Step 1 of 4-Chart Type" window will be appeared and select standard line and chart type, and click "Next" as shown in Fig.2 .

Fig-1

Fig.2

(2 ) "Chart Wizard-Step 2 of 4-Chart Source Data" window box appears and click data range on the data range tag as shown in Fig.3. Source Data-Data range box appears for you to select the designated data.

Fig.3

(3) Select the progress data as shown in Fig-4, you would see Chart Source Data window and click "Next" (Fig-5).

Fig.4

Fig.5 

(4) Name the chart title "Progress Curve" in chart title box, "Monthly" in category (X) axis box and "Percent Complete" in value(Y) axis on the Title tag and click "Next". See Fig-6

Fig.6

(5) Choose chart location either "As object in" if you want to see in the same spreadsheet or "As new sheet" (chart will be appeared in the new spreadsheet ). Chart format and line color can be customized either by right click on the chart area or right click on the progress line. See Fig.7

Download template: Creating Progress S Curve