For anyone who has created a schedule, one of the essential things to know is percent complete. Users of OnePager know we already offer ways to show percent complete via a yellow bar, text, or a checkmark. However, we will dive into another method: color coding different tasks based on a percent complete range.
We will first want to determine what percent complete ranges we want to create rules for and what color will represent them. In this example, I will be using the following ranges.
In my view, among the many great features of OnePager, none beat Conditional Formatting. With Conditional Formatting, you can create rules to change the color, shape, fill, and other properties of tasks and milestones based on specific rules that you set. However, what happens when you have multiple values to which you need the same rule to apply? You could create a bunch of separate rules, but that’s a lot of work. In this article, we will go over how you can create a conditional formatting rule that tests for multiple conditions at once.
Imagine with me, if you will, that you have a schedule with individual resources assigned to different tasks. Each resource is part of a specific team in your organization, and you would like to be able to color tasks based on the team that the people belong to, not based on their individual names.
When creating a schedule in an Excel spreadsheet, you will have a Start date and Finish date. But there is also a time associated with those dates, and if you don’t set it, your tasks may appear to finish earlier than expected. In the example below, both tasks finish on the seventh day, but the blue task finishes at 12:00 a.m. and the red task finishes at 11:59 p.m., almost a full day later. Paying attention to the times associated with your dates in Excel will help you ensure that a task is scheduled correctly.
This blog will go over an addition to make to the formula in your Excel spreadsheet to change the time of your task Finish date.
With a Gantt chart, you can display Start/Finish dates that show exactly when a task starts and finishes. However, in this blog, we will be creating a dateless chart to show a graphical representation of your schedule without any specific dates displayed.
We will start at the top of the chart with the Time Axis representing different tic units. In the example, we utilize the Month and Week units of the Time Axis.
In Microsoft Project, a field called Finish Variance shows how many days there are between the Finish and the Baseline Finish fields. Using this data can be helpful when trying to determine if your tasks are finishing on, before, or after their planned finish dates.
If you want to use the Finish Variance field in your OnePager Conditional Formatting Rules to show visually if your tasks are late, you’ll run into an issue: Microsoft Project treats Finish Variance as a string field instead of a number.
Did you know that you can “maverick” tasks or milestone shapes in OnePager?
This is the term we use when one or many shapes in the body of the chart have had any of their properties manually modified.
If you happen to modify one or many shapes using the capabilities in the Home tab on the Ribbon (Font, Format, Alignment, Position), or right-clicked on a shape and chosen Format to reveal the Change Task/Milestone Properties to make a change there… you have “mavericked” your shapes.
Theoretically, we here at OnePager are experts on … OnePager. But, having been in the business of helping project managers present clear and eye-catching Gantt charts for many years, we have picked up a lot of tips and tricks along the way about the project and portfolio management (PPM) software that feeds data into OnePager.
In case you didn’t get the feeling at any point in your previous business exchanges with us, I’d like to tell you now: We’d like your business for as long as you live and work.
We realize this isn’t something a product alone can achieve; it’s something that we humans under the hood must commit to daily in order to earn it.
It’s something we talk about regularly during our meetings, and every now and then we get a little pat on the back from a customer who is momentarily inspired to share their appreciation for the attention we’ve given them.
No application is perfect, but our development team works hard every day (weekends too!) to make OnePager better.
Given this customer-centric focus, your feedback is enormously important to us. Negative, or positive, or even if you just have a wish list for what you want the application to do, please find a minute to send us your thoughts.