Managing the Graph Y-Axis in OnePager for Version 8.0 (P80-7_3_25_1-80-04142026.docx)

Introduction to Graph Y-Axis Properties Controls

Illustrations used in this article are from OnePager Pro Add-in and Standalone using data from Microsoft Project, however, Graphs & Data Cells features, functions, controls, and editing apply equally to all OnePager Add-in and Standalone editions that import from data sources like Microsoft Excel, Smartsheet, Oracle Primavera P6, Planisware Enterprise, Asana, and Wrike. At present Microsoft Planner source plans do not provide time-series data that can be processed and displayed by the Graphs & Data Cells feature of OnePager.

This article and the articles linked from here describe OnePager’s Graphs & Data Cells feature which provides you with the capabilities to show graphs of time-series data (e.g., cost data) in graphic forms along with your Gantt/Timeline Charts. Additionally, the Graphs & Data Cells feature also provides you with the ability to show time-series data (e.g., cost data) imported from your source plan in tabular forms.

This article describes the controls in the Graph Elements control group of the Chart Properties form’s Graphs & Data Cells tab for managing and editing a Graph’s Panel Y-Axis as shown below:

P80-7_3_25_1-80-(1-3)-03312026.png

The Graph Elements control group shown above for the Chart Properties form has four controls that are applied to each Panel and Series within Panels in Graph mode. The four controls are enabled by checking the corresponding control checkbox ON or disabled by clicking the corresponding checkbox OFF. When enabled the controls in the Graph Elements control group apply to all Series in the enabled Panel. By default, three of the controls Graph Elements control group checkboxes are checked ON where the only exception is the X-Axis Properties checkbox where the default is disabled.

Of interest in this article is the Y-Axis Properties sub-control group highlighted above. This sub-control group provides access to the controls that define, manage, and edit the Y-Axis for the Panel and all the Series that are enabled within the Panel. In order to access the Y-Axis Properties’ controls, it is necessary to check the Y-Axis checkbox ON to the left of the Y-Axis Properties button. Once checked ON, the Y-Axis Properties button is enabled and when clicked accesses the Panel’s Y-Axis Properties – Panel #n form shown below:

P80-7_3_25_1-80-(2-3)-03102026.png

The Y-Axis Properties – Panel #n form has two (2) major control groups that are presented in detail in the sections that follow.

Y-Axis Properties – Panel #n Form - Axis Title Control Group

The Y-Axis Properties – Panel #n form has two control groups where the first provides controls for Titling the Panel’s Y-Axis and the second control group has four sets of controls for establishing Tic-Units, Tic Formatting, Tic-Line Style settings, and Tic-Label Number Formats as discussed in the following sub-sections.

The Axis Title control group provides controls for showing and hiding the Y-Axis Title for the Panel, editing the Y-Axis Title’s font properties and Title text rotation in the Panel. The default setting is for the Y-Axis title to be hidden with the Show title checkbox checked OFF.

The Y-Axis Title is positioned in the Graph area to the left of the Panel’s Graph data area. The Y-Axis Title has preset default font properties and text rotation in the Graph area and how its text is positioned centered between the top of the Panel and the bottom of the Panel’s Graph data area. The Y-Axis height is taken into consideration when positioning the Y-Axis Title text.

Y-Axis Show title Checkbox and Title Preview Window

When the Show title checkbox is checked ON, the Y-Axis Title takes on the text of the imported time-series field as shown below where the Cost field is imported from the source plan:

P80-7_3_25_1-80-(2-2)-02182026.png

As an example, when the form above is closed by clicking the OK button and the Chart Properties form is also closed or applied, the Graph area of the Chart looks like this:

P80-7_3_25_1-80-(3)-07072025.png

Y-Axis Title Font Dropdown and Font properties Form

The default Y-Axis Title font is shown above. Clicking on the Title Font dropdown arrow accesses the standard OnePager Font properties form where you can edit the Y-Axis Title’s font, color, size, and other properties as shown here:

P80-7_3_25_1-80-(4-2)-02182026.png

Y-Axis Title Rotation Dropdown

There are two (2) options associated with the Title rotation control as shown here:

P80-7_3_25_1-80-(5-1)-02182026.png

The default 270 degree rotation option is shown in the Chart’s Graph area illustration above. The 90 degree rotation option is shown below:

P80-7_3_25_1-80-(6)-07072025.png

Y-Axis Enter Custom Title Checkbox and Custom Title Window

You also have the option to enter your preferred custom Y-Axis Title by checking the Enter custom title checkbox ON. This checkbox is only enabled when the Show title checkbox is also checked ON. This action enables the Custom title window so it’s ready to receive your Custom title text as shown below:

P80-7_3_25_1-80-(7-1)-02182026.png

