Displaying Critical Path in Your Excel Gantt Chart

We get asked by our OnePager Express (for Excel) users every so often how they can display critical path.

OnePager Pro inherently uses the Critical column from Microsoft Project, which calculates the critical path, to visualize those values.

Excel doesn’t calculate critical path without some intensive programming on your part, and OnePager Express isn’t set up to display critical path like OnePager Pro does (a colored bar at the top of the task bar). But, it is possible. We’ve summarized how it can be quickly done below. For more detail,¬†you can also read our step-by-step instructions on how to build Excel Gantt charts with critical path.

critical-path-in-excel

First, you’ll need to designate a column in your Excel file to tell OnePager whether or not each task is on the critical path. In our example, we’ll also label our header “Critical,” and put a value of Yes or No in this column.

excel-with-critical

The next step is for us to make sure the new Critical column will be mapped into the chart, which will allow us create a conditional formatting rule to visualize the Yes values, once we have our new project view up.

Then open Chart Properties > Task Bars > Manage Rules. With the Conditional Formatting Rules dialog box open, add a rule that tells OnePager to make your shapes appear differently, based on the Yes values in your custom Critical column.

rulesAfter you click OK, and then OK again in Chart Properties, you should see the changes take place. With a little legend tinkering, you should see something like the chart above, which clearly displays the critical path as red arrows.

Have another idea? We’d love to hear it! Just leave us a comment in the blog post.

Leave a Reply

Your email address will not be published.