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.

Excel has had a weak conditional formatting feature since Excel 97. It was limited and tricky to use. Excel tipsters often showed the incredibly hard way to make conditional formatting just a bit more powerful.

Beginning with Excel 2007, Microsoft made data visualization easy to use. You are just a few clicks away from features that would have required a Ph.D. in legacy versions of Excel. The following are some of the possibilities in data visualization: ...

Get Microsoft Excel 2010 In Depth now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.