Page 213 - CA 165 ver 1.0 Class 9
P. 213
l Pie Chart: A pie chart represents the data PIE CHART: MARKS SECURED IN ENGLISH
or value of each item in proportion or
percentage to the consolidated or the sum
value of all items. Pie chart displays single 28%
type of data item and is beneficial when 40%
the user wants to emphasize value of a 32%
significant item. Pie charts help to compare
how each value relates proportionally to
the whole. Kavya Pooja Ankit
SCATTER CHART
100 l X-Y (Scatter) Chart: X-Y (Scatter) chart
90 displays the relationships among the
80
70 numeric values of several data series. This
60
50 chart shows uneven intervals or clusters of
40
30 data and is commonly used to represent
20
10 scientific data.
0
0 0.5 1 1.5 2 2.5 3 3.5
Kavya Pooja Ankit
AREA CHART
100
l Area Chart: An area chart is a version 90
80
of a line or column graph. It is useful to 70
60
emphasize on volume of changes of data. 50
40
Area charts have better visual impact than 30
20
a line chart. 10
0
Hindi Eng Math
Kavya Pooja Ankit
Making a Chart
Data can be easily displayed through charts in a spreadsheet package. Based on the same data, a user
can easily switch from one type of chart to another. The charts are always linked to the data they are
depicting. If you make any change in the data, it will be reflected in charts also.
To display data through a Chart:
Step 1: Select the data.
Step 2: Select the option ‘Chart’ from the ‘Insert’ menu.
Step 3: Select any type of chart from the list.
Step 4: Click on ‘Next’.
Data Analysis 211

