Page 64 - ModularV1.1 _c6_flipbook
P. 64
Area Chart: It is used to display the quantitative
magnitude of the data graphically. These charts are
based on the features of line charts. They basically
emphasise the area between the line and axis with
the help of colours, textures, pictures, etc.
Scatter Chart: Scatter charts are also known as XY
scatter plot charts. They show the correlations between
the two sets of values. The x and y axis are used to
represent the data plots on the chart.
CREATING A CHART
To create a chart, follow these steps:
Step 1 Select the range of cells, for example
A1:C5, in this case.
Step 2 Click on Column chart from the
Charts group under the Insert tab. Data for the chart
Charts group
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
62 Modular (Ver. 1.1)-VII

