VBA and Macros for Microsoft Excel

10Charts

IN THIS CHAPTER

Overview

Embedded Charts Versus ChartSheets

Creating a Chart with VBA

Using Object Variables to Streamline Code

The Anatomy of a Chart

Table of Chart Types

Details of Various Chart Types

Interactive Charts

Exporting Charts as Images

Drawing with X-Y Charts

Custom Charts with VBA

Next Steps

My guess is that you are probably a numbers person. Excel power users tend to be analytical types. We can look at a table of data and spot the spikes and trends. Unfortunately, our managers need some help. They say a picture is worth a thousand words. And for a picture of numbers, nothing works better than a well-conceived chart that draws data from an Excel table. Charts linked with tables of spreadsheet data have been in ...