Using Microsoft Project/Excel Source Plans with OnePager Bundle Version 7.1

From OnePager Documentation
Revision as of 14:35, 9 May 2022 by Rfeingold (Talk | contribs) (Editing the Time Axis)

Jump to: navigation, search

Introduction

This Getting Started article provides instruction to new OnePager Bundle users where source plans are imported from Microsoft Project or Microsoft Excel either using the Add-in edition or Standalone edition of OnePager Bundle. For users who intend to import Oracle Primavera P6 or Smartsheet source plans, Getting Started instructions can be found at: Using Oracle Primavera P6 Source Plans with OnePager and Using Smartsheet Source Plans with OnePager respectively.

This article is a complete guide for using OnePager Bundle for importing Microsoft Project/Microsoft Excel files through the creation of a OnePager Chart, editing the chart, and incorporating the chart into a schedule conversation such as pasting the chart into a Microsoft PowerPoint presentation.

Add-in Versus Standalone for First Time Users

The Overview sub-section contains two sub-sections. The first describes Launching OnePager Add-in for the First Time The second describes Launching OnePager Standalone for the First Time We recommend reviewing the entire Overview sub-section before proceeding further.

Message for OnePager Bundle Users

For OnePager Bundle users coming to this article, the only difference you will see in the following article's sections and sub-section, is that examples and illustrations are based upon Microsoft Project source plans. All functions and features described herein for Microsoft Project source plans apply consistently for Microsoft Excel source plans. Where there are variations in how OnePager Bundle handles Microsoft Excel source plans differently that Microsoft Project source plans these differences are pointed out in notes.

Message for Previous Users of OnePager Pro or OnePager Express

For previous users of OnePager Pro and Express, OnePager Bundle in its Add-in and Standalone editions operates exactly the same as corresponding versions of OnePager Pro and OnePager Express in their corresponding editions.

Overview

You can launch OnePager Bundle from a Standalone Icon as well as from within Microsoft Project/Microsoft Excel (Add-in). Please note that after selecting the Add-in launch option that you are not be able to launch the OnePager Bundle Standalone application.

Only one of these applications (Add-in or Standalone) can be launched at a time. If you attempt to launch both, a warning message appears as shown below:

P70-3 0 1-70-(1)-07052019.png

If you need further information, please consult this link: OnePager Doesn't Launch when the Standalone Icon is Clicked.

This article provides the basic information needed for Getting Started and using OnePager Bundle (Add-in) after you launch OnePager Bundle for Microsoft Project/Microsoft Excel or when you launch the OnePager Bundle Standalone edition. The sub-section providing Getting Started guidance when launching from the Standalone Icon is at: Launching OnePager Bundle Standalone for the First Time The Getting Started guidance when launching from Add-in follows in the next sub-section below.

Launching OnePager Bundle Add-in for the First Time

The OnePager Bundle Add-in automatically displays the OnePager Bundle Icon on the Microsoft Project Add-in ribbon tool bar tab once OnePager Bundle is installed. That OnePager Bundle Add-in ribbon tool bar button set looks like this:

P71-3 0 3-71-(1-1)-10252021.png

Clicking the OnePager Bundle button launches the Chart Editor. Clicking the Templates… button lets you edit the Template Properties form provided with the product. For now, it is simplest to use the default Template Properties form.

You can learn how Template Properties forms let you customize and standardize graph features later at: Managing Templates (Portal)

Before you launch OnePager Bundle, it is a good idea to unhide the Microsoft Project/Microsoft Excel Flag fields that tells OnePager which Microsoft Project/Microsoft Excel Flag fields you intend to use to control the import of source plan data. Note: When you unhide a field in Microsoft Project, that field can now appear in some of Microsoft Project’s standard reports. Do not forget to hide the field again before generating such reports if you do not want the field to appear in those reports. The selected Microsoft Project Flag field allows you to control which tasks get imported and appear in the chart and are saved in Microsoft Project for future use. For example, the Flag field (e.g., Flag20) is shown below:

P61-3 0 1-61-(2)-10232017.png

