Microsoft Excel 2013 - Level 1 
© Watsonia Publishing Page 55 Chapter 10 - Practice Exercise 
PRACTICE EXERCISE 
Creating Charts 
 
 
Tasks: Completed: 
 Before starting this exercise you MUST have completed all of the topics in 
the chapter Creating Charts… 
 
 
Open the workbook called PE_Creating Charts.xlsx (it can be found in the 
same folder as the student files)  
 
Create a Clustered Column chart showing the sales of products for the 
months of January through to June  
 
Drag the chart down below the data and resize it so that it is the same 
width as the data, keeping the proportions as far as possible  
 
Change the chart type to 3-D Stacked Column and change the chart title 
to Sales 
The chart should appear as shown in sample A on the following page...  
 
 
Create a Pie in 3-D chart of the products and their totals then place it on its 
own chart sheet called Product Sales  
 
Change the Chart Title to Product Sales  
 
Change the layout to Layout 6  
The chart should appear as shown in sample B on the following page...  
 
 
Print the pie chart  
 
Use the Save As command to save the workbook as PE_Creating Charts 
(Completed).xlsx  
 
Files required for 
exercise: 
PE_Creating Charts.xlsx 
Files/work created by 
student: 
PE_Creating Charts (Completed).xlsx, 1 printed copy of the Product Sales 
chart 
Exercise Completed: 