Microsoft Excel 
ITTraining@sgul.ac.uk Page 49 St. George’s Information Services 
CHANGING THE CHART TYPE 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Try This Yourself: 
Same File Continue using the 
previous file with this 
exercise, or open the 
file E1317 
Charting_7.xlsx... 
 
Click on the Revenue 
Chart worksheet tab to 
see the chart, then click 
anywhere on the chart 
to select it and display 
the chart commands on 
the ribbon 
 
Click on the CHART 
TOOLS: DESIGN tab, 
then click on Change 
Chart Type in the Type 
group to display the 
Change Chart Type 
dialog box 
 
Click on 3-D Column, 
as shown 
 
Click on [OK] to apply 
the change to the chart 
 
Click on the Chart Data 
worksheet tab to return 
to the worksheet 
 
3 
When you create a chart, you may not always 
achieve the result that you desire. Fortunately, 
the process for changing a chart type is quite 
simple. You just need to have an understanding  
of what each chart type is designed for and to 
select the format that best suits your purpose. Just 
be aware that some chart types are designed for 
specialised applications. 
For Your Reference… 
To change the chart type: 
1. Ensure the chart or chart sheet is selected 
2. Click on the CHART TOOLS: DESIGN tab, 
then click on Change Chart Type in the 
Type group 
3. Click on the desired chart and click on [OK] 
Handy to Know… 
 You can use Change Chart Type in the 
Type group on the CHART TOOLS: 
DESIGN tab for either embedded charts or 
charts that have their own worksheet tabs. 
4