
IN THIS CHAPTER
Using Excel VBA to Create
Charts
13
Introducing VBA
Version 5 of Excel introduced a powerful new
macro language called Visual Basic for Applications
(VBA). Every copy of Excel shipped since 1993 has
had a copy of the powerful VBA language hiding
behind the worksheets. VBA allows you to perform
steps that you normally perform in Excel, but to
perform them very quickly and flawlessly. A VBA
program can turn a process that used to take days
each month into a single button click and a minute
of processing time. If you have a lot of charts to
create, you can set up a macro to automatically pro-
duce a series of charts. This is appropriate if you ...