Importing Fonts into OnePager

When it comes to timelines and Gantt charts, appearance matters. The whole point of creating a chart in OnePager is for it to be a visual project report. In addition to colors and shapes, the font you use can make a big impact on the overall look and feel of your chart.

The first step in adding a new font to OnePager is to add it to Windows. Microsoft has put together detailed step-by-step instructions on how to do this:

Add a font – Microsoft Support

After you have added the font(s) to Windows, launch OnePager and go to Chart Properties. Open any form that has a font control. In this example, we will change the Task Label to a custom font called “KG Chasing Cars.” Once you have selected the font, click OK and OK.

Continue reading

OnePager IQ Test Results Update: You Need Training

Back in early January, we posted a OnePager IQ Test. The results have made it clear that our users could use some training.

Click this link to take the test.

To date:

  • 116 users have taken the test.
  • The average score is 49
  • The high score is 90 (1 person)
  • The low score is 20 (1 person)
  • The average time to take the quiz was 9 minutes 30 seconds (we didn’t count the two who took over an hour)

Continue reading

Is America Turning Purple?

With Hillary Clinton scheduled to accept the Democratic Party’s nomination for president tonight in Philadelphia, the U.S. general election is officially upon us.

Election Results

Click the image to expand.

That means we can expect plenty of fireworks, cable news prognostication, and partisan bile in the next three months. Most of that, it’s safe to say, is best ignored. Fortunately, an election year also brings plenty for the history- and data-minded among us.

With Nov. 8 in mind, we took a look at how state-by-state voting results have changed over the last 13 presidential elections. You can find our visualization – made in OnePager for Excel – here, or expand it by clicking the thumbnail on this page. Bright blue means an overwhelming Democratic victory, and red means the same for the Republicans. Shades of purple represent a closer vote; true purple would be a 50-50 tie.

What do we learn when we examine historical voting trends this way? Quite a few things. Continue reading

Visualizing a ‘Brexit’ Project Plan

It’s enough to make any professional project manager’s skin crawl. The United Kingdom’s pending exit from the European Union – the biggest shakeup in Western statecraft since the fall of the Soviet Union – appears to be proceeding essentially without a plan.

David Cameron, Britain’s Prime Minister, is stepping down before October. He’s said he won’t trigger Article 50 – the EU’s method for a member state resigning – in the near future; that’s up to his successor. And even when (or if) Article 50 is invoked, no one quite knows exactly how the “Brexit” itself will work – the rule has never been used.

Continue reading

Visualizing Greatness: Muhammad Ali’s Pro Boxing Career

As you surely know by now, boxer, social activist and global icon Muhammad Ali died over the weekend at age 74.

While there was so much more to Ali’s life than just his boxing career, it’s stunning to look at what he accomplished (and what more he could have accomplished) in the ring.

Using Microsoft® Excel and OnePager® plan communication software, we’ve created a visual representation of Ali’s 20-plus year boxing career. Flags represent the location of his fights (the 1974 “Rumble in the Jungle” against George Foreman, for instance, was contested in Kinshasa, Zaire).

Continue reading