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
   208   209   210   211   212   213   214   215   216   217   218