O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Color Scales

Color scales are a handy way of showing how the values in a set of cells compare to each other by setting the background color of each cell to represent its value. Excel lets you use either two-color scales or three-color scales. For example, to illustrate a range of temperatures, you could use a two-color scale with blue for the low temperatures and red for the high temperatures, or a three-color scale with blue representing an uncomfortably low temperature, green comfortable, and red uncomfortably warm. Figure 8–7 shows an example of this kind of daily temperature chart for the first half of a year.

images

Figure 8–7. You can ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required