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