Quick-Tip #2: Position Milestones Exactly Where You Want Them

Step 1: Manually re-position your milestone markers.

Click on the text box of the milestone you want to re-position and drag it vertically to a new position as shown in the image below. This can be done for both milestones that are positioned above or below the time band.

Project management tools for PowerPoint

Step 2: Click accept and choose Accept Manual Changes.

Once you have moved your milestone to the desired position, click the Accept button on the ribbon to save and to automatically create a connector from the timeband to your newly positioned milestone.  You can see the changes in the image below.

Gantt chart software for PowerPoint

Watch this quick video to see how it is done.

See these quick videos for more tips:

Quickly turn project data into professional timelines

Build stunning, uncomplicated timelines and Gantt charts that are easy to make and simple to communicate. Get the advanced features of Office Timeline Plus free for 14 days.


Quick Tip #1: Copy and Paste from Excel

Step 1. Copy from Excel.

Organize your Task and Milestone data into two Excel tables as shown here.

Task tables should include a start date, end date and a description arranged next to each other. Milestone tables should have a milestone date and description also arranged next to each other.  Now copy your first table.

Step 2: Click the Paste icon.Paste from Excel into PowerPoint Timeline Maker

From the Office Timeline Milestone or Task Wizard  paste your copied Milestone table, and then paste your copied task table.  See how in this video.

Project management software that pastes from Excel into PowerPoint

Step 3: Create your slide by pressing the Finish button.

Click the green check box to finish turning your tables into a professional looking timeline slide or Gantt chart. It is just as easy as that.
Project management software for PowerPoint

See these quick videos for more tips:

Quickly turn project data into professional timelines

Build stunning, uncomplicated timelines and Gantt charts that are easy to make and simple to communicate. Get the advanced features of Office Timeline Plus free for 14 days.


How to Make a Project Plan Presentation for Clients and Stakeholders

Updated on 14 June 2020

Project presentation is the cornerstone of every successful enterprise and a fundamental skill every project manager should master. Whether it’s part of a stakeholder engagement plan or you’re writing an executive summary to update management on your progress, success is highly dependent on effective communication. Our article aims to showcase a few project evaluation and review techniques that you can employ to break down the barriers of business communication.

Product Development Roadmap


Simplify your presentation with high-level project visuals

A presentation for project stakeholders should be a broad, high-level overview to pique their curiosity rather than complex and uninspiring sets of data that only make sense to the speaker. However tempting it might be to rehash and recycle the detailed project charter that you’ve worked so hard on, especially when you’re pressed for time, don’t! Presenting data visually as a project roadmap to clients and executives adds context to facilitate understanding and allows you to only go into specifics upon request.

Microsoft Project is most often the project management software of choice in the planning phase. Few other project management tools are this well optimized for navigating the complexity of enmeshed tasks, milestones and events, or for creating deep dives. On the other hand, when it comes to generating high-level project visuals, its graphical representations, like the Gantt chart example below, are not well suited for a meeting with the project stakeholders.

Microsoft Project Gantt chart

An exec-level project review should summarize the strategic planning process and showcase its progress in a visually appealing manner. Remember: the challenge consists of making the information easy to digest and ensuring that audiences understand the business implications.

Creating a graphical representation of data

The best option for outlining a project’s plan is to create a workflow diagram that correlates the tasks with the critical milestones, as shown in the Gantt chart example below:

PowerPoint Gantt chart template


Presenting the project roadmap in this manner helps your stakeholders quickly see the scheduled tasks, as well as their duration, sequences and other task dependencies, all of which define the critical path. Furthermore, connecting the project activities (tasks) with the project events (milestones) offers clients and execs more insight, which translates to better management decisions.

Timeline vs Gantt Chart

Two main techniques are often employed to chart the strategic planning process as a graphic: timelines and Gantt charts. At their core, project timelines typically encompass only the events (milestones) whereas Gantt charts tend to show just activities (tasks). However, as we’ve mentioned earlier, the ideal project presentation should feature a blend of both tasks and milestones. For clarity purposes, you can opt for a single unified graph like a swimlane diagram that splits up these tasks and milestone according to their specific project life cycle phase.

Swimlane diagram template


Next, let’s take a comparative look at two frequently used alternatives for visually rendering a project charter, Excel and PowerPoint. We will explain how to make a Gantt chart in Excel using a bar graph, and how to make an Excel timeline using a scatter graph. We will also show you how to quickly make a single, unified Gantt chart + Timeline presentation in .PPTX by using our add-in for PowerPoint, Office Timeline.

Organizing your project in Excel

Whether or not you’re going to create the Gantt chart in Excel, this application from the Microsoft suite is a great place to start drafting the project schedule. More exactly, you will need to create the Work Breakdown Structure (WBS) by breaking down the project into smaller pieces of work – the tasks. Make an Excel project management template that you can reuse, then list each of the tasks on the data table in the correct sequence. The tasks will form the project Gantt chart and their order will determine the project schedule.

