![ms project tutorial ms project tutorial](https://www.smartsheet.com/sites/default/files/IC-MS-Project-resources-2.jpg)
Right click at the vertical axis, choose Format Axis.ġ6. Let’s modify the axis to change the maximum value to 100%. Highlight the data and create a Line chart.ġ5. Copy down the formula, and format the value to percentage style.ġ4. Select cell in the first row of each column and enter the following formula.ġ3.
![ms project tutorial ms project tutorial](https://www.itprotoday.com/sites/itprotoday.com/files/styles/article_featured_standard/public/uploads/2015/12/attachments_0.png)
Expand the Year, Quarter and Week fields. In Excel Program, change the PivotTable fields to as image below.Ĩ. The Visual Report is generated and opened in Excel Program. At the Field Picker dialog box, select field Cumulative Actual Work, click Add.Ħ. At the Field Picker dialog box, select field Baseline Cumulative Work, click AddĤ. In Ms Project, select Report > Visual Reports > Baseline Work Report.ģ.
#Ms project tutorial how to
In this tutorial we will show walk you through how to create a chart to display the percentage completion of Baseline Cumulative Work and Cumulative Actual Work against the time.ġ. how to display S-Curve chart with percentage complete against the time, side by side comparing the progress between your baseline and actual completion. But I came across a question asked by my student, i.e. Ms Project has Earned Value Analysis that allows us to plot S-Curve chart displaying cumulative cost, labour hours or other quantities plotted against project’s time span. Ms Project is a powerful project management tool to plan, monitor, control, analyse and forecast project’s status, progress and performance.