O'Reilly logo

Excel® 2013 In Depth by Bill Jelen

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

31. Using Data Visualizations and Conditional Formatting

Many people feel their eyes glaze over when they encounter a screen full of numbers. Fortunately, Microsoft has added terrific new data-visualization features to Excel that make those screens full of numbers a little easier on the eyes.

As mentioned in Chapter 2, “Introducing Flash Fill and Quick Analysis,” the Quick Analysis icon that pops up on the grid offers six types of data visualizations when you select a range of contiguous data. This usually includes one example of an icon set, one data bar, one color scale, greater than, top 10%, and clear. The Quick Analysis feature is a great way for people to learn that these features exist, but it offers no flexibility in the options presented. ...

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