Databases Reference
In-Depth Information
Initially, only the first dimension (
Carrier Name
) will be visible. Expand the other
two dimensions and drag them to the top to create the matrix. The heat map should
look like the following screenshot:
To accommodate the new chart into the
Analysis
sheet, enable the
Auto minimize
option in the
Passengers vs Mail
scatter chart. Then, resize and position the new
heat chart to occupy the same space as the scatter chart.
Resize and position their corresponding minimized icons as well, just as we did with
the
Reports
tab previously.
A solo exercise
It's time for a little challenge. We've defined the threshold with static limits (0.85
and 0.7). How can we make them variable, and how can we let the users define
their own limits?
The key is in the first section of this chapter.