O'Reilly logo

Special Edition Using Microsoft® Office Excel® 2007 by Bill MrExcel Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

Combining Rules 185

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required