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. ...
Get Excel® 2013 In Depth now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