To control which tasks are imported, specify the Microsoft Project/Microsoft Excel Flag field (e.g. Flag1, Flag2 … Flag20 or Show It) that you wish to use. Number fields can also be used the same as the Flag fields where a 1 in a Number field indicates Yes and a 0 in a Number field indicates No. Un-hide that field in Microsoft Project by right-clicking in the field header area and selecting Insert Column:

P61-3 0 1-61-(3)-10232017.png

Now put a Yes in this Flag field for any task that you want to graph:

P61-3 0 1-61-(4)-10232017.png

Note: For Microsoft Excel source plans a text field with Yes and No contents is typically used. In addition a Numeric field with 1's and 0's can be used. Blanks can substitute for No and 0.

When making your first chart, we strongly recommend that you select 50 or fewer tasks with Yes. Please note that OnePager Bundle is shipped with a number of fully populated Template Properties forms that are based on the Microsoft Project/Microsoft Excel source plans used in the OnePager Tutorial shipped with the product – BlueGrass Project Plan. Note that three field heading types must always be present: Name, Start, and Finish.

Caution - Starting in Microsoft Project 2010, there is a Manual Scheduling mode that allows you to leave dates blank in your schedule. However, behind the scenes, these dates are still being automatically assigned to the project Start Date, or to Today's Date if the project Start Date is not defined. Even though the dates appear to be undefined, they are defined behind the scenes, and are being passed to OnePager Bundle. Because Today's Date often equals your Snapshot date, it is not surprising to see all of these dateless tasks appearing near the time cursor.

Solutions - There are two solutions available:

1) Define the dates for your tasks and milestones in Microsoft Project. This overwrites any default dates that Microsoft Project is assigning, and makes your project schedule more consistent with your OnePager Bundle timeline. As a rule of thumb, we recommend defining dates for all tasks and milestones in your source plan, especially when it comes to creating a OnePager Bundle chart.
2) Or, remove the dateless tasks from your graph. You can leave them in your Microsoft Project source plan, but by removing them from the graph, you won't have to explain why certain task bars and milestone symbols are appearing in weird places when they really should not.

To launch OnePager Bundle and make a chart, click the OnePager Bundle button on the Microsoft Project/Microsoft Excel ribbon tool bar’s Add-ins tab, which accesses the OnePager Bundle Start form:

P71-3 0 3 2-71-(4-1)-10272021.png

The OnePager Bundle Start form provides you with three options:

1) NEW Clicking the NEW button accesses the OnePager choices (OPC) form.
2) UPDATE Clicking the UPDATE button allows you to BROWSE FILES for an existing chart or select a recently-opened chart.
3) OPEN Clicking the OPEN button allows you to BROWSE FILES for an existing chart or select a recently-opened chart.

Once selected and opened, the chart is available for editing. At this point you may wish to skip the following sub-section on launching OnePager Bundle Standalone and proceed to the sub-section covering Creating a New Chart at Creating a New Chart

Launching OnePager Bundle Standalone for the First Time

OnePager Bundle can be installed so that it can also be launched from a Standalone Icon. Additionally, you can also locate and double-click a .TAM to launch OnePager Bundle Standalone. The Standalone Icon for launching OnePager Bundle looks like this:

P71-3 0 3-71-(3-1)-10252021.png

Before you launch OnePager Bundle, it is a good idea to unhide the Microsoft Project/Microsoft Excel Flag fields that tells OnePager Bundle which Microsoft Project/Microsoft Excel Flag fields you intend to use to control the import of source plan data. Note that when you unhide a field in Microsoft Project, that field can now appear in some of Microsoft Project’s standard reports. Do not forget to hide the field again before generating such reports if you do not want the field to appear in those reports. The selected Microsoft Project Flag field allows you to control which tasks get graphed and are saved in Microsoft Project for future use. For example, the Flag field (e.g., Flag20) is shown below:

P61-3 0 1-61-(2)-10232017.png

To control which tasks are imported, specify the Microsoft Project Flag field (e.g. Flag1, Flag2 … Flag20 or Show It) that you wish to use. Number fields can also be used the same as the Flag fields where a 1 in a Number field indicates Yes and a 0 in a Number field indicates No. Unhide that field in Microsoft Project by right-clicking in the field header area and selecting Insert Column:

