Pages

  • Home
  • About
  • Download
  • Tutorials

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

8 comments:

  1. This post is very clear and concise. A good help for those who want to generate s curve is short and simple steps

    ReplyDelete
  2. very useful and easy way to learning of export p6 to excel and excel spread sheet to s curve creation

    ReplyDelete
  3. It's simplest way to explain the S curve. Very helpful for learners.

    ReplyDelete
  4. Good Article but what I find most challenging is coming up with the %completion of a project cumulative and arriving at actuals and forecast. Lot of ratios !

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...