Entering a Custom title text is automatically previewed in the Title preview window shown above. Clicking OK in the Y-Axis Properties – Panel #n form and Apply or OK in the Chart Properties form applies the Custom title text to the Panel’s Y-Axis as shown below:

P80-7_3_25_1-80-(8)-07072025.png

OnePager automatically wraps Custom title text strings if they are too long fit in the Panel’s selected Graph Height. This is illustrated below:

P80-7_3_25_1-80-(9)-07072025.png

Increasing the Graph Height can be used to un-wrap Y-Axis title text as shown here where the Graph Height is increased to 4.0:

P80-7_3_25_1-80-(10)-07072025.png

Decreasing the Graph Height value causes the Y-Axis title text to become re-wrapped as illustrated below when the Graph Height is reset to 1.5:

P80-7_3_25_1-80-(11)-07072025.png

Un-checking the Enter custom title checkbox to OFF tells OnePager to revert to the imported Y-Axis Title text as shown in the Y-Axis Properties – Panel #n form’s Title preview window below:

P80-7_3_25_1-80-(12-1)-02182026.png

OnePager retains the Custom Title with the Chart when the Chart is saved so that the Custom Title can be used in the future, if desired. Blanking the Custom Title clears the text contained in the window making it unavailable for future use.

Reminder: There are three Series in each Graph mode Panel and only one Y-Axis which applies to all Series. It is highly recommended that all Series use the same units for the Panel’s Y-Axis.

Y-Axis Properties – Panel #n Form – Tic-Marks, Tic-Lines, and Tic-Labels Control Group

The Tic Marks, Tic-Lines, and Tic Labels control group consists of four (4) sub-control groups all associated with managing and editing the Y-Axis label properties for the Panel as highlighted here:

P80-7_3_25_1-80-(12C)-03312026.png

These four sub-control groups and their controls are detailed in the sub-sections that follow.

Tic Units Sub-Control Group

The Tic Units sub-control group provides the controls for managing and editing the Vertical Tic units on the Panel’s Y-Axis where you have the option for OnePager to establish the intervals (Auto radio button) or you can set values for the Minimum, Maximum, and Step in their windows to establish those settings yourself (Custom radio button).

Auto Radio Button

The Auto radio button is the default selection in the Y-Axis Properties – Panel #n form whereby OnePager examines the imported data for the Panel and its Series, determines the maximum and minimum values and establishes an appropriate Step interval based upon the Graph Height and other factors. All the previous illustrations of a Chart with a Graph area in this article are constructed using the Auto feature in the Units sub-control group.

Custom Radio Button

Clicking the Custom radio button enables the three windows in the sub-group as shown below:

P80-7_3_25_1-80-(13-1)-02182026.png

When in Custom mode, the values for the Minimum, Maximum, and Step are retained from the setting established by OnePager from the previous Auto mode. Otherwise, when initially entering Custom mode, these values are preset to zero (0). You can use the three windows to establish your own settings. OnePager uses your settings to establish the Vertical Tic units in the Graph area for the selected Panel and Series.

For best results, we recommend the following:

1) Avoid decimal fractions. OnePager performs rounding to the nearest integer value.

2) Make sure the Maximum is always greater than the Minimum.

3) Negative integers are accepted as long as number 2) above is observed.

4) The Step interval setting should not exceed the Maximum value, should not be zero (0), nor be a negative integer.

As an example, examining the Cost data from the example source plan, OnePager found that the maximum for those tasks selected for import is $4,000,000.00 and the minimum is $0.00. Given this range, OnePager set the Step interval to $1,000,000.00 and the resulting Chart and Graph area looks like this:

P80-7_3_25_1-80-(14)-07082025.png

Further, suppose you want to change the Graph to represent the Cost data by Months. Accordingly, it may be wise to decrease the number of Vertical Tic units in the Graph area and perhaps increase its Graph Height to better display this increased resolution. Increasing the Graph Height to 2.5, decreasing the Maximum value to $2,000,000.00 and decreasing the Step interval to $500,000.00, changes the reconstructed Graph area to look like this:

P80-7_3_25_1-80-(15)-07082025.png

As a note, OnePager retains these Custom mode settings if you change back to Auto mode. OnePager applies these previously Custom modes setting, now incorporated as Auto mode settings, into future renderings of the Panel and any of its Series in the current snapshot and future snapshots until changes in the imported data necessitates a change.

Tic Formatting Sub-Control Group

The Tic Formatting sub-control group provides you with management and editing over the properties of the Tic-mark lines in the Panel, the Tic-label multiplier, and the Tic-label font associated with the tic-labels. The Tic Formatting sub-control group is highlighted below:

P80-7_3_25_1-80-(23A)-02252026.png

Tic Formatting Sub-Control Group – Show tic marks/lines

