Page 15 - TP-Play_V-2.0_Book-7
P. 15
CHARTS IN EXCEL
02
Your Aim
to learn about:
Creating a Chart Components of a Chart
Types of Charts in Excel 2016 Formatting a Chart
A chart is an effective way to display data in a pictorial form. It makes it easier to draw comparison
and analyse the growth, relationship and trends among the values in a table.
CREATING A CHART
To create a chart, follow the given steps:
Step 1 Select the range of cells, for example A1:C5, in
this case.
Step 2 Click on Column chart from Charts group under
Insert tab.
Data for the chart
Step 3 Select a 2-D Column Chart option from the drop-down list. A chart will be inserted in
the Excel sheet as shown:
Different types of charts 2-D Column chart
Charts in Excel 15

