A data visualization technique that uses color gradients to represent values within a grid or table.
Probeer het met AIA heat map applies conditional formatting to a range of cells, assigning colors based on the magnitude of the data. This allows users to instantly identify trends, outliers, and clusters within large datasets.
A sales manager uses a heat map on a monthly performance table to highlight high-performing regions in green and low-performing regions in red.
Select your data range, go to the Home tab, click Conditional Formatting, and select Color Scales.