Page 64 - ModularV1.1 _c7_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
   59   60   61   62   63   64   65   66   67   68   69