VBA and Macros: Microsoft® Excel® 2010

15. Data Visualizations and Conditional Formatting

IN THIS CHAPTER

Introduction to Data Visualizations

VBA Methods and Properties for Data Visualizations

Adding Data Bars to a Range

Adding Color Scales to a Range

Adding Icon Sets to a Range

Using Visualization Tricks

Using Other Conditional Formatting Methods

Introduction to Data Visualizations

The data visualization tools were introduced in Excel 2007. However, Microsoft has made further improvements to these tools in Excel 2010.Data visualizations appear on a drawing layer that can hold icon sets, data bars, color scales, and now sparklines. In Excel 2010, you have new icon sets and new options for data bars. Unlike SmartArt graphics, Microsoft exposed the entire object model for the data ...