Microsoft Excel 
ITTraining@sgul.ac.uk Page 53 St. George’s Information Services 
EMBEDDING A CHART INTO A WORKSHEET 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Try This Yourself: 
Same File Continue using the 
previous file with this 
exercise, or open the 
file E1317 
Charting_11.xlsx... 
 
Click on the Revenue 
Chart worksheet tab 
 
Click on the CHART 
TOOLS: DESIGN tab, 
then click on the Move 
Chart tool in the 
Location group to 
display the Move Chart 
dialog box 
 
Click on Object in, then 
click on the drop arrow 
and click on Sheet 2 
 
Click on [OK] to move 
the chart to the 
worksheet 
 
Reposition the chart by 
dragging it to the top 
left of the sheet, then 
drag the resizing 
handles to resize it as 
shown 
 
Click on the Chart Data 
worksheet tab 
 
Charts can either be presented in their own 
sheets or they can be embedded into a 
worksheet that contains data. In fact, you can 
move a chart back and forth between its own  
sheet and a worksheet as often as you wish without 
impacting at all on the chart. Sometimes it is easier 
to work with a chart in its own sheet, but it may be 
necessary to print the chart with its data. 
3 
4 
For Your Reference… 
To embed a chart in a worksheet: 
1. Click on the CHART TOOLS: DESIGN tab, 
then click on Move Chart in the Location 
group 
2. Click on the drop arrow, select the sheet to 
embed it into, then click on [OK] 
5 
Handy to Know… 
 Embedding is normally only done when it is 
necessary to print the worksheet and the 
data together.