Business Solutions VBA and Macros for Microsoft® Office Excel® 2007

Chapter 15. Data Visualizations and Conditional Formatting

IN THIS CHAPTER

Introduction to Data Visualizations	373
New VBA Methods and Properties for Data Visualizations	374
Adding Data Bars to a Range	375
Adding Color Scales to a Range	377
Adding Icon Sets to a Range	379
Using Visualization Tricks	381
Using Other Conditional Formatting Methods	386
Next Steps	392

Introduction to Data Visualizations

The data visualization tools in Excel 2007 represent one of its best new features. Microsoft added a new drawing layer that can hold icon sets, data bars, and color scales. Unlike SmartArt graphics, Microsoft exposed the entire object model for the data visualization ...