Another important piece of the puzzle to integrate in your Excel project management template is the milestone section. Project milestones consist of all major deadlines your plan must achieve, and they form your Excel timeline. We have included a Work Breakdown Structure example below, for clarity purposes.

Excel Project Plan schedule

Note: Keep in mind that this is a high-level presentation aimed at executives and stakeholders, so it should not be overly complex. Consider trimming it down if the project schedule contains more than 20 tasks and 20 milestones, in order to facilitate understanding and keep the audience engaged.

Option 1: Making the Excel graphs

It’s worth noting that Excel is nowhere near as graphics-oriented as PowerPoint. The direct result is that your Excel Gantt charts and timelines will tend to look more like stacked bar graphs and, respectively, scatter charts.

Another drawback is that Excel doesn’t allow you to combine a Gantt chart (tasks) with a timeline (milestones) into a unified project roadmap. Therefore, you will need to create two separate visuals and combine them on one slide or present them individually. In order to do that, you will first need to make a Gantt chart showing the tasks of your project plan and then a timeline with your project milestones. Here’s how:

  • Step 1: Create a Gantt chart in Excel with the stacked bar chart function

Once you have your project schedule in Excel you will add the task data into an Excel stacked bar graph and then follow approximately 20+ formatting steps to transform it from a stacked bar chart into an Excel Gantt chart, which will end up looking something like the chart below. For detailed instructions, please check out our guide on how to make a Gantt chart in Excel.

Excel Gantt chart example

  • Step 2: Create a timeline in Excel using the scatter chart function

To create a timeline in Excel you will need to use a scatter chart. Add your data to the scatter chart then follow approximately 25 steps to format it so it looks like a timeline presentation, as shown below. If that’s easier, check out our easy-to-follow, step-by-step guide and a how-to video tutorial.

Excel timeline example

Note: However familiar and accessible this Microsoft application may be, there are certain limitations that make it less than ideal for project presentations, including:

  • No method to combine an Excel Gantt chart with a timeline. Executives and stakeholders should be able to view the tasks and milestones in conjunction with each other for better visibility into the critical deadlines and activities.
  • Making a project roadmapproject roadmap featuring a timeline or Gantt chart in Excel requires advanced operating skills. Converting Excel’s stacked and scatter charts into Gantt charts and timelines depends on properly following a specific sequence of formatting steps.
  • The resulting diagrams are not as visually appealing as a PowerPoint slide and considerably more difficult to share with everyone involved.

Option 2: Create the project roadmap as a native PowerPoint slide

So far, we have shown you how to make a Gantt chart in Excel and mix it with a timeline, in order to provide your stakeholders with a 2-part overview of your project schedule. Next, let’s take a look at the alternative: using a PowerPoint timeline maker with embedded Gantt chart functions to generate a slide with both graphics combined.

PowerPoint is perceived as a superior tool for building project presentations. Since it is a graphical application, it is designed for creating and communicating charts in a visual way. Additionally, since it’s a common tool in enterprises, PowerPoint is familiar to audiences, and slides can be easily shared. There are two main ways to build project slides in PowerPoint using our Office Timeline add-in:

  1. Create the Work Breakdown Structure template in Excel and import the data

Earlier in the article we have included a Work Breakdown Structure example made in Excel. The first option relies on using the import feature from Office Timeline and bring in the data tables with tasks and milestones. To import the project schedule you created in Excel, use the Office Timeline Pro wizard which will link to your project spreadsheet (or .MPP file, if you prefer Microsoft Project). Here’s a quick demo:

Import from Excel

There’s another reason to import the data from an Excel spreadsheet and that’s the sync feature. In short, since the PowerPoint slide is linked to a worksheet, it can be synchronized and updated with the click of a button when the spreadsheet data changes. Check out a brief synopsis of how sync works:

Sync with Excel

Note: For better visibility, Office Timeline also allows you to import tasks and milestones directly into swimlane templates.

  1. Use a Gantt chart or timeline template (swimlanes are also supported)

There are definitely advantages to importing the data file from an external application like Excel or Microsoft project. However, that isn’t your only option. Office Timeline comes with an extensive collection of professional templates that can easily adapt to a wide variety of different project types. These timeline templates are embedded in the add-in and there is also a free gallery with new ones added regularly, for your convenience.

Create timeline from template

Simply replace the default data with your own tasks and milestones, and Office Timeline generates the graphic for you.

Note: Customizing a timeline or Gantt chart template with your own data can be done at any time from the user-friendly and highly intuitive interface. Update it easily whenever there are changes in your project schedule, restyle it and share it with your team, all from within PowerPoint. It’s very flexible!


Writing an executive summary or stakeholder engagement plan is all about clarity, and the best way to achieve it is to complement the data with professional, visually appealing graphs. As you’re adding tasks and milestones to your project roadmap, it also becomes easier to trim the fat and focus on the game changers. This way, you’ll obtain an actionable and compelling high-level overview, rather than get tangled in the specifics.

