Microsoft Office Tutorials and References
In Depth Information
Excel 2013 incorporates some additional features that make it even easier to make your chart look exactly how you
want it. When you select a chart, you see three icons to the right of the chart that adjust various aspects of the chart.
I describe these new tools later in this chapter.
With one exception, every chart starts out as an embedded chart. The exception is when
you create a default chart by selecting the data and pressing F11. In that case, the chart is
created on a chart sheet.
When a chart is on a chart sheet, you view it by clicking its sheet tab. A chart sheet
contains a single chart. Chart sheets and worksheets can be interspersed in a workbook.
To move an embedded chart to a chart sheet, click the chart to select it and then choose
Chart Tools ➪ Design ➪ Location ➪ Move Chart. The Move Chart dialog box, shown in
Figure 18.3, appears. Select the New Sheet option and provide a name for the chart sheet
(or accept Excel’s default name). Click OK, the chart is moved, and the new chart sheet is
The Move Chart dialog box lets you move a chart to a chart sheet.
This operation also works in the opposite direction: You can select a chart on a chart sheet and relocate it to a
worksheet as an embedded chart. In the Move Chart dialog box, choose Object In, and then select the worksheet from the
When you place a chart on a chart sheet, the chart occupies the entire sheet. If you plan to
print a chart on a page by itself, using a chart sheet is often your better choice. If you have
many charts, you may want to put each one on a separate chart sheet to avoid cluttering