Microsoft Project Gantt Chart Ttutorial + Template + Export to PowerPoint

Looking for:

WinForms UI Controls | Visual Studio, C# | DevExpress.Gantt Chart Wizard: A Blast Out of the Past – MPUG

Click here to Download

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
How to find out the Gantt Chart Wizard? With Classic Menu for Project 20installed, you can simply get it with only one step. Click Menus tab to get. Step 1: Open Your Project File · Step 2: Enter the Project Data · Step 3: Add Gantt Chart Wizard on the Ribbon · Step 4: Customize the Gantt Chart.
 
 

Microsoft Project Gantt Chart Ttutorial + Template + Export to PowerPoint

 
Step 1: Open Your Project File · Step 2: Enter the Project Data · Step 3: Add Gantt Chart Wizard on the Ribbon · Step 4: Customize the Gantt Chart. Use the Gantt Chart Wizard to end up with the chart you want. Before you start, you’ll need to add the Gantt Chart Wizard to the Project ribbon. It is very simple to use but will not display the Negative Float and Free If the Gantt Chart Wizard button is not on your Microsoft Project default.

 

How to Make a Gantt Chart in Microsoft Project | EdrawMax Online – Which tutorial would you like to see?

 

Office Timeline is a PowerPoint add-in that imports data directly from Microsoft Project and transforms it into professional Gantt charts instantly.

Since all these automatically generated graphics are native PowerPoint slides, they can be opened, shared, presented, updated, or edited by anyone who has PowerPoint installed.

You will also learn how to refresh the slide instantly after you make changes to the. MPP file. Click on Microsoft Project in the Import wizard and select the. MPP file you wish to load.

Next, Office Timeline will map the columns in the. MPP file, but you can make changes if there are any mismatches. Now, from the. MPP import list screen, select what MS Project data you would like to import by ticking or unticking them. You can choose to display some of the imported items using the Outline or the Filter options.

This one took around one minute to make:. Click the Refresh Data button on the Office Timeline ribbon to update your Gantt whenever the data changes in your Project file. The Refresh wizard will identify any changes to the. Select the changes you want to keep and click Finish to update your Microsoft Project Gantt chart. When using MS Project to make a Gantt chart that is more complex, you might encounter pagination issues, like your graphic spanning too many pages. That can be problematic when you present it to your stakeholders and execs.

Fortunately, there are a few options available:. Start out by clicking on View then select Timeline to adjust the display mode of your graphic. You can use the Format section to adjust the date range, colors, or text style, and even create multiple timelines.

Another way to go about it is to simply import the. MPP file into Office Timeline, apply a professionally designed Gantt chart template and let the add-in do the work for you. Your Excel chart is starting to look like a normal Gantt chart, isn’t it? For example, my Gantt diagram looks like this now: 6.

Improve the design of your Excel Gantt chart Though your Excel Gantt chart is beginning to take shape, you can add a few more finishing touches to make it really stylish. In Excel , Excel – , there are no Auto and Fixed radio buttons, so you simply type the number in the box. You can play with different settings until you get the result that works best for you.

Don’t be afraid to do something wrong because you can always revert to the default settings by switching back to Auto in Excel and , or click Reset in Excel and later. And here is the result of our efforts – a simple but nice-looking Excel Gantt chart:. Remember, though your Excel chart simulates a Gantt diagram very closely, it still keeps the main features of a standard Excel chart:. As you see, it’s not a big problem to build a simple Gantt chart in Excel.

But what if you want a more sophisticated Gantt diagram with percent-complete shading for each task and a vertical Milestone or Checkpoint line? Of course, if you are one of those rare and mysterious creatures whom we respectively call “Excel gurus”, you can try to make such a graph on your own, with the help of this article: Advanced Gantt Charts in Microsoft Excel.

However, a faster and more stress-free way would be using an Excel Gantt chart template. Below you will find a quick overview of several project management Gantt chart templates for different versions of Microsoft Excel. If you cannot find it there, you can download it from Microsoft’s web-site – Gantt Project Planner template. This template requires no learning curve at all, simply click on it and it’s ready for use. As well as the previous Gantt chart template, this one is fast and easy-to-use.

They offer 30 days free trial, so you can sign with your Google account here and start making your first Excel Gantt diagram online straight away.

The Refresh wizard will identify any changes to the. Select the changes you want to keep and click Finish to update your Microsoft Project Gantt chart. When using MS Project to make a Gantt chart that is more complex, you might encounter pagination issues, like your graphic spanning too many pages. That can be problematic when you present it to your stakeholders and execs. Fortunately, there are a few options available:.

Start out by clicking on View then select Timeline to adjust the display mode of your graphic. You can use the Format section to adjust the date range, colors, or text style, and even create multiple timelines. Another way to go about it is to simply import the. MPP file into Office Timeline, apply a professionally designed Gantt chart template and let the add-in do the work for you.

