Microsoft Excel 
ITTraining@sgul.ac.uk Page 51 St. George’s Information Services 
CHANGING THE CHART STYLE 
 
 
 
 
 
 
 
  
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Try This Yourself: 
Same File Continue using the 
previous file with this 
exercise, or open the 
file E1317 
Charting_9.xlsx... 
 
Click on the Revenue 
Chart worksheet tab to 
see the chart, then click 
anywhere on the chart 
to select it  
 
Click on the Chart 
Styles tool to the right 
of the chart to see a 
gallery of style options, 
as shown 
 
Scroll through the 
gallery and point to 
each style to see how 
your chart will look in 
Live Preview 
 
Scroll to and click on 
Style 9 
 
Click on the Chart 
Styles tool to the right 
of the chart to close the 
gallery 
 
Click on the Chart Data 
worksheet tab 
 
2 
The style of a chart refers to its colour scheme 
and overall appearance and can impact the 
clarity of the content of the chart.  Choosing a 
predefined chart style can save valuable time  
and effort. Excel also makes it easy to change 
chart styles if you decide the style you have chosen 
is not appropriate. 
 
 
For Your Reference… 
To change the chart style: 
1. Ensure the chart or chart sheet is selected 
2. Click on the Chart Styles tool to the right of 
the chart 
3. Click on the desired style 
Handy to Know… 
 Instead of using the Chart Styles tool to the 
right of the chart, you can also choose chart 
styles from the CHART TOOLS: DESIGN 
tab on the ribbon when a chart is selected.  
4