If you regularly find yourself liaising with the management or your stakeholders and dread the thought spending hours creating presentations with the traditional tools in the Microsoft Office suite, then check out Office Timeline. Available as a free version, this handy project roadmap creation app can save you time and ensure you drive your point home without the drawback of an intimidating learning curve. For the more complex timelines, we recommend giving the Pro Edition a try.

Quickly turn project data into professional timelines

Build stunning timelines, roadmaps and Gantt charts that are easy to make and simple to communicate. Get the advanced features of Office Timeline Pro free for 14 days.


📈 Project Scorecard for Executive Review

How to Create a Graphical Project Scorecard for Management Reviews.

Customers and Executives love to see a project scorecard as part of a project review.  This most often means it is presented on a PowerPoint slide in a dashboard format.   This article and video discusses how to quickly build a PowerPoint project scorecard around your project timeline as shown below.

Project Scorecard - how to make quickly make them in PowerPoint.,Why PowerPoint?

Executives and customers are most familiar with project reviews presented in PowerPoint.  They are experienced in reading these presentations, and know PowerPoint will force presenters into condensing their content into the most relevant information.  So they get a high-level summary of the business which enables them to make decisions quickly.

Why a Project Scorecard?

Since executive level presentations do not require deeply detailed project reports, they should be no more than 2-3 slides per project. Using a project scorecard is the most effective way to summarize project status at a high level to audiences such as project stakeholders, sponsors, clients and management.  Typically project scorecards are made up of metrics and commentary on various things like budget, accomplishments, risks and future actions, and all of these are anchored around a clear, up-to-date project timeline.

How to Make a Project Scorecard Easily in PowerPoint

Creating fresh and appealing visual project status reports or project presentations in PowerPoint is a time consuming effort for any project manager. Additionally, these presentations often need to be re-created, updated or edited on a weekly, or monthly rhythm, so finding tools that can quickly and easily create and manage this work saves time.

Office Timeline is a free timeline maker that creates and manages PowerPoint timelines for executive and customer project status meetings.  These timelines are created natively in PowerPoint so they can easily be integrated with a project status slide or pasted onto and existing project scorecard template.

The video below demonstrates how to quickly build the timeline and scorecard slide in the image above with Office Timeline.  It also demonstrates how to update your project timeline dashboard instantly and automatically with new information as your project progresses.  This makes updating the slide for reoccurring project reviews and executive presentations automatic.

Download Office Timeline Free Edition

Suggested Reading
Pasting timelines
Exceptional PowerPoint Add-Ons
How to quickly make a timeline

Quickly turn project data into professional timelines

Build stunning, uncomplicated timelines and Gantt charts that are easy to make and simple to communicate. Get the advanced features of Office Timeline Plus free for 14 days.


Quickly Build Gantt Charts in Excel

Project plans, reviews, and proposals often need to be presented to team, clients and executives.  Gantt charts and timelines are the proper way to communicate to these audiences.  Clients and executives, in particular, expect these Gantt charts and timelines to be graphical, visually appealing and easy to understand.  However, creating a Gantt chart in Excel has been challenging and time consuming.

This post and video will show you how to quickly turn timeline Excel data into a professional looking chart, like the one below, with the Office Timeline PowerPoint add-in.Turn a Gantt chart in Excel into a PowerPoint slide

Using existing tools to create professional looking Gantt chart and timeline presentations has not been easy.  Project tools, like Microsoft Project, are intended for large scale project management.  They are complicated to learn and they produce overly complex Gantt charts and timelines which are not suited for high level customer and management presentations.

Unlike heavy-weight project tools, visual tools like Visio are better at creating graphical images like Gantt charts and timelines.  However, they are painful to use and lack “smarts” which automatically adjust images when project schedules need updating.

Excel is often the place that project plans and schedules are created.  Most professionals and project workers find it easy to do this.  Once they have their project planned or tracked, they then need to quickly turn that Excel data into a graphical chart that can presented as a project status report, proposal summary or action plan.  This work is automated by the light-weight timeline maker from Office Timeline.

Office Timeline will immediately turn a Gantt chart in Excel into a professional looking PowerPoint slide that is easy to share and present.  It automatically manages updates, so if plans or project schedules change you can quickly update your Gantt chart or timeline without having to make major edits.

How to quickly build a Gantt chart with Excel

Once you have your timeline in Excel or Gantt chart in Excel simply cut and paste it’s data into the Office Timeline PowerPoint add-in.  This video shows how to do that.

Since PowerPoint has size limitations Office Timeline also provides the ability to customize spacing and sizing to maximize the space of your slide.  This is useful for a  Gantt chart in excel that has a long list of action items (tasks).  The video below shows how you can optimize your project slide if you need to present more.

Suggested Reading
Tutorial for making a Gantt chart with Excel 
Using Gantt diagrams for business planning
How to paste Excel schedules into PowerPoint

Steps for creating a Timeline in Excel

Quickly turn project data into professional timelines

Build stunning, uncomplicated timelines and Gantt charts that are easy to make and simple to communicate. Get the advanced features of Office Timeline Plus free for 14 days.