Learn Office 2011 for Mac OS X

Chapter 14. Creating Powerful and Persuasive Charts

In this chapter, you'll learn how to create powerful charts that present your data clearly and persuasively. You'll also learn how to use sparklines, miniature charts that fit inside individual cells.

We'll start by going over the essentials of charts, such as the different ways you can place them in your workbooks, which components charts have, and which types of charts you can create. We'll then spend most of the chapter looking in detail at how you create a chart from your data, lay it out the way you want, and then give it the look it needs—everything from displaying or hiding components to formatting components for impact.

After that, I'll show you how to reuse your custom chart formatting ...