How to Apply Color Scales to Tables

Introduction

This article describes how to go from a standard table...

...to a table with color formatting that transitions from one color to another based on the cell value:

Requirements

A table.

Please note these steps require a Displayr license.

Method

1. Select your table.

2. Go to Data > RULES on the object inspector.

3. To apply the rule, select the Plus (+) > Color Scale.

4. Choose from one of the 2-Color Scale or 3-Color Scale gallery icons to automatically apply this setting to your table. Otherwise press Custom to change the default settings.

5. OPTIONAL: If you choose Custom, update the Statistic (if different from the default).

6. OPTIONAL: Set the Color Scale type using either a 2 or 3-Color Scale setting. Using a 2 or 3-Color Scale with Values setting allows the user to manually specify Minimum, Maximum and Midpoint (if 3-color scale) values.

7. OPTIONAL: Set colors for Minimum and Maximum, and Midpoint and Nets/Sums (if applicable).

8. OPTIONAL: Tick Include row NETs/SUMs and/or Include column NETs/SUMs.

9. Press OK.

10. OPTIONAL: To change the settings, right-click the rule under RULES in the object inspector > Edit.

See Also

How to Use Rules in Displayr