View source for Managing Formatting for Data Cells in OnePager for Version 8.0

==Introduction to Formatting for Data Cells==

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 '''Formatting '''control group of the '''Chart Properties''' form’s '''Graphs & Data Cells''' tab in '''Data Cells mode''' as shown below:

<center>[[File:P80-7_3_27-80-(1-1)-01202026.png]]</center>
<!--<center>P80-7_3_27-80-(1-1)-01202026.png</center>-->

The '''Formatting '''control group shown above for the '''Chart Properties''' form has three controls that are applied to the '''Panel'''.  The three controls include a '''Font properties''' control for the '''Data Cells Panel’s Cell Values'''; access to the '''Data Cells Formatting – Panel #n''' form; and the '''Number Format sub-control group''' for managing '''decimal places''', '''1000 separator options''', '''number symbol options''', and '''Multiplier options'''.  These controls are discussed in the sub-sections which follow.

==Formatting Control Group for Data Cells==

The three controls in the '''Formatting control group for Data Cells''' are briefly explained below.  

Detailed descriptions on the use of the controls are provided in the articles linked in the table below:

<center>
{| class="wikitable"
| [[Managing Data Cell Label and Data Cell Formatting in OnePager for Version 8.0 | Managing Data Cell Label and Data Cell Formatting in OnePager]] <!--7.3.27.1-80-->
|-
| [[Managing Number Formats for Data Cells in OnePager for Version 8.0 | Managing Number Formats for Data Cells in OnePager]] <!--7.3.27.3-80-->
|}
</center>

===Font Control===

Clicking the''' Font''' dropdown arrow accesses the '''Font Properties''' form. This form is standard in all OnePager editions.  The '''Font properties''' form is shown in the illustration below:

<center>[[File:P80-7_3_27-80-(2-1)-01202026.png]]</center>
<!--<center>P80-7_3_27-80-(2-1)-01202026.png</center>-->

The '''Font properties''' form support changes in the '''Data Cell Panel’s Cell Value font''' with respect to '''Font type''', '''Font color''', '''Font point size''', and the application of '''Bold''', ''Italics,'' and Underline '''label text'''.

As an example, the '''Font properties''' form shown above can be used to change the '''color''' of '''Data Cell Values''' to '''Red''' and '''BOLD''' as shown in the illustration below:

<center>[[File:P80-7_3_27-80-(2A-1)-01202026.png]]</center>
<!--<center>P80-7_3_27-80-(2A-1)-01202026.png</center>-->

The '''Font''' dropdown, in the above illustration, changes each '''Data Cell Value’s Font properties''' to '''BOLD''' and '''Red'''.

'''Font properties''' discussed above as well as all other properties of '''Data Cells''' are '''snapshot independent'''.

For more information on the '''Cell font '''dropdown, please see the article in link table below:

<center>
{| class="wikitable"
| [[Managing Data Cell Label and Data Cell Formatting in OnePager for Version 8.0 | Managing Data Cell Label and Data Cell Formatting in OnePager]] <!--7.3.27.1-80-->
|}
</center>

===Data Cell Formatting Controls===

Clicking the '''Data Cell Formatting '''button accesses the '''Data Cell Formatting – Panel #1''' form shown below.  Each '''Data Cell mode Panel''' has its own individual '''Data Cell Formatting – Panel #n''' form supporting the '''active Panel'''.  Accordingly, you have the capability to create up to three differently configured '''Data Cells''' in the '''Graph area''' when all three '''Panels''' are '''enabled''' in '''Data Cell mode''' and appropriately configured.  The '''Data Cell Formatting – Panel #1''' form is shown below:

<center>[[File:P80-7_3_27-80-(3-1)-01202026.png]]</center>
<!--<center>P80-7_3_27-80-(3-1)-01202026.png</center>-->

The '''Data Cell Formatting –Panel #n''' form shown above has three control groups.  The first is for '''creating''' and '''editing '''a '''Custom Title for the Data Cell Panel''' and the controls for formatting the '''Custom title''' in terms of '''text''', '''font properties''', '''alignment''', '''rotation''', and '''background color'''.  

