Flags of the World in OnePager

Last week, we talked about setting up enterprise flag fields. This week, we’ll be talking about the other kind of flags, and how to include them on your OnePager timeline.

OnePager can do this from either Microsoft Project or Excel. In this example, we’ll stick to a simple Excel spreadsheet which tracks international product launches across a portfolio of pharmaceutical products:

Import the data into OnePager, and change your collection settings (Project View Properties > Rows/Swimlanes) so that all of your launch milestones are lined up left-to-right by product. This will give you a separate timeline for each product in your portfolio:

Now, we’ll use conditional formatting (Project View Properties > Task Bars > Manage Rules) to automatically assign flag-shaped milestones based on the launch country:

Once the rules are set up, you can fine-tune the formatting of your launch dates and chart background to get something like this:

Do you have another creative way that you are using OnePager’s flag milestones in your timelines and Gantt charts? Let us know in the comments below!

This entry was posted in Data Visualization, OnePager Pro Tips, PMO, Product Development, Product Management, Project Visualization by Safford. Bookmark the permalink.

About Safford

Safford is a versatile technology professional with a solid history of empowering emerging growth companies in a broad array of industries. His employment history includes energy industry consulting at Quorum Software, Senior Manager of Client Services and Technical Sales at telecom service aggregator GetConnected, and Vice President of Strategic Partner Management at electronic payment processor IP Commerce. Prior to his tenure as OnePager's COO, Safford was the company's Vice President of Marketing and Alliances. Safford holds a BA in Psychology and management from Rice University.

2 thoughts on “Flags of the World in OnePager

  1. I’m trying to figure how you included the milestone shape as a country flag in the conditional formatting rules.

Leave a Reply

Your email address will not be published. Required fields are marked *