Learning the Essentials of Charts in Excel

In this section, we'll look at the two ways you can place charts in your workbooks, identify the different components of charts and examine what they show, and go over the many different types of charts that Excel offers you.

Understanding Embedded Charts and Chart Sheets

In Excel, you can either place a chart on a worksheet (for example, with its data) or on its own chart sheet:

  • Chart on a worksheet. Excel calls a chart on a worksheet an embedded chart —the chart object is embedded in the worksheet. Usually, the worksheet is the one that contains the chart's data, but you can embed a chart on a different worksheet if necessary. Create an embedded chart when you want to look at the chart alongside its ...

Get Office 2010 Made Simple now with O’Reilly online learning.

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