Difference between revisions of "Conditional Formatting with Boolean Fields for OnePager Express for Version 7.0"
(Created page with "==Overview== The OnePager '''Conditional Formatting''' feature also supports Microsoft Excel '''Boolean''' fields which have only two values. That is, those fields whose valu...") |
|||
Line 12: | Line 12: | ||
2) In the Microsoft Excel '''source plan''' above, the field titled '''Team Available''' is actually a '''Boolean''' field. | 2) In the Microsoft Excel '''source plan''' above, the field titled '''Team Available''' is actually a '''Boolean''' field. | ||
− | 3) Creating a simple | + | 3) Creating a simple chart without '''Conditional Formatting rules''' produces something like this: |
<center>[[File:X61-11_6_1-61-(3)-10312017.png]]</center> | <center>[[File:X61-11_6_1-61-(3)-10312017.png]]</center> | ||
Line 22: | Line 22: | ||
<center>X61-11_6_1-61-(4)-10312017.png</center> | <center>X61-11_6_1-61-(4)-10312017.png</center> | ||
− | 5) When the '''Conditional Formatting Rules''' are in place and the | + | 5) When the '''Conditional Formatting Rules''' are in place and the chart is created it looks like this: |
<center>[[File:X61-11_6_1-61-(5)-10312017.png]]</center> | <center>[[File:X61-11_6_1-61-(5)-10312017.png]]</center> | ||
Line 36: | Line 36: | ||
<center>X61-11_6_1-61-(6)-10312017.png</center> | <center>X61-11_6_1-61-(6)-10312017.png</center> | ||
− | :b) You can now create another '''snapshot''' with OnePager the normal way and the | + | :b) You can now create another '''snapshot''' with OnePager the normal way and the chart now looks like this: |
<center>[[File:X61-11_6_1-61-(7)-10312017.png]]</center> | <center>[[File:X61-11_6_1-61-(7)-10312017.png]]</center> | ||
Line 46: | Line 46: | ||
[[Category:Version 7.0]] | [[Category:Version 7.0]] | ||
− | [[Category: | + | [[Category:Charts]] |
[[Category:Conditional Formatting]] | [[Category:Conditional Formatting]] | ||
[[Category:Templates]] | [[Category:Templates]] | ||
− | [[Category: | + | [[Category:Chart Properties Form]] |
− | [[Category:Editing | + | [[Category:Editing the Chart]] |
[[Category:Task/Milestone Editing]] | [[Category:Task/Milestone Editing]] | ||
[[Category:Labels]] | [[Category:Labels]] |
Revision as of 16:33, 25 February 2019
Overview
The OnePager Conditional Formatting feature also supports Microsoft Excel Boolean fields which have only two values. That is, those fields whose values can be resolved to either a TRUE or a FALSE. OnePager supports these four values (i.e., Yes, No, True, or False).
Example
1) As an example, suppose we have the Microsoft Excel source plan shown below which consists of three phases and resources consisting of four teams (Team 1, Team 2, Team 3, and Team 4).
2) In the Microsoft Excel source plan above, the field titled Team Available is actually a Boolean field.
3) Creating a simple chart without Conditional Formatting rules produces something like this:
4) Now suppose you want to represent any team that is Available regardless of the team name with a different task shape. This can be done by creating the following Conditional Formatting rule by accessing the Template through the second page of the OnePager Choices (OPC) form:
5) When the Conditional Formatting Rules are in place and the chart is created it looks like this:
6) OnePager applies the Conditional Formatting Rule created through the Conditional Formatting Rules form, adjusts the legend’s title, and provides a legend item to reflect the rule applied. You can manually change the legend title text and legend item text as required.
7) Should you later go back and change the Team Available field in the Microsoft Excel source plan, the next OnePager snapshot reflects the change by continuing to apply the rule.
- a) Suppose we want to put emphasis on Team 4 in the next snapshot. To do this it’s just a matter of changing the Team Available field in the Microsoft Excel source plan accordingly so it looks like this:
- b) You can now create another snapshot with OnePager the normal way and the chart now looks like this:
- c) Note that the tasks with the new shape are all associated with Team 2 and Team 4 and the legend is updated to reflect that Teams 2 and 4 are using the desired shape.
(11.6.1-70)