CHAPTER 5Charting in Excel 2007

Excel 2007 provides us with an easy-to-use chart-creation tool that quickly lets us create and modify or enhance the charts we build. Microsoft has rebuilt the UI to include tools that make chart type selection quick and easy. There are tools to allow us to quickly change, remove, or add chart elements like titles, legends, data labels, and more. And charts now look even better through the use of ClearType fonts that improve readability.

Getting Started

As with many of the previous features we've explored, we'll manually create a few different charts and record macros to take a look at some of the chart object properties and methods. Then we'll write our own code to create charts for our users.

  1. In the Download ...

Get Pro Excel 2007 VBA now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.