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

Chapter 8

Using Data Bars, Color Scales, Icon Sets, and Sparklines

In this chapter, we'll look at how you can use four graphical elements to give your worksheets more visual appeal and oomph without using full-scale charts. These four elements are data bars, color scales, icon sets, and sparklines. Each is a graphical element that appears in a single cell.

Data bars, color scales, and icon sets are part of Excel's conditional formatting, which you learned about in Chapter 4. Data bars are like single-cell bar charts that you use to compare the values in a range of cells. Color scales give you an easy way to adjust the background colors of cells to reflect their values—for example, red for poor performance and green for good performance. Icon ...

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