Databases Reference
In-Depth Information
Building a heat chart with the Colormix wizard
In our previous example, we used the
Green()
,
LightBlue()
, and
LightRed()
color functions in conjunction with the
If
function to define the
Background color
attribute. Now, we will edit the attribute's expression to make use of the
Colormix
Wizard
option and see if we can come up with a better looking heat chart.
1.
Right-click on the pivot table we created above and select
Properties…
.
2.
Then, navigate to the
Expressions
tab and click on the expand icon to
reveal the attributes list. Double-click on the
Background Color
attribute
to open the
Edit Expression
window, in which we will replace the current
attribute's definition.
3.
Clear the expression's current content and, from the
File
menu, select
Colormix Wizard…
.
4.
The
Colormix Wizard
window will pop up. Click on
Next
in the first dialog,
which is just informative, and we'll enter
Step 1
, which is about defining the
Value Expression
.
5.
Enter the name of the main expression, in our case
Load Factor %
, enclosed
in square brackets. This expression will be used to determine the color and
intensity that should be set on each cell.