Microsoft Excel 
ITTraining@sgul.ac.uk Page 48 St. George’s Information Services 
CREATING A CHART SHEET 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Charts can either be stored in a worksheet or in a 
separate sheet of their own known as a chart 
sheet. Chart sheets separate the chart from the 
underlying data and are useful especially if you  
are interested in printing the chart on its own page. 
Charts can be shifted back and forth between a 
worksheet and a chart sheet. 
Try This Yourself: 
Same 
File Continue using the 
previous file with this 
exercise, or open the file 
E1317 Charting_6.xlsx... 
 
Click on the chart to 
select it and display the 
CHART TOOLS:DESIGN 
and CHART TOOLS: 
FORMAT tabs  
 
Click on the CHART 
TOOLS: DESIGN tab, 
then click on Move Chart 
in the Location group to 
display the Move Chart 
dialog box 
 
Click on New Sheet, then 
type Revenue Chart  
This will become the 
sheet name for the 
chart… 
 
Click on [OK] to move the 
embedded chart to its 
own sheet 
 
Click on the Chart Data 
worksheet tab to see the 
data again 
Notice that the chart is no 
longer embedded on this 
worksheet 
 
2 
3 
4 
For Your Reference… 
To create a chart sheet: 
1. Click on the CHART TOOLS: DESIGN tab, 
then click on Move Chart in the Location 
group 
2. Click on New Sheet, type a name for the 
sheet and click on [OK] 
Handy to Know… 
 Keeping charts on their own sheets makes 
them easier to work with as they do not 
obstruct the data.