Charts

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 use from the early spreadsheet days and, over this period, spreadsheet charting has evolved tremendously. It has metamorphosed from a rudimentary graphical spreadsheet tool to a highly customizable resource capable of handling large amounts of data.

Overview

You probably know how to do all the following tasks in the Excel user interface, but this chapter covers the VBA needed to perform them:

■ Creating charts on a chart sheet or as an embedded chart on a worksheet.

■ Selecting from among the chart types available in Excel.

■ Changing the type of an existing chart.

■ Formatting, moving, and deleting a chart and chart elements.

■ Customizing a chart through the user interface.

As with earlier chapters, you might find that recording a bit of code reveals the methods and properties that are relevant. One of the most frustrating aspects of charts is that two different object models are used, depending on the chart's location.

0 0

Post a comment