Multiple Gantt chart makers are available in both online and offline versions. If you want to look at a comparison, check out our article on the best Gantt chart makers available today. Many tools on the market offer either a free version, a freemium model or a free trial.

After you try them out and depending on the complexity of your project, it might be better to consider investing in a decently priced app that will save you time and money in the long run.

Large-scale PowerPoint clinical trial roadmap template featuring color-coded elements to highlight the main phases necessary for a drug or procedure to receive FDA approval. Swimlane timeline template that outlines the major components of business continuity management in order to guide professionals in their risk-mitigation efforts. Swimlane diagram example that includes diverse milestones and tasks to mark distinct phases and major events for managing technological updates in your organization.

Color-coded swimlane sample for showcasing the journey of a product with smartly grouped milestones and tasks, which reduces clutter and eliminates overlapping. Simple Gantt chart diagram with well-defined tasks and milestones that help you clearly outline any project schedule. The Gantt chart template was designed for professionals who need to make important project presentations to clients and execs. Simple yet professionally-designed project template focusing on major milestones and due dates for you to be able to create easy-to-follow, high-level project timelines for proposals, campaigns, status reports and reviews.

A visual template highlighting project key tasks and milestones so that you can present just the right amount of detail to both project and non-project audiences. Login Products Office Timeline Add-in. You can view the critical tasks by changing the color of those items in the Gantt Chart view. Tasks on the critical path will automatically be red in the Network Diagram view.

You can also view critical path information in the Schedule table or by using the Critical Tasks report.

To make the text for the critical path tasks appear in red on the Gantt chart: 1. Change the critical tasks format. Using the myschedule.

Notice that the critical tasks display in red in the Gantt chart. You can also quickly change the Gantt Chart Style by clicking one of those options. Formatting critical tasks 2. View the network diagram. Click the View tab, and then click the Network Diagram button under the Task Views group Click the Zoom Out button on the Zoom slider several times and watch the view change. Note that milestone tasks, such as Stakeholder management strategy completed, the fourth box on the top, appear as pointed rectangular boxes, while other tasks appear as rectangles.

Move your mouse over that box to see it in a larger view. Notice that tasks on the critical path automatically appear in red. A dashed line on a network diagram represents a page break.

You often need to change some of the default settings for the Network Diagram view before printing it. As you can see, network diagrams can be messy, so you might prefer to highlight critical tasks on the Gantt chart as you did earlier for easier viewing. Network diagram view 3. View the schedule table. Alternatively, you can click the View tab and click the Tables button under the Data group and then select Schedule.

The Schedule table replaces the Entry table to the left of the Gantt Chart. This view shows the start and finish meaning the early start and early finish and late start and late finish dates for each task, as well as free and total slack. Right-click the Select All button and select Entry to return to the Entry table view.

Select All button Schedule table Figure A Schedule table view 4. Open the Project Overview report. Examine other reports, as desired. Close the report and save your file. When you are finished examining the reports, click the Save button on the Quick Access toolbar to save your final myschedule.

Close Project if you are not continuing to the next section. Next you will explore some of the cost and resource management features of Project Some organizations have more established cost management software products and procedures in place, and many people simply do not know how to use the cost or resource management features of Project However, these features make it possible to integrate total project information more easily.

This section offers brief instructions for entering fixed and variable cost estimates, assigning resources to tasks, viewing resource histograms, and entering actual cost and schedule information after establishing a baseline plan. It also explains how to use Project for earned value management.

More details on these features are available in Project Help, online tutorials, or other texts. See other chapters of this text for information on some of these concepts. Fixed costs include costs like a specific quantity of materials or costs for consultants hired at a fixed cost.

Variable costs vary based on the amount of materials or hours people work. On many projects, human resource costs are the largest percentage of total project costs. To enter a fixed cost: 1. Display the Cost Table view.

Open your Project file myschedule. The Cost table replaces the Entry table to the left of the Gantt chart. Widen the Task Name column and then move the Split bar to the right, as needed, until you see the entire Cost table. Enter a fixed cost. Notice that the Total Cost and Remaining Cost columns reflect this entry, and changes are made to the summary task, Executing, as well.

Entering a fixed cost Entering Resource Information and Cost Estimates Several methods are available for entering resource information in Project Once you have established resources in the Resource Sheet, you can assign those resources to tasks in the Entry table with the list arrow that appears when you click a cell in the Resource Names column. The Resource Names column is the last column of the Entry table.

To enter basic information about each person into the Resource Sheet and assign them to tasks using the Entry table and toolbar: 1. Display the Resource Sheet view. Enter resource information. Enter the information from Figure A into the Resource Sheet. The three resources names are Kathy, Dan, and Scott. The Std. Rate and Ovt. Rate for Kathy is 40, and the Std. Rates for Dan and Scott are Type the information as shown and press the Tab key to move to the next field.