P61-3 0 1-61-(3)-10232017.png

Now put a Yes in this Flag field for any task that you want to graph:

P61-3 0 1-61-(4)-10232017.png

Note: For Microsoft Excel source plans a text field with Yes and No contents is typically used. In addition a Numeric field with 1's and 0's can be used. Blanks can substitute for No and 0.

When making your first chart, we strongly recommend that you select 50 or fewer tasks with Yes. Please note that OnePager Bundle is shipped with a number of fully populated Templates Properties forms that are based on the Microsoft Project/Microsoft Excel source plans used in the tutorial also shipped with the product – BlueGrass Project Plan. Note that three field heading types must always be present: Name, Start, and Finish.

Caution - Starting in Microsoft Project 2010, there is a Manual Scheduling mode that allows you to leave dates blank in your schedule. However, behind the scenes, these dates are still being automatically assigned to the project Start Date, or to Today's Date if the project Start Date is not defined. Even though the dates appear to be undefined, they are defined behind the scenes, and are being passed to OnePager Bundle. Because Today's Date often equals your Snapshot date, it is not surprising to see all of these dateless tasks appearing near the time cursor.

Solutions - There are two solutions available:

1) Define the dates for your tasks and milestones in Microsoft Project. This overwrites any default dates that Microsoft Project is assigning, and makes your project schedule more consistent with your OnePager Bundle timeline. As a rule of thumb, we recommend defining dates for all tasks and milestones, especially when it comes to creating a OnePager Bundle chart.
2) Remove the dateless tasks from your graph. You can leave them in your Microsoft Project source plan, but by removing them from the graph, you won't have to explain why certain task bars and milestone symbols are appearing in weird places when they really should not.

Clicking the OnePager Bundle Icon on the Standalone displays a splash page and then take you to the Chart Editor.

P71-3 0 3-71-(4-1)-10252021.png


P71-3 0 3-71-(5-1)-10252021.png

The OnePager Bundle Start form provides you with three options:

1) NEW Clicking the NEW buttons bring up the OnePager choices (OPC) form.
2) UPDATE Clicking the UPDATE button allows you to BROWSE FILES for an existing chart file or select a recently-opened chart.
3) OPEN Clicking the OPEN button allows you to BROWSE FILES for an existing chart or select a recently-opened chart.

Once selected and opened, the chart is available for editing. Please continue on to the next sub-section - Creating a New Chart.

Creating a New Chart

Clicking the NEW button accesses the OnePager choices (OPC) form as shown below:

P71-3 0 3 2-71-(6-3)-02082022.png

Options on the New OnePager Choices form

The OPC form gives you more options for selecting source plans. The illustration above shows that OnePager Bundle is initiated from Microsoft Project with the source plan shown in the Selected File(s) group shown above. The Add/Remove button gives you the capability to add more source plans to the source packet or, for multiple file packets, to remove files. Clicking the Add/Remove button accesses the Data source selection form as shown below:

P71-3 0 3 2-71-(7-2)-02082022.png

The Data source selection form displays the current source plan that was loaded with Microsoft Project when you clicked the OnePager Bundle button. This form lets you Add more Microsoft Project source plan to create a multi-project chart or Remove a source plan from a multi-file source packet. The same procedure applies when you are using Microsoft Excel as your source plan. These options are detailed below.

Adding a New Source Plan

When you click the Add button, OnePager Bundle gives you the option to bring up a Windows Open form when you select the BROWSE FILES… option as shown here:

P71-3 0 3 2-71-(8)-06142021.png

Clicking the BROWSE FILES… option displays a Window’s Open form so you can select a Microsoft Project source plan to add to the source packet. A sample Open form is shown below:

P71-3 0 3 2-71-(9)-06142021.png

When you select a desired Microsoft Project source plan and click the Open button as shown above, OnePager Bundle adds the source plan to the source packet and displays it in the Data source selection window as shown below:

P71-3 0 3 2-71-(10)-06142021.png

The selected source plan is added to the source packet as shown above. OnePager Bundle shows the path name of the source plan in the window if you hover the mouse over the source plan name. If you select a recently used source plan from the dropdown menu displayed when the Add button is clicked (Data source selection form), OnePager Bundle adds that source plan to the source packet.

