Supply chain manager Jon Jackson wants to indicate visually the relative values of annual inventory turnover levels of the nine regional distributors in his company’s supply chain (data shown in Figure G.8(b)).

APPROACH c A color scale in Excel’s Conditional Formatting changes the Fill color of every cell by using a gradation of two or three different colors. Darker means more extreme. This technique creates a heat map, which highlights the highest and lowest values