Chapter 22. Creating and Editing Charts

In this chapter

A Revamped Charting Engine 666

Building an Excel Chart 666

Labeling a Chart’s Elements 682

Customizing Axes 688

Customizing a Chart’s Appearance 695

Working with PivotTable Charts 696

Creating Other Chart Types 697

Troubleshooting 698

Secrets of the Excel Masters: Leave the Top-Left Cell Blank 699

A Revamped Charting Engine

After fifteen years, the charting engine in Office 2007 has been completely rewritten. You will be able to create modern-looking charts in just a few mouse clicks. Tools for customizing the chart have been promoted to one of three new Charting Tools ribbon tabs.

The basic row-and-column worksheet grid is essential in helping you organize data and perform calculations, ...

Get Special Edition Using Microsoft Office 2007 now with O’Reilly online learning.

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