Removing a Source Plan

The Remove button allows you to remove a source plan from a source packet if that source plan is not needed to create the new chart. To remove a source plan, first select the source plan in the Data source selection form’s window so that it is highlighted in blue then click the Remove button as shown in the sequence below:

P71-3 0 3 2-71-(11)-06142021.png


P71-3 0 3 2-71-(12-1)-06142021.png

Other Choices to Make

Moving on to the other groups of the OPC form, you are asked to confirm a few things before you build the chart. OnePager Bundle makes good guesses for each of these choices, but you can change any of them:

P71-3 0 3 2-71-(15-2)-02082022.png

Starting Template Properties Form

The current Template Properties form determines which fields are imported from Microsoft Project/Microsoft Excel and how the initial chart looks. OnePager Bundle ships with many sample Templates Properties forms, but you can also customize your own Template Properties form. To choose which Template Properties form to use in building your chart, click the Change… button in the top group of the OPC form as shown here:

P71-3 0 3 2-71-(15A-2)-02082022.png

The dropdown list shown in the illustration above only shows RECENT and PERMANENT Templates selections for the source plan type you selected previously in the Selected File(s) sub-control group above.

Note there are Microsoft Project and Microsoft Excel Template Properties forms distributed with OnePager Bundle. It is required that the Template Properties form you use matches the type of source plan file being imported to OnePager Bundle. If the source plan file type and the Template Properties type do not match, OnePager Bundle issues this message:

P71-3 0 3 2-71-(15AA)-06142021.png

For now, just stick with the default Template Properties form entitled Single Project Gantt View – Detailed, but you can always use a different Template Properties form to get a different type of chart.

Title of the New Chart

This is the Title of the chart and also the suggested save name. You can change the save name when you save it. We recommend that you enter a Title that helps you identify the chart later on as shown here:

P71-3 0 3 2-71-(15B-2)-02082022.png

For each chart you create, OnePager Bundle remembers colors, titles, legends, font sizes, and all other graph properties so that your work is saved. Later, you can update the chart with a snapshot of how the project looks on a different date. Then you can browse through the snapshots to see how the project is changing over time. OnePager Bundle also saves the path name associated with the save name (.TAM). Path names are not available in .TAMs produced with versions of OnePager Pro or Express prior to version 6.0.

Task Selection

This is how you tell OnePager Bundle which tasks to import from your Microsoft Project source plan as indicated below:

P71-3 0 3 2-71-(15C-2)-02082022.png

Either click the Select all tasks radio button to create a chart with everything or choose a Flag field. You can make several charts from a single Microsoft Project source plan, each using a different Flag or Number field. In OnePager Bundle, if no Flags are set to Yes, OnePager Bundle provides you with a warning message shown below:

P71-3 0 3 2-71-(15D)-06142021.png

Clicking the Select tasks by custom filter button enables the Edit filters... button. Clicking the Edit filters... button takes you to a form that controls the Conditional Import Filters feature as shown here.

P71-3 0 3 2-71-(15E-2)-02082022.png

For more detailed information on Conditional Import, please see the article at: Conditional Import Filters (Portal)

Snapshot Date

This is the date of the chart and lets you keep track of how schedules change over time. The snapshot date is set by default from your Microsoft Project source plan's Project Information tab's Current date. You can change the snapshot date by clicking on the dropdown button at the window shown in the illustration below:

P71-3 0 3 2-71-(15F-2)-02082022.png

Making a calendar date selection as shown above establishes the snapshot date for the chart and the snapshot being created. Each chart can have many snapshots. Snapshots and their management are important topics. Snapshots are the basis of how OnePager Bundle helps you track the progress of your project.

For more information, please see the articles at: Managing Chart Data (Portal)

Show Field Mappings

The Show field mappings checkbox is near the bottom of the form. When this box is checked ON you have a chance to review and change the Microsoft Project/Microsoft Excel field mappings to OnePager Bundle before you make your first chart. To do this, click the Next> button as shown here:

P71-3 0 3 2-71-(15G-2)-02082022.png

You now see the following form:

P71-3 0 3 2-71-(16)-06142021.png

