Microsoft Office Tutorials and References
In Depth Information
Chapter 16: Using VBA with Charts: Examples
Chapter 16
Using VBA with Charts:
Examples
IN THIS CHAPTER
Macros to activate and deactivate charts
Macros to determine whether a chart is selected
Macros to count and loop through all charts
Macros to delete charts and print charts
Macros to format and customize charts
Macros to apply data labels to a series
Macros to export charts as GIF files
Macros to identify and modify ranges used by a chart
Macros that are triggered by events
T HIS CHAPTER PRESENTS A WIDE variety of macros that manipulate charts in various
ways. These examples are intended to demonstrate how to work with the objects that
comprise a chart. You may be able to use some of these as written, but others may
require some modification to make them more useful to you.
All the examples in this chapter are available on the companion CD-ROM.
427
Search JabSto ::




Custom Search