By default, OnePager Express labels tasks and milestones based on whatever you've designated to be the task name field in Excel. However, this can be customized so that labels are based on an Excel field that combines multiple pieces of data.
In Excel, insert a custom field such as "Label". This field will eventually concatenate to contain a combination of all of the custom data that we want to import from neighboring Excel fields.
Define an Excel formula that combines multiple fields into one, like this:
This example formula combines the "Task Name" and "Duration" fields into a single text field called "Label" that OnePager Express can use.
Now, build your OnePager report as you normally would, but on the Field Mappings page, make sure that you've selected the new combined field for labeling:
If you're trying to re-label your tasks in an existing report instead of a new one, you can do that as well. Go to Data > Replace Snapshot to bring in the new field.
Next, go to Home > Chart Properties > Field Mappings and change your labeling field:
Once you've made this change--either in a new report or one you're updating--you'll see the combined field used as your label:
Last Updated: August 12, 2020