Notice in the above form that OnePager Bundle has relied on the current Template Properties form to make some guesses on which Microsoft Project/Microsoft Excel source plan fields should be used in making the chart. You can easily change any of these field mappings by making selections from the dropdown menus. For example, shown below is how to change which Finish Date in Microsoft Project is used to create the chart's Finish Date:

P71-3 0 3 2-71-(17)-06142021.png

This same procedure can be used to change fields associated with Microsoft Excel source plans.

Note for Microsoft Excel Users Importing Source Plans to OnePager Bundle

We recommend the inclusion of an ID field with sequential numbering from top to bottom. This assists OnePager Bundle maintain a correspondence with Microsoft Excel’s rows after the Microsoft Excel source plan is updated.

X70-3 0 3-70-(3)-12082020.png

This assists OnePager Bundle maintain a correspondence with Microsoft Excel’s rows after the Microsoft Excel source plan is updated.

Making the Graph

Once you are satisfied with the field mappings, click the Create new chart button to import the desired Microsoft Project/Microsoft Excel source plan data and create a OnePager Bundle chart. After a second or two you see the Chart Editor form that looks like this with a chart made from a Microsoft Project source plan:

P71-3 0 3 2-71-(18-1)-10272021.png

Note that each task bar or milestone symbol is color coded based on the value in the Resource Names field. The Legend contains an optional diagram near the bottom explaining that the bars inside the task bars represent percent complete extracted from Microsoft Project/Microsoft Excel. Percent complete comes from a Microsoft Project field that you specified in the field mappings form. For Microsoft Excel, OnePager Bundle does not support the display of Critical Path. Note that the current Template Properties form is the Template use by OnePager Bundle to create the first chart and determines how your data looks in the new chart. The Template Properties form's Task Bars tab shows where the color control is located is shown below:

P71-3 0 3 2-71-(19)-06142021.png

Copying the Chart to Microsoft PowerPoint

OnePager Bundle provides access to the Windows clipboard so you can copy the chart and paste it into another application. To copy the current chart snapshot to the clipboard click the Copy button on the Home ribbon tool bar tab as shown below:

P71-3 0 3 3-71-(37A-1)-06102021.png

Then launch Microsoft PowerPoint and paste the clipboard copy of the chart into a Microsoft PowerPoint slide, as shown below:

P71-3 0 3 2-71-(37)-06142021.png

That’s it! You’ve created a professional 1-page schedule summary from a complex Microsoft Project/Microsoft Excel schedule and copied it into a Microsoft PowerPoint presentation. You can also print the chart by selecting the Print button on the File tab. OnePager Bundle has other features that let you move task bars vertically to different rows and swimlanes, change the number and levels of swimlanes, add swimlane titles, show graphic dependencies among tasks, change task bar colors, hide task bars, edit text items, add floating comment boxes, add comment boxes to task bars, and standardize on chart styles across organizations.

To learn more about these features, read about the specific workflows in this Wiki at: Basic Workflows (Portal) and Manual Editing Task/Milestone Shapes and Text Labels (Portal)

Opening a Chart

The right-most button on the OPC form is the OPEN button. Clicking the OPEN button displays a dropdown menu which is the same for the UPDATE button. The options in the dropdown are discussed below:

P71-3 0 3 2-71-(19A-1)-10272021.png

Clicking the BROWSE FILES... option accesses a Windows Open form from which you can select a .TAM that you want to open. Selecting the desired .TAM causes OnePager Bundle to display the selected chart in the Chart Editor. From the Chart Editor, you can edit the chart, save it, or share it with others. Clicking any of the RECENT charts items in the dropdown menu above causes OnePager Bundle to load the associated .TAM into the Chart Editor.

Updating a Chart

OnePager Bundle Add-in supports updates to your chart through the UPDATE button found on the OnePager Bundle Start form. Clicking the UPDATE button provides the same options in terms of a dropdown list as described above for the OPEN button. A sample UPDATE button dropdown is shown here:

P71-3 0 3 2-71-(4A-1)-10272021.png

Updates to OnePager Bundle charts are performed by adding snapshots which are a series of charts produced from a sequentially updated Smartsheet source plan over time. Updates can be made to existing charts in the set of existing snapshots.

