Microsoft Office Tutorials and References
In Depth Information
Removing the NightVision 16 from the pie chart
cha r t with the
are changed to
reference for the
data series values
the data series
5. Click the OK button to save your changes to the chart.
Note that when you removed the NightVision 16 from the data series, the percentages
in the pie chart changed as well to reflect a total sales figure based on only three models
rather than four.
Changing the Chart Location
Alicia has decided that she prefers the chart sheet to the embedded chart. She wants you
to move the embedded column chart on the Sales worksheet to a chart sheet. Rather than
re-creating the chart using the Chart Wizard, you will use the Location command on the
Chart menu. You will move the embedded chart to a chart sheet, which you will name
“Column Chart of Sales.”
To change the location of the embedded column chart:
1. Switch to the Sales worksheet, and then, if necessary, click the embedded column chart to
2. Click Chart on the menu bar, and then click Location . The Chart Location dialog box
opens. The dialog box is identical to the fourth dialog box in the Chart Wizard.
3. Click the As new sheet option button, type Column Chart of Sales as the name of the chart
sheet, and then click the OK button. The column chart moves into its own chart sheet.