Excel 2016 VBA and Macros

16. Data Visualizations and Conditional Formatting

In This Chapter

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

Next Steps

Data visualization tools were introduced in Excel 2007 and improved in Excel 2010. Data visualizations appear on a drawing layer that can hold icon sets, data bars, color scales, and sparklines. Unlike with SmartArt graphics, Microsoft exposed the entire object model for the data visualization tools, so you can use VBA to add data visualizations to your reports.

See Chapter 17, “Dashboarding with Sparklines in Excel 2016,” for more information about sparklines. ...