December 2006
Beginner
1080 pages
30h 43m
English
Content preview from Special Edition Using Microsoft® Office Excel® 2007Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...