The standard and overtime rates entered are based on hourly rates. Resource sheet view with resource data entered TIP: If you know that some people will be available for a project only part time, enter their percentage of availability in the Max Units column of the Resource Sheet.

Project will then automatically assign those people based on their maximum units. You can also enter the number of hours each person is scheduled to work, as shown later. Assign resources to tasks. Move the Split bar to reveal the Resource Names column, if needed. Assign Kathy to task 2, Stakeholder identification. Click in the Resource Names cell for row 2.

Click the list arrow, click on the checkbox by Kathy, and then press Enter or click on another cell. Notice that the resource choices are the names you just entered in the Resource Sheet. To assign more than one resource to a task using the list arrow, simply select another checkbox. Note that Project will assume that each resource is assigned full-time to tasks using this method since the task is in automatically schedule mode. Also note that you can use filter by Resource Names to only show tasks assigned to specific resources after you enter the resources.

Filter Resource Names Figure A Resource assigned using the entry table 5. Assign two resources to a task. Click in the Resource Names cell for row 5 Project charter. Click the list arrow, then click on the checkbox by Dan and Kathy, and then press Enter.

Notice that both resource names appear in the Resource Names column and on the Gantt chart for this task, and the task duration remains at 1 week. Change the resource assignments. Click in the Resource Names cell for Task 2, Stakeholder identification, click the list arrow, and add Dan as another resource. Notice that when you change an original resource assignment, Project prompts you for how you want to handle the change, as shown in Figure A Click the Exclamation point symbol to read your options.

In past versions of Project, resource additions would change schedules automatically unless the user entered them a certain way. Now you have much more control of what happens to your schedule and costs.

In this case, we do want to accept the default of keeping the duration constant. Options when additional resources are added to tasks 7. Review the cost table. Notice that costs have been added to the tasks where you added resources.

In the next section, you will see how to control resources entries even more. First, right-click the Select All button to the left of the Task Mode column heading and select Entry to return to the Entry table. To control resource and work assignments using the Resource details window: 1. Open the Resource Form. Move your mouse over the symbol to read the message about resources being overallocated. Click the Task Name for row 2, Stakeholder identification, click the Resource tab, and then click on the Details button under the Properties group.

A Resource Form is displayed at the bottom of the screen, as shown in Figure A Project assumes every task is assigned full-time, so since Kathy is scheduled on two tasks on the same day, it says she is overallocated. You can click the Select All button at the top right of the screen to view different tables at the top of the screen. You want to make sure that resource and work hour assignments do not adjust your schedules in ways you did not intend.

Make tasks 2 and 5 manually scheduled. Click the Select All button and switch to the Entry table. Click the drop-down in the Task Mode column for Tasks 2 and 5 to make them manually scheduled. When you assigned resources, Project assumed they were working full-time or 40 hours per week on each task. Because these two tasks have days that overlap, there is an overallocation.

You do not expect each resource to work that many hours, so you can change them by using the Resource Form.

Change the number of Work hours. Select Task 2, Stakeholder identification in the top window, and then click the Work column in the Resource Form window for Kathy in the lower part of your screen. Type 10h, press Enter, and again type 10h and press Enter for the next task, Task 5, Project charter, and then click the OK button. Changing Work hours for tasks 4. Enter additional work hours and review the Gantt chart. Notice in the Gantt chart that the duration for Tasks 2 and 5 are still one week.

The overallocation indicator should now disappear because the number of hours has been reduced from the default of 8 hours per day, or 40 hours for a 5-day task. Examine the new cost information. Click the Select All button, and then click Cost to view the Cost table. Close the file, but do not save the changes you made. Using the Team Planner Feature Another way to assign resources and reduce overallocations is by using the Team Planner feature.

Assume you have two people assigned to work on a project, Brian and Cindy, as shown in Figure A Notice that Brian is assigned to work on both Task 1 and Task 2 full-time the first week. Therefore, Brian is overallocated. Cindy is scheduled to work on Task 3 full-time the second week, and Task 4, also scheduled for the second week, is not assigned yet.

Overallocated resource You can click on the Team Planner view under the View tab to see a screen similar to the top section of Figure A Notice that Brian has both Tasks 1 and 2 assigned to him at the same time. Cindy is assigned Task 3 the following week, and Task 4 is unassigned. Many people will appreciate the simplicity of this feature, first introduced in Project !

Adjusting resource assignments using the Team Planner feature Entering Baseline Plans, Actual Costs, and Actual Times After entering information in the Task Name column, establishing task durations and dependencies, and assigning costs and resources, you are ready to establish a baseline plan. After the project ends, you can use the baseline and actual information to plan similar, future projects more accurately. To use Project to help control projects and view earned value information, you must establish a baseline plan, enter actual costs, and enter actual durations.

