Tag Archives: Microsoft Excel

Display Certainty In Your Plan by Using Conditional Formatting

Posted on by
2

I often have users ask me how I would display a level of certainty around a particular milestone or task.

The need exists because the initiative spans many years, and therefore, items in the plan set to begin, or complete, in the near future are fairly certain in terms of their target dates.  However, items further out on the timeline need to be interpreted as loose estimates.

This is actually very easily accomplished in OnePager, as long as you have a column with a value that indicates the various levels of certainty you want to communicate.

backgammon-precision-dice-dark-red_primary

Continue reading →

OnePager 5.3 Is Here!

Posted on by
Reply

We are very excited to announce the latest release of OnePager, version 5.3.

The enhancements reviewed in the below video (Part 1 of 3) are:

  1. Standalone – you can now launch OnePager from your desktop (the add-in is now optional)
  2. Data Tab – you can now Update your Project Views without leaving the editor
  3. Direct Export to PPT or PDF
  4. Mirror settings between the Task Bars and Milestones tabs in the Project-View Properties
  5. Addition of new milestone shapes

Have a look!

Check out Part 2 next week!

OnePager Tip: Shorten Task Names for Clarity

Posted on by
Reply

Prior to using OnePager, you didn’t have to consider how much space your project plan’s task or milestone labels would consume in a chart. Regardless of how long they were, you always had to re-type them anyway into whatever other application you were using to create your reports — and most people shortened labels while retyping.  But now that you’re using your actual plan data to drive your visuals, label length is a major consideration.

Take a look at the examples below.  The first has very long labels, while the second uses only what is necessary for the audience to understand what the activity or milestone is.  (Double-click to enlarge each image.)

Too Much Text - Long Task Names Continue reading →

Video Series: Tips for Working With Large OnePager Reports (3 of 3)

Posted on by
Reply

The third video in a series that discussed tips for working with large OnePager Project Views.

Video Series: Tips for Working With Large OnePager Reports (2/3)

Posted on by
Reply

This is the second video in a series that will cover a variety of features and tips to help you work with large amounts of data in OnePager.

Automated WBS in Excel

Posted on by
3

When you’re building a plan in Excel, especially with OnePager, automated population of data can be critical to gaining efficiency in the long-run.

Organizing, updating, visualizing, and generally making sense of your plan will all be much faster and easier if you have the data there from the beginning to leverage sorting and filtering capabilities built into Excel and OnePager.

Adding a WBS is another value that can be added to your Excel plan to help in this regard, however, having to do that manually may seem daunting.  Luckily, the internet provides when it comes to Excel knowledge and we found a very nice article and template previously posted online that can might provide you an excellent start!

WBS Excel
Continue reading →

Introducing: How-To Videos

Posted on by
Reply

Chronicle Graphics is introducing a new series of how-to videos, to help our customers and potential customers better understand OnePager Pro and OnePager Express.

Our first videoexplains how to use OnePager Pro to export data from Microsoft Project to PowerPoint for presentations — all in a few mouse clicks.

Enjoy!

https://youtu.be/qI2sUyCQiUw