displaying data in a way that can be easily interpreted and analyzed—such as in a heat map—is essential. Excel lets you automatically color code figures to demonstrate their relationship with ...

Previously, heat maps only displayed sum data. Moving forward, “you can use heat maps to represent other aggregation types, like average,” under the updated Layer Options tab, wrote the Excel ...