Snapshots are identified by a snapshot date. The management of snapshots with a chart is described in the sub-sections that follow.

Replacing A Snapshot - Updating a Chart with Changes Made to the Microsoft Project/Microsoft Excel Source Plan's Data

Suppose, after examining the chart you created and saved, you realize that it might be best to show more task bars. This, you think, would greatly improve your schedule presentation. Updating the chart at this point is simple. Recall that OnePager Bundle is active and the Chart Editor is displaying the current chart you want to update. Additionally, the Microsoft Project/Microsoft Excel source plan and the application are active. The original chart looked like this:

P71-3 0 3 2-71-(18-2)-10272021.png

Since Microsoft Project/Microsoft Excel is still an active program and the Microsoft Project/Microsoft Excel source plan you are using is still being displayed, go back to the Microsoft Project/Microsoft Excel application and change the Flag20 field setting (for the Microsoft Project example) from No to Yes for the tasks you want to now import and display. A section of the Microsoft Project source plan where this is done is shown below:

P61-3 0 1-61-(19A)-10232017.png

Once you’ve made the Flag20 changes lines 8 through 15 in the Microsoft Project the source plan looks like this:

P61-3 0 1-61-(19B)-10232017.png

With the Microsoft Project source plan updated, go back to OnePager Bundle and navigate to the Data ribbon tool bar tab where you see several buttons. To update your chart to show the additional task bars from your Microsoft Project source plan, click the Replace Snapshot button as shown below:

P71-3 0 3 2-71-(19C-1)-10272021.png

When you click the Replace Snapshot button, OnePager Bundle goes back to the Microsoft Project/Microsoft Excel source plan that you just changed, imports all the tasks that changed, and updates your chart. At the conclusion of the operation, the updated chart looks like this:

P71-3 0 3 2-71-(19D-1)-10272021.png

The example above using a Microsoft Project source plan is just one of many uses of the Data ribbon tool bar tab’s Replace Snapshot button when you need to update a chart. You can do this as many times as necessary until the chart is the way you need it. In addition to adding and removing tasks by changing the Microsoft Project Flag20 field, you can change source plan task Start Dates, Finish Dates, or Percent Complete and display these data changes in the chart. Using the procedure above you can do this very efficiently. You can now save the chart by giving it a save name. When you save the chart in OnePager Bundle, the .TAM, the Microsoft Project source plan name, and path information are saved. This is useful when you want to further update the chart or when you want to add a snapshot later on. In the examples below we assume that the chart is saved as BlueGrass Project Report - Bundle.

Adding a Snapshot - Adding to the Chart with Changes Made to the Microsoft Project/Microsoft Excel Source Plan's Data

The power of OnePager Bundle is illustrated when, after a period of progress on the project, it is time to produce another chart. OnePager Bundle produces your next snapshot with the same look and feel as the original. assuming that the Microsoft Project/Microsoft Excel source plan was updated with actual start and finish, percent complete, and other relevant data during the reporting interval, OnePager Bundle can easily generate a new snapshot. Suppose we have the following chart created on 1/2/2019 and we want to create another graph from the updated Microsoft Project source plan on 8/1/2019.

P71-3 0 3 2-71-(18-1)-10272021.png

Before creating a new snapshot for 8/1/2019 as planned, we need to update the Microsoft Project source plan say by updating the Percent Complete for the ADONIS Subcontractor Selection task to 75%. When the source plan is updated with this revised information we can proceed. Launch OnePager Bundle either from Microsoft Project (Add-in) or from the Standalone Icon and click the UPDATE button on the OnePager Bundle Start form. Doing so accesses the following OnePager choices (OPC) form shown here:

P71-3 0 3 2-71-(20A-3)-02082022.png

In the OPC form select the NEW snapshot at date: as shown above. You can also select a date for the snapshot so that this snapshot represents the project at the status date point in time. To see which snapshot dates already exist, just position your mouse over the NEW snapshot at date: window to see a list of the existing dates.

P71-3 0 3 2-71-(20B-2)-02082022.png

You can use the built in calendar dropdown or type in the new snapshot’s month, day, and year in the window provided as shown below:

P71-3 0 3 2-71-(20C-3)-02082022.png

Un-check the Show field mappings checkbox OFF if you want to use the same field mappings as you used before. The bottom of the screen now looks like this:

P71-3 0 3 1-71-(26)-06072021.png

Pressing the large New button creates a new snapshot for the chart. The chart opens at the new snapshot. The color, fonts, title, and swimlane assignments are consistent between the two snapshots:

P71-3 0 3 2-71-(20D-1)-10272021.png

You can go back and forth between the two snapshots by using the snapshot forward/backward buttons on the View ribbon tool bar tab as shown below:

P71-3 0 3 2-71-(20E-1)-10272021.png

Editing the Chart

Editing Task Bar Name Label Font Sizes

You can always edit the font sizes and label positions on task bars and milestone symbols to optimize readability. To do this, hold down the left mouse button and drag a selection box (Lasso) that encloses many task bars and milestone symbols at once:

P71-3 0 3 2-71-(29-1)-10272021.png

When you release the mouse, the enclosed task bars and milestone symbols are all be selected:

P71-3 0 3 2-71-(30-1)-10272021.png

Click the Increase Font Size button on the Home ribbon tool bar tab shown below:

P71-3 0 3 2-71-(31-1)-10272021.png

The chart now looks something like this:

P71-3 0 3 2-71-(32-1)-10272021.png

Repeating this operation for the remaining task bars and milestone symbols (we could have done Select All and done it all at once!), we can now edit the chart so that all task bars and milestone symbols have larger fonts:

P71-3 0 3 2-71-(33-1)-10272021.png

Editing Task Bar Name Label Positions

Another common editing action is to move the task bar's name label from their current positions to positions elsewhere around or on the task bar. To do this, click the name label to select it and then click the Label Position button on the Home ribbon tool bar tab. This action accesses the Label Position dropdown list where you can select one of the label positioning buttons as shown here:

P71-3 0 3 2-71-(34-1)-17282021.png

At this point, as an example, click the Left option in the dropdown and the selected name label is moved to the left side of the task bar as shown here:

P71-3 0 3 2-71-(34A-1)-17282021.png

In case you change your mind about the last editing action you took, you can UNDO the last editing action by clicking the UNDO button above the OnePager Bundle ribbon tool bar tabs. Successive clicking the UNDO button undoes editing actions in the reverse order that they were applied.

P71-3 0 3 2-71-(35-1)-17282021.png

Save the edited chart by pressing the Save button above the ribbon tool bar tab next to the UNDO button. All of the font size changes, text-position edits, and the new Legend position are now saved in case you need to update this chart with new data at a later time.

Editing Other Chart Contents

The examples above are just samples of Chart Editor capabilities provided for editing within the chart. Making other edits to task bars and milestone symbols and name labels are covered in more detail in this article: Manual Editing Task/Milestone Shapes and Text Labels (Portal)

Additionally, you can add task bar and milestone symbol information related to each activity and milestone imported such as baseline data, percent complete information, and critical path information. You can add comment boxes to task bars, free floating comment boxes in the chart, vertical curtains, task links to show dependencies, multiple swimlane levels and background images. And you can change the chart's Start/End Dates, add or hide the Legend, and add time axis levels at the top, bottom, and within the graph (floating time axis rows). Further, you are able to edit task bar and milestone symbol shapes, colors, and fill patterns; you have controls for editing rows/swimlanes, text columns, headers and footers in the chart, background colors, and other text information shown in the graph.

These capabilities and the articles that provide the detailed information on how to use them can be found at: Ways to Make Changes to Your Chart

Enhanced Editing Capabilities Provided in OnePager Bundle

All editions of OnePager are distributed with all the enhanced capabilities previously available in OnePager Pro and Express. These capabilities include Multiple Swimlane definition and editing, display and editing of Task Links, and additional features for displaying and editing on the Time Axis.

Multiple Swimlane Levels

Previous versions of OnePager Pro and Express supported one level of swimlanes which allowed you to group rows together based on a particular source plan data field and its values. OnePager Bundle now supports three swimlane levels which can be nested inside one another to better display a hierarchy relationship for a Program, it’s Projects, and their Phases as shown here:

P70-0 4-70-(20)-03102020.png

In the illustration above, the first swimlane level is “Program” and under it as the second swimlane level are its “Projects”. The third swimlane level under each “Project” are “Phases” and the rows within each Phase show the task bars at their appropriate start/end dates. Definition and editing of these multiple swimlane levels is accomplished in the Template Properties and Chart Properties form’s Rows/Swimlanes tab that is modified to provide all the controls necessary to manage these multiple swimlane levels in the chart. The Rows/Swimlanes tab of the Chart Properties form is shown below:

P71-3 0 3 2-71-(21-1)-06152021.png

In addition to adding multiple swimlane levels, the tab shown above is simplified by reorganizing the controls associated with Rows and Text Columns. Sorting controls for rows and swimlanes are in separate sub-control groups as shown above. There is a Row Borders Formatting… button in the Rows control group with the controls for defining and global editing of row borders and access buttons for Swimlane Formatting… and Text Column Formatting… The controls shown above for the Chart Properties form are also found in the distributed Template Properties form’s Rows/Swimlanes tab. More detailed introductory information on the new Multiple Swimlane Levels feature can be found at these links:

Using Rows and Swimlanes
Creating and Editing Rows and Swimlanes (Portal)

Displaying Data-Driven Task Links

OnePager Bundle is enhanced to assist you with displaying Microsoft Project Predecessor fields in your chart. Typically, this feature is turned OFF in all Template Properties forms distributed with OnePager. However, the feature can be turned ON either before or after the creation of a chart. To turn the Data-Driven Task Link feature ON prior to creating a chart, go to the Template Properties form you plan to uses and click on the Task Links tab and then click the Import predecessors checkbox in the Data-Driven Task Links control group as shown below:

P71-3 0 3 2-71-(38-2)-10382021.png

With the Import predecessors checkbox checked ON in the Template Properties form, the chart first created looks like this:

P71-3 0 3 2-71-(39-1)-10382021.png

To turn the Data-Driven Task Link feature ON after the chart is created, go to the Chart Properties form's Task Links tab and then click the Import predecessors checkbox ON in the Data-Driven Task Links control group as shown below:

P71-3 0 3 2-71-(40-2)-10282021.png

Once imported, Data-Driven Task Links can be shown or hidden and can be edited globally using the Template Properties or Chart Properties forms as shown above or individually using a task link right-click context menu. OnePager Bundle continues to support manual Task Links which in previous OnePager versions were called Event Links. The OnePager Bundle Data-Driven Task Links feature is flexible and powerful.

More details are provided in the series of articles at: Linking Task and Milestone Using Manual and Data-Driven Task Links (Portal)

Editing the Time Axis

OnePager Bundle is also enhanced with new capabilities and feature so you can edit the time axis and configure it to focus on specific time periods of interest in your project schedule presentation. As an example of the enhancements made to the time axis is the addition of the time axis cell stretch feature where you can lengthen the horizontal extend of any time axis cell so as to provide more space to focus on details within that time period. An example of a stretched lower level time axis cell is shown below:

P71-3 0 3 2-71-(41)-06152021.png

For additional detailed information on the editing of time axis cells and other related capabilities please see this article at: Modifying the Time Axis (Portal)

Related Links

What's New with OnePager Release 7.1? Video

OnePager Doesn't Launch when the Standalone Icon is Clicked

Contact OnePager Support

What's New with OnePager Release 7.1?

Installing and Activating OnePager Bundle (Portal)

Getting Started with OnePager Pro Version 7.1

Getting Started with OnePager Express Version 7.1

Using Oracle Primavera P6 Source Plans with OnePager

Using Smartsheet Source Plans with OnePager

Using Rows and Swimlanes

Basic Workflows (Portal)

Conditional Import Filters (Portal)

Manual Editing Task/Milestone Shapes and Text Labels (Portal)

Creating and Editing Rows and Swimlanes (Portal)

Linking Task and Milestone Using Manual and Data-Driven Task Links (Portal)

Modifying the Time Axis (Portal)

Managing Chart Data (Portal)

Managing Templates (Portal)

(3.0.3.2-71)