Gallery of Graphs and Pivot Options for Version 8.0
Gallery of Graphs and Pivot Options for Version 8.0 (P80-29.6.1-80-004212026.docx)
Introduction
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 other 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.
The purpose of this article is to put, in a single article, illustrations of each Graph type of Graph, Data Cell sets, Horizontally Pivoted Column Graphs, and Vertically Pivoted Graphs.
Simple Graph Types
Each of these Graph types is shown in the series of simple graph illustrations below:
Line Graph
-10282025.png)
Column Graph
-10282025.png)
Area Graph
-10282025.png)
Smooth Line Graph
-10282025.png)
Smooth Area Graph
-10282025.png)
Pivoted Graph Types
OnePager can also slice and dice or rather “Pivot” your graphs based on another source plan imported field like Resource Names or Phase Names. Pivoting a graph allows you to take a single series of data and split it out by different people assigned by team responsibility, or however you might want to slice and dice you data. As examples you might want to Pivot as follows:
- Work hours by Resource Name
- Budget Dollars by Assigned Team Name
- Cost Dollars by Assigned Team Name
OnePager can Pivot Graphs either Vertically or Horizontally for various Graph types as shown in the table below:
-04212025.png)
Vertically Pivoted Graph Types
Vertically Pivoting takes a standard Column Graph, for example, and applies different colors to the Column based on the imported data field used for Pivoting. Shown below is a Column Graph Pivoted by Resource Names. The Column Graph Pivot example is followed by examples of the other supported Vertically Pivoted Graph types.
Vertically Pivoted Column Graph
-10282025.png)
Vertically Pivoted Line Graph
-10282025.png)
Vertically Pivoted Smooth Area Graph
-10282025.png)
Vertically Pivoted Smooth Line Graph
-12162025.png)
Horizontally Pivoted Graph Types
Horizontal Pivoting is similar in concept to Vertically Pivoting wherein the values in the Graph are split up based on a second imported source plan field. As the name implies, Horizontally Pivoted Column Graphs are oriented left-to-right instead of top-to-bottom. OnePager supports only Horizontally Pivoted Column Graphs as illustrated below:
Horizontally Pivoted Column Graph Types
-10282025.png)
Related Links
Links to Detailed Articles on Creating and Editing Graphs & Data Cells
The articles listed in the tables below provide detailed information on how to create and edit graphs & data cells using the OnePager Chart Editor. Illustrations use OnePager Pro, but the features’ work the same in OnePager Express and OnePager Bundle.
Links to Feature Overviews
| Cost and Work Graphs | Data Cells | Pivoted Graphs |
Links to Introductory Graphs & Data Cells Articles
| Getting Started (Portal) 3.0.0-80 | Using Graphs & Data Cells in OnePager 4.0.1.17-80 |
Links to Detailed Graphs & Data Cell Articles
Links to Articles Supporting the Graphs & Data Cells Feature
| 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 |
(29.6.1-80)