In the next series of steps you will use a new file called tracking. To save a file as a baseline and enter actual information: 1. Open the file called tracking. The file should be showing the Cost table view. Saving a baseline 2. Save the file as a baseline. Examine the Set Baseline dialog box. Click the drop- down arrow to see that you can set up to ten baselines. Accept the default to save the entire project. Notice that the Baseline column changes to blue. Display the Tracking table. Click the Task tab, right-click the Select All button and then click Tracking to view the tracking table.

Move the split bar to the right to reveal all of the columns in the table, if needed. Move your mouse over each tracking button in the Ribbon in the top line of the Schedule group to see what it does. Using the tracking table and tracking buttons 4. The columns with dates, durations, and cost information should now contain data instead of the default values, such as NA or 0. Adjust column widths if needed. Notice that the Gantt chart bars for those three tasks now have a black line through them.

Tracking table information 5. Enter actual completion dates for Task 6. The Update Tasks dialog box opens. Notice how the information in the tracking sheet has changed. Update Tasks dialog box 6.

View the Tracking Gantt chart. Click the drop-down arrow on the far left of the screen where it says Gantt chart, and then click Tracking Gantt to quickly switch to that view. Move the split bar and adjust column widths as needed.

Use the horizontal scroll bar in the Gantt chart window to the right move the slider to the left to see symbols on the Tracking Gantt chart. Use the Zoom slider on the lower right of the screen to adjust the timescale so you can see all of the symbols.

The blue bar for task 6 shows the actual time you just entered. Notice that the delay in this one task on the critical path has caused the planned completion date for the entire project to slip now Feb 25 versus Feb Also notice the Indicator column to the far left.

The check marks show that tasks are completed. Completion indicator Tracking Gantt chart Figure A Tracking Gantt chart view 7. Save your file as a new file named myactuals. Name the file myactuals, and then click Save.

Notice the additional information available on the Tracking Gantt chart. After you have entered some actuals, you can review earned value information for the initiating tasks of this project.

Because you have entered actual information, you can now view earned value information in Project You can also view an earned value report using the visual reports feature. To view earned value information: 1. View the Earned Value table. Using the myactuals file you just saved or downloaded from the companion Web site , click the Select All button, select More Tables, and double-click Earned Value.

Move the split bar to the right to reveal all of the columns, as shown in Figure A Remember that not all of the actual information has been entered yet.

Also note that the date on your computer must be set later than the date of a completed task for the data to calculate properly. Earned value table 2. View the earned value chart. You can experiment with different report options or click the link to Learn more about earned value, as desired. Earned value report 3. Close Project without saving the file. Click the File tab, click Close, and select No when prompted to save the file.

You can also exit Project and take a break, if desired. Next you will use a few more features of Project to help tie your Project to other applications. For example, you can copy data between Project and other applications including the timeline , or you might want to create hyperlinks to project documents created in Word, Excel, PowerPoint, or other applications from within your project files.

Copying Information Between Applications Most people are familiar with copying information between Office applications. For example, you can highlight a column of data in Excel, select copy, and then select Paste in Project or other applications.

You can also create a new Project file from an existing Excel file by select New from Excel Workbook. It is also easy to copy a timeline from Project into another application. Open another Project template file.

Start Project , and open a template file, such as Residential Construction, as shown in Figure A Notice the timeline near the top of the screen. Residential construction template 2. Make changes to the Timeline. Move your mouse over the second item on the Timeline called Site Work. Right-click on Site Work, and select Remove from Timeline.

Open the Insert Hyperlink dialog box. Note that this milestone could be worded better to indicate that it has no duration, such as Permit Applications Submitted. Make other adjustments to the Timeline, as desired. Copy the Timeline into PowerPoint. Open PowerPoint, change the slide layout, add a title to the slide, and change the theme, as desired, and then right-click and select Paste picture.

Your screen should resemble Figure A, showing the Project Timeline in your presentation. Copy Timeline Figure A To do this, you can simply insert a hyperlink to other document files.

For example, you can create a hyperlink to the file with the stakeholder register you listed as a milestone in your Task Name column earlier. To insert a hyperlink within a Project file: 1.

Open the myschedule. Use the file you saved earlier or download it from the companion Web site for this text. The Entry table and Gantt Chart view should display. Select the task in which you want to insert a hyperlink. Click the Task Name for Task 3, Stakeholder register completed. Right-click in that cell, then click Hyperlink.

 
 

Microsoft project 2013 gantt chart wizard free

 
 
By the way, the Gantt Chart Wizard is a useful microsift tool for formatting the Gantt Chart pane in any Gantt-based view. Align programs and projects on one slide with multi-level Swimlanes.