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 ...