Learning the Essentials of Charts in Excel
Before you start creating charts, let's look at the two ways you can place charts in your workbooks, go over what the different components of charts are called and what they show, and get an overview of the many different types of charts that Excel offers you.
Understanding Embedded Charts and Chart Sheets
In Excel, you can place a chart either 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 also 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 ...