The Show tic marks/lines control provides three options for constructing the Panel’s Tic-label lines associated with the Y-Axis. These three options are shown here:

P80-7_3_25_1-80-(23-2)-02182026.png

The default option is the In Graph & On Axis option which is used in all previous Graph Area illustrations in this article thus far as seen again here:

In Graph & On Y-Axis Show tic marks/lines Option

P80-7_3_25_1-80-(22-1)-02252026.png

The On Axis option removes the Tic-label lines in the Graph area and leaves only the bottom X-Axis line and the vertical separator line between the Y-Axis tic-label text and the Graph area as shown below:

On Y-Axis Show tic marks/lines Option

P80-7_3_25_1-80-(24-1)-02252026.png

The In Graph option only shows the tic-label lines in the Graph Area as shown below:

In Graph Show tic marks/lines Option

P80-7_3_25_1-80-(25-2)-02252026.png

Tic-label multiplier Sub-Group

The Tic-label multiplier dropdown provides options for shortening the Y-Axis tic-label text by providing multiplier options for the values shown in the Y-Axis for each Tic-label line segment. The default value is None and this option is used in all previous illustrations of Y-Axis Tic-label text. There are twenty-three (23) Tic-label multiplier options as shown below:

P80-7_3_25_1-80-(26-1)-02182026.png

As shown above in the extensive set of options in the Tic-label multiplier dropdown list you have a variety of ways to scale the quantities in the Y-Axis. When applied, the Tic-label multiplier is appended to the Panel’s Title and enclosed in parentheses.

Using the source plan and OnePager BlueGrass Chart used previously, we can construct an example where Y-Axis values are scaled to thousands by selecting “K” option in the Tic-label multiplier dropdown. When this is applied to the Chart the Y-Axis for the Graph Area looks like this:

P80-7_3_25_1-80-(27)-07082025.png

The Tic-label multiplier of “K”, meaning thousands, is appended to the Y-Axis Title text and enclosed in parentheses. This option also applies to Custom Y-Axis Title text as shown in the example below:

P80-7_3_25_1-80-(28)-07082025.png

Axis Title Control Group – Show multiplier in axis title

As seen in the illustration of the Y-Axis Properties – Panel #n form shown above, the Show multiplier in axis title checkbox is checked ON by default as illustrated below:

P80-7_3_25_1-80-(28A-1)-02182026.png

You do have the option to un-check the Show multiplier in axis title checkbox to OFF and when this is done, the Chart and Graph area look like this:

P80-7_3_25_1-80-(29)-07082025.png

Unchecking the Show multiplier in axis title checkbox to OFF does remove the parenthetical multiplier but the Y-Axis Tic-label Values are not changed. We recommend leaving the Show multiplier in axis title checkbox checked ON unless it is made clear elsewhere that the units on the Y-Axis are in thousands in this example.

Tic-label font Sub-Group

Clicking the Tic-label font dropdown arrow accesses the standard OnePager Font properties form as shown here:

P80-7_3_25_1-80-(30-1)-02182026.png

The standard OnePager Font properties form is used throughout the OnePager application to edit the font properties of text elements in titles, labels, and comments. For that reason the individual controls shown in the above illustration for the Font properties form are not discussed in detail here.

However, as an example, the Chart and Graph area used in this article is modified below to increase the font size of the Y-Axis Tic-label values and make them Bold:

P80-7_3_25_1-80-(31)-07082025.png

Increasing the font size for the Tic-label font may require increasing the Graph Height.

Tic-Line Style Sub-Control Group

The Tic-Line Style sub-control group provides you with management and editing over the properties of the horizontal lines in the Panel associated with the Tic-labels. These properties include color, line width, dash type, and line show options. The Tic-Line Style sub-control group is highlighted below:

P80-7_3_25_1-80-(17-1)-02182026.png

The controls shown above are described in more detail in the sub-sections below.

Tic-Line Style Sub-Control Group – Line color

Clicking the Tic-Line color dropdown arrow access the standard OnePager Color Chooser form as shown here:

P80-7_3_25_1-80-(18-1)-02182026.png

You can use the Color Chooser form to edit the color of the Tic-label lines in the Graph area for the Panel. Additionally, you can click the No fill checkbox to eliminate the horizontal lines in the Graph area. Finally, accessing the standard OnePager Color Chooser’s More colors button provides controls for the selection of Color Palettes and controls for creating your own colors.

For example, a Graph area with all the Tic-label lines changed to Red looks like this:

P80-7_3_25_1-80-(19)-07082025.png

For more information on managing colors in OnePager, please use the link in the table below:

Creating and Saving Color Palettes 25.0.1-80

Tic-Line Style Sub-Control Group – Line width

The Line width control provides the capability to increase or decrease the width of the Tic-label lines in the Graph area. The example below shows the Graph area’s Line width increased to 3.0:

P80-7_3_25_1-80-(20)-07082025.png

Tic-Line Style Sub-Control Group – Dash type

The Dash type control provides five (5) options in the dropdown list shown in the illustration below:

P80-7_3_25_1-80-(21-1)-02182026.png

The Dash type options shown above are the same options available many of the line features provided in OnePager such as Row borders, Swimlane borders, and Time-axis level borders. For example, using the Graph area illustration above, the Red Tic-label lines are changed from Solid to Dash-dot-dot with Line width of 2.0 in the illustration provided below:

P80-7_3_25_1-80-(22-1)-02252026.png

Tic-Label Number Format Sub-Control Group

The Tic-Label Number Format sub-control group has three (3) controls associated with formatting the numerical values in the Y-Axis for the Panels. These controls include: (1) Specifying the number of decimal places, (2) Selecting the 1000 separator symbol, and (3) Selecting the currency symbol/time interval symbol. The Tic-label number format sub-control group looks like this:

P80-7_3_25_1-80-(16-1)-02182026.png

Since this sub-control group is standard to OnePager, detail for this sub-control group can be found at the link in the table below for Text Colum Cell Format Options which apply here:

Numeric Type Text Column Cell Format Options 12.03.1-80

It is important to keep in mind that if you change the units for the Graph from, say, dollars ($) to hours (Hours) elsewhere in the Graphs/Data Cells tab, it is also necessary to change the Symbol setting in the Tic-Label Number Format sub-control group to the new Symbol.

Summary

The Y-Axis Properties – Panel #n form is associated with each of the three Graph Panels available in the Graphs & Data Cells tab of the Template Properties and Chart Properties form. It is accessed at the Graph/Data Cells tab’s Graph Elements control group. When accessed, the Y-Axis Properties – Panel #n form provides controls for defining and editing all components of a Graph’s typical Y-Axis. The settings used in the Y-Axis Properties – Panel #n form apply to all enabled Series in the Panel; therefore it is strongly recommended that all Series in the Panel use the same units. Finally, these settings are snapshot independent.

Creating & Editing Graphs & Data Cells in OnePager Charts 7.3.1-80	Creating & Editing Graphs In OnePager Charts 7.3.1.1-80
Creating & Editing Data Cells In OnePager Charts 7.3.1.3-80	Creating & Editing Pivoted Graphs in OnePager Charts 7.3.1.5-80
Combining Horizontally Pivoted Column Graphs in Panels and Series in OnePager Charts 7.3.1.6-80	Combining Vertically Pivoted Graphs in Panels and Series in OnePager Charts 7.3.1.9-80
Using Template Properties Forms to Create Graphs & Data Cells in OnePager Charts 7.3.5-80	Selecting Fields for Graphs & Data Cells in OnePager 7.3.7-80
Using the Skip Zeros Checkbox in Graphs 7.3.9-80	Using the Cumulative Checkbox in Graphs & Data Cells in OnePager 7.3.11-80
Selecting Interpolation Options for Graphs & Data Cells 7.3.13-80	Selecting Include Options for Graphs & Data Cells in OnePager 7.3.15-80
Using Pivot Properties Controls for Graphs 7.3.21-80	Using Combine Series Controls for Graphs in OnePager 7.3.23-80
Managing Graphs & Data Cells in OnePager 7.3.24-80	Managing Graph Elements for Graphs 7.3.25-80
Managing the Graph X-Axis in OnePager for Version 8.0 7.3.25.3	Managing the Graph Legend in OnePager Charts 7.3.25.5-80
Managing Graph Border Properties in OnePager 7.3.25.7-80	Managing Formatting for Data Cells 7.3.27-80
Managing Data Cell Label and Data Cell Formatting in OnePager 7.3.27.1-80	Managing Number Formats for Data Cells in OnePager 7.3.27.3-80
Snapshot-Dependent Graphs & Data Cells 7.3.29-80

Using Hover Boxes in the Chart & Graphs 13.1.1-80	Graphs & Data Cells Tab 21.12.3-80
Sharing via Other Applications (e.g., PowerPoint) 23.2.2.1-80	Using Presentation Mode with OnePager 23.6.1-80
Managing Templates (Portal) 24.0.1-80	Creating and Saving Color Palettes 25.0.1-80
Gallery of Graphs and Pivot Options 29.6.1-80

Conditional Formatting Rules for Horizontal & Vertical Pivoted Graphs 11.25.1-80	Using Hover Boxes in the Chart & Graphs 13.1.1-80
Graphs & Data Cells Tab 21.12.3-80	Using Presentation Mode with OnePager 23.6.1-80
Gallery of Graph Types and Series Styles 29.6.1-80

Managing the Graph Y-Axis in OnePager for Version 8.0