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 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.