Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)

Chapter 16

Data visualizations and conditional formatting

In this chapter, you will:

• Use VBA methods and properties for data visualizations

• Add data bars to a range

• Add color scales to a range

• Add icon sets to a range

• Use visualization tricks

• Use other conditional formatting methods

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.

Note

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