Microsoft Office Tutorials and References
In Depth Information
Chapter 10: Charming Charts and Gorgeous Graphics
Moving embedded charts to chart sheets
Although Excel automatically embeds all new charts on the same worksheet
as the data they graph (unless you create the chart by using my F11 trick),
you may find it easier to customize and work with it if you move the chart to
its own chart sheet in the workbook. To move an embedded chart to its own
chart sheet in the workbook, follow these steps:
1. Select the chart and then click the Move Chart button on the Design
tab under the Chart Tools contextual tab to open the Move Chart
2. Click the New Sheet button in the Move Chart dialog box.
3. (Optional) Rename the generic Chart1 sheet name in the
accompanying text box by entering a more descriptive name.
4. Click OK to close the Move Chart dialog box and open the new chart
sheet with your chart.
If, after customizing the chart on its own sheet, you decide you want the
finished chart to appear on the same worksheet as the data it represents, click
the Move Chart button on the Design tab again. This time, click the Object In
button and then select the name of the worksheet in its associated drop-down
list box before you click OK.
Customizing charts from the Design tab
You can use the command buttons on the Design tab of the Chart Tools
contextual tab to make all kinds of changes to your new chart. The Design tab
contains the following groups of buttons to use:
✓ Chart Layouts: Click the Add Chart Element button to modify
particular elements in the chart such as the titles, data labels, legend, and
so on (note that most of the chart element options on this drop-down
menu are duplicated on the chart elements palette that appears when
you click the Chart Elements button in the worksheet to the right of a
selected embedded chart). Click the Quick Layout button to select a new
layout for the selected chart.
✓ Chart Styles: Click the Change Colors button to display a pop-up palette
with different colorful and monochromatic color schemes that you can
apply to your chart. Highlight the various chart styles in the Chart Styles
gallery to preview and select a style for the current type of chart.