[email protected] +1.303.779.0344

Advanced Text Column Formatting

OnePager 7.0 now supports a number of new text column formatting options.

OnePager 7.0 has expanded the number of ways that you can format your text columns. New choices include custom text column cell background colors, custom heading text, and more text rotation options. More importantly, many of these text column formats can now be templatized for future use across several different charts.

Text Column Cell Backgrounds

You can now define the default background color of text column cells, either as a single color or in an alternating pattern. To do this, go to Home > Chart Properties > Rows/Swimlanes. Each text column can have a different background color for its cells, so make sure that you have selected the correct one (Left #1 through #5), and then click Text Column Formatting:

In this example, we want to set the background color of the cells in text column Left #1 to an alternating patter of two shades of blue. If you want all cells in a text columns to have the same background color, set both backgrounds to the same color.

Any text column cell background colors set this way through Chart Properties can be templatized for use in other OnePager charts.

Changing Text Column Cell Backgrounds Manually

If you need more than two colors for a given text column level, or just want one particular text column to stand out, you can still change your text column cell backgrounds manually. These manual changes cannot be templatized, but they will be saved in the chart where you made the changes.

To change the background color of a text column cell, click once in the text column cell, wait a second, and then click again. This will select just the text column cell, as opposed to the entire row:

Text Column cell selection rectangle

Once selected, use the paint bucket on the Home tab to change the background color of the selected text column cell.

If you prefer, you can also right-click on any text column cell instead of slow-left-clicking. When you right-click on a text column cell, choose Properties... from the context menu, and then click on the Cell tab. From here, you can change the background color for the selected text column cell, among other things:

Text Column Cell Properties Form

Row Stripes

Unlike text column cell backgrounds which only color the cell of the text column, a row stripe extends across the entire chart from left to right:

Text Column Cell Backgrounds compared to Row Stripes

To adjust your row stripes, go to Home > Chart Properties > Main. In the Chart Background section, click the dropdown to select Row Stripes, and then choose your alternating colors:

Row Stripes

Changing Row Stripes Manually

Beginning in OnePager 7.0, users can customize row stripes beyond the standard alternating A/B color that is defined in Chart Properties. Keep in mind that row stripes that are set up in Chart Properties can be templatized, while manual row stripes cannot.

To paint a row stripe manually, left-click ONCE any the text column cell that is next to the row that you want to highlight. Notice that the entire row is selected, not just the text column cell:

Row selected

If you were to click a second time, the text column cell would be selected instead, but in this case, we want to select the row itself.

With the row selected, use the paint bucket to add a row stripe of any color:

Row stripe created manually.

If you prefer right-clicking, right-click in the body of the text column where you would like the text column to appear. When the context menu appears, choose Properties... and then go to the Row tab. This tab controls the formatting of your row, as opposed to your text column cells:

Row Properties Form

Text Column Values

Changing the Field Used for Text Columns

OnePager allows you to have up to five text columns on the left-hand side of your chart. The data that appears in these text columns can be changed by going to Home > Chart Properties > Rows/Swimlanes. In the Text Columns section, you will see a tab for each available text column. All of these can be mapped to any field of your choosing:

Change the field used for text columns.

Changing Individual Values in a Text Column

If you need to adjust the text in a few cells of a text column without changing the rest, you can double-click on any cell of the text column to modify the text within it.

Text Column Headings

By default, the heading at the top of each text column is data-driven based on the field that is being used to drive the values in the text column itself.

Beginning in OnePager 7.0, you can create your own custom text column headings. This is useful if the field name from Microsoft Project isn't great for reporting and you want to display something more understandable. To change your swimlane column headings, go to Home > Chart Properties > Rows/Swimlanes and click on the appropriate swimlane level (e.g. Left #1), and then click on the Swimlane Formatting button for that level:

Custom text column heading.

Uncheck the box to Make Heading Automatically, and then enter your own text in the Custom Heading box. If you want to save your custom text column headings for future use, they can now be copied to a template, just like all of the other settings in Chart Properties. In previous versions of OnePager, custom text column headings were a manual change that could not be saved to a template.