Chapter 9. Visualizing Data in Excel
In this chapter
Creating In-Cell Bar Charts with Data Bars 155
Creating Heat Maps with Color Scales 158
Using Stop if True to Improve All Conditional Formatting 164
Using the Top/Bottom Rules 166
Using the Highlight Cells Rules 168
Tweaking Rules with Advanced Formatting 174
Clearing Conditional Formats 186
Extending the Reach of Conditional Formats 187
Special Considerations for Tables 187
Special Considerations for Pivot Tables 188
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 2007 that make those screens full of numbers a little easier on the eyes.
Excel has had a ...
Get Special Edition Using Microsoft® Office Excel® 2007 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.
