Microsoft Excel 
ITTraining@sgul.ac.uk Page 34 St. George’s Information Services 
QUICK CHARTING 
 
 
 
 
 
 
 
 
  
 
 
 
 
 
 
 
Try This Yourself: 
Same File Continue using the 
previous file with this 
exercise, or open the file 
E1355 Quick 
Analysis_2.xlsx... 
 
Click in cell A3, hold 
down , then click in 
cell E9 to select the 
range A3:E9 
 
Click on the Quick 
Analysis button, then 
click on the CHARTS tab 
to see a range of 
recommended chart 
types for this range 
 
Point to Clustered 
Column to see a Live 
Preview of the chart with 
the Week as the legend 
 
Point to Line, then 
Stacked Area, then 
Stacked Column to see 
how these options appear 
in Live Preview  
 
Point to the second 
Clustered Column to 
see a preview of the chart 
with the Days as the 
legend 
 
Click on the second 
Clustered Column to 
create a chart in the 
worksheet 
 
Charts aren’t all that difficult to create in Excel, 
especially with the Recommended Charts 
feature. However, deciding what style and type of 
chart can be daunting. Fortunately the Charts 
tools provide a way of seeing what the different 
charts will look like without having to first create the 
chart. 
3 
6 
For Your Reference… 
To use the Quick Charting tools: 
1. Select the range to be charted, then click on 
the Quick Analysis button  
2. Choose the desired option from the 
CHARTS tab 
Handy to Know… 
 When creating a chart you’ll need to ensure 
that the range you select includes the labels 
to be used on the chart.