The second or '''Data Format''' control group has controls for managing the '''properties of the data in each of the data cells '''to include their '''font properties''', '''alignment''', and '''rotation'''.  

The third or '''Cell Format''' control group has controls for managing the '''Data Cells Borders''' in terms of '''color''', '''width''', and '''line style''' for '''Top''' and '''Bottom borders''' only.  Additionally, the third control group has two '''color controls''' for managing the '''background color''' of '''Data Cells '''in the''' Panel'''.

As a '''note''', the '''Vertical Borders''' for '''Data Cells''' as with '''Graph mode Panels''' is provided by the '''Time-Axis Vertical Border''' controls.

For more information on the '''Data Cell Formatting – Panel #n''' form, please see the article in link table below:

<center>
{| class="wikitable"
| [[Managing Data Cell Label and Data Cell Formatting in OnePager for Version 8.0 | Managing Data Cell Label and Data Cell Formatting in OnePager]] <!--7.3.27.1-80-->
|-
| [[Changing the Time Axis Borders for OnePager for Version 8.0 | Changing the Time Axis Borders]] <!--22.1.7-80-->
|}
</center>

===Number Format Controls===

The '''Number Format''' sub-control group has four (4) controls for setting the '''Number of decimal places''' for the '''numeric data''', establishing the '''Symbol''' for the '''separation of digits''' between '''thousands''' ('''1,000'''), specifying the '''Symbol '''to be used for '''currency''' or '''time periods''', and provides the control for '''selecting''' a '''Multiplier text''' and '''Factor''' for the '''Data Cell Label''' and corresponding '''Data Cell Values'''.  The '''Number Format''' sub-control group is shown in the illustration below:

<center>[[File:P80-7_3_27-80-(4-1)-01202026.png]]</center>
<!--<center>P80-7_3_27-80-(4-1)-01202026.png</center>-->

====Number Format – Decimal places Example====

The '''Number Format''' sub-control group provides '''editing''' controls for establishing the '''Number of decimal places''' for '''Data Cell Values''', options for '''inserting separators between groups of three digits in lager Data Cell Values''', specifying options for '''Currency symbols''' and '''Time period tags''' (e.g., '''Hrs''' and '''Days'''), and for selecting '''Multiplier options''' as illustrated below:

<center>[[File:P80-7_3_27-80-(5-1)-01202026.png]]</center>
<!--<center>P80-7_3_27-80-(5-1)-01202026.png</center>-->

====Number Format – 1000 Separator Options Example====

The '''1000 separator''' dropdown has three options: '''Comma''', '''Period''', and '''None''' where the '''Comma''' is the '''default selection''' as shown below:

<center>[[File:P80-7_3_27-80-(6-1)-01202026.png]]</center>
<!--<center>P80-7_3_27-80-(6-1)-01202026.png</center>-->

The '''1000 separator of Comma''' is used in the '''Chart''' with '''Graph area Data Cells''' shown in a previous illustration above.

====Number Format – Symbol Options Example====

The '''Symbol''' dropdown has nine (9) options available with one (1) for '''Percentage''', five (5) for '''Currencies''', and two (2) for '''Time Periods''' as shown in the illustration here: 

<center>[[File:P80-7_3_27-80-(7-1)-01202026.png]]</center>
<!--<center>P80-7_3_27-80-(7-1)-01202026.png</center>-->

The '''Symbol $''' is used in the '''Chart''' with '''Graph area Data Cells''' shown in a previous illustration above.

====Number Format – Multiplier====

The '''Multiplier '''is provided so that the '''Data Cell Label''' and '''Data Cell Values''' can show a '''text''' that specifies the value to be '''multiplied''' by to get the '''displayed Data Cell Value''' in each '''Data Cell'''.  This is illustrated below for thousands where the '''multiplier''' is '''“K”:'''

<center>[[File:P80-7_3_27-80-(8-1)-01202026.png]]</center>
<!--<center>P80-7_3_27-80-(8-1)-01202026.png</center>-->

When the '''Multiplier selected''' above is '''applied''' to the '''Panel’s Data Cells''', the '''Multiplier''' is shown in the '''Data Cell Label '''and the '''Data Cell Values''' are '''scaled '''by a '''Factor '''of '''one-thousand''' as shown below:

<center>[[File:P80-7_3_27-80-(9-1)-01202026.png]]</center>
<!--<center>P80-7_3_27-80-(9-1)-01202026.png</center>-->

==Summary==

This article describes the controls available on the on the '''Chart Properties''' form’s '''Graphs & Data Cells''' tab when the '''selected Panel '''is in '''Data Cells mode'''.  There are three '''Panels''' available for '''Data Cells mode''', labeled '''Panel #1''', '''Panel #2''', and '''Panel #3'''.  Each '''Panel '''has the capability to support one '''time-series set of Data Cells''' per '''Panel'''.  In '''Data Cells mode''', the '''Graphs & Data Cells''' tab has all the controls necessary for creating '''Data Cells''' in the '''Chart''' either '''above '''the''' Chart area''' or '''below '''the''' Chart area'''.  The controls provided in the '''Graphs & Data Cells''' tab in '''Data Cells mode''' provide capabilities to a '''select source plan fields''', configure '''imported source plan data''' for the desired '''Data Cells''' representation and '''format''' the display of the '''Data Cell’s values''' as desired.

==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===

{| class="wikitable"
| [https://www.onepager.com/support/whats-new/cost-and-work-graphs.html Cost and Work Graphs]
| [https://www.onepager.com/support/whats-new/data-cells.html Data Cells]
| [https://www.onepager.com/support/whats-new/pivoted-graphs.html Pivoted Graphs]
|}

===Links to Introductory Graphs & Data Cells Articles===

{| class="wikitable"
| [[Getting Started with Version 8.0 (Portal) | Getting Started (Portal)]] <!--3.0.0-80-->
| [[Using Graphs & Data Cells in OnePager Version 8.0 | Using Graphs & Data Cells in OnePager]] <!--4.0.1.17-80-->
|}

===Links to Detailed Graphs & Data Cell Articles===

{| class="wikitable"
| [[Creating & Editing Graphs & Data Cells in OnePager Charts for Version 8.0 | Creating & Editing Graphs & Data Cells in OnePager Charts]] <!--7.3.1-80-->
| [[Creating & Editing Graphs In OnePager Charts for Version 8.0 | Creating & Editing Graphs In OnePager Charts]] <!--7.3.1.1-80-->
|-
| [[Creating & Editing Data Cells In OnePager Charts for Version 8.0 | Creating & Editing Data Cells In OnePager Charts]] <!--7.3.1.3-80-->
| [[Creating & Editing Pivoted Graphs in OnePager Charts for Version 8.0 | Creating & Editing Pivoted Graphs in OnePager Charts]] <!--7.3.1.5-80-->
|-
| [[Combining Horizontally Pivoted Column Graphs in Panels and Series in OnePager Charts for Version 8.0 | 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 for Version 8.0 | Combining Vertically Pivoted Graphs in Panels and Series in OnePager Charts]] <!--7.3.1.9-80-->
|-
| [[Managing Panels and Series for Graphs & Data Cells in OnePager Charts for Version 8.0 | Managing Panels and Series for Graphs & Data Cells in OnePager Charts]] <!--7.3.3-80-->
| [[Using Template Properties Forms to Create Graphs & Data Cells in OnePager Charts for Version 8.0| Using Template Properties Forms to Create Graphs & Data Cells in OnePager Charts]] <!--7.3.5-80-->
|-
| [[Selecting Fields for Graphs & Data Cells in OnePager for Version 8.0 | Selecting Fields for Graphs & Data Cells in OnePager]] <!--7.3.7-80-->
| [[Using the Skip Zeros Checkbox in Graphs & Data Cells in OnePager for Version 8.0 | Using the Skip Zeros Checkbox in Graphs & Data Cells]] <!--7.3.9-80-->
|-
| [[Using the Cumulative Checkbox in Graphs & Data Cells in OnePager for Version 8.0 | Using the Cumulative Checkbox in Graphs & Data Cells in OnePager]] <!--7.3.11-80-->
| [[Selecting Interpolation Options for Graphs & Data Cells in OnePager for Version 8.0 | Selecting Interpolation Options for Graphs & Data Cells]] <!--7.3.13-80-->
|-
| [[Selecting Include Options for Graphs & Data Cells in OnePager for Version 8.0 | Selecting Include Options for Graphs & Data Cells in OnePager]] <!--7.3.15-80-->
| [[Selecting Graph Type Options for Graphs in OnePager for Version 8.0| Selecting Graph Type Options for Graphs in OnePager]] <!--7.3.17-80-->
|-
| [[Selecting Series Style Options for Graphs in OnePager for Version 8.0 | Selecting Series Style Options for Graphs in OnePager]] <!--7.3.19-80-->
| [[Using Pivot Properties Controls for Graphs in OnePager for Version 8.0 | Using Pivot Properties Controls for Graphs]] <!--7.3.21-80-->
|-
| [[Using Combine Series Controls for Graphs in OnePager for Version 8.0 | Using Combine Series Controls for Graphs in OnePager]] <!--7.3.23-80-->
| [[Managing Graph Elements for Graphs in OnePager for Version 8.0 | Managing Graph Elements for Graphs]] <!--7.3.25-80-->
|-
| [[Managing the Graph Y-Axis in OnePager for Version 8.0 | Managing the Graph Y-Axis in OnePager]] <!--7.3.25.1-80-->
| [[Managing the Graph X-Axis in OnePager for Version 8.0 | Managing the Graph X-Axis in OnePager]] <!--7.3.25.3-80-->
|-
| [[Managing the Graph Legend in OnePager Charts for Version 8.0 | Managing the Graph Legend in OnePager Charts]] <!--7.3.25.5-80-->
| [[Managing Graph Border Properties in OnePager for Version 8.0 | Managing Graph Border Properties in OnePager]] <!--7.3.25.7-80-->
|-
| [[Managing Data Cell Label and Data Cell Formatting in OnePager for Version 8.0 | Managing Data Cell Label and Data Cell Formatting in OnePager]] <!--7.3.27.1-80-->
| [[Managing Number Formats for Data Cells in OnePager for Version 8.0 | Managing Number Formats for Data Cells in OnePager]] <!--7.3.27.3-80-->
|-
| [[Snapshot-Dependent Graphs & Data Cells in OnePager for Version 8.0 | Snapshot-Dependent Graphs & Data Cells]] <!--7.3.29-80-->
|}

===Links to Articles Supporting the Graphs & Data Cells Feature===

{| class="wikitable"
| [[Using Hover Boxes in the Chart & Graphs for Version 8.0 | Using Hover Boxes in the Chart & Graphs]] <!--13.1.1-80-->
| [[Graphs & Data Cells Tab for OnePager for Version 8.0 | Graphs & Data Cells Tab]] <!--21.12.3-80-->
|-
| [[Changing the Time Axis Borders for OnePager for Version 8.0 | Changing the Time Axis Borders]] <!--22.1.7-80-->
| [[Sharing via Other Applications (e.g., PowerPoint) for Version 8.0 | Sharing via Other Applications (e.g., PowerPoint)]] <!--23.2.2.1-80-->
|-
| [[Using Presentation Mode with OnePager for Version 8.0 | Using Presentation Mode with OnePager]] <!--23.6.1-80-->
| [[Gallery of Graphs and Pivot Options for Version 8.0 | Gallery of Graphs and Pivot Options]] <!--29.6.1-80-->
|}

(7.3.27-80)

[[Category:Version 8.0]]
[[Category:Charts]]
[[Category:Editing the Chart]]
[[Category:Template Properties Form]]
[[Category:Chart Properties Form]]
[[Category:Graphs/Data Cells]]
[[Category:Task/Milestone]]
[[Category:Ribbon]]
[[Category:Charts]]
[[Category:Tool Bar]]    
[[Category:Edit the Chart]]
[[Category:Edit the Graph Area]]
[[Category:Labels]]
[[Category:Swimlanes]]
[[Category:Text Columns]]
[[Category:Presentation Mode]]
[[Category:Snapshots]]
[[Category:OnePager Pro]]
[[Category:OnePager Express]]
[[Category:OnePager Bundle]]