Page 36 - Trackpad_V1_Book 6_Flipbook
P. 36

CHARTS


                  Representing data in the pictorial form has always been considered a good medium to attract the
                  attention of readers. Charts in Excel are the pictorial representation of data and are also called
                  graphs. It is much simpler for us to observe patterns in the form of charts or graphs rather than
                  looking at textual data.



                             ADVANTAGES OF CHARTS

                  Charts are advantageous in the following ways:
                      A lot of information can be displayed in an easy-to-understand format.
                      Data can be presented in an attractive way to attract the attention of readers.

                       A chart is more informative and enables us to take instant decisions by analysing the data easily.



                             COMPONENTS OF A CHART


                  A chart can be understood without difficulty if it is clearly marked. There are many components
                  of a chart. They are discussed below:


                                         Y-axis                        Title           Data Series      Grid lines


                                                                 MARKS OBTAINED
                                  Y-axis
                                     120

                                     100
                                      80
                    Plot Area
                                      60

                                      40
                                      20

                                       0
                                             HIMANI      LAKSHAYA         RAVI        SHWETA        AADYA

                                                1            2             3             4             5
                                  X-axis
                                                          ENGLISH      HINDI      COMPUTER SC.


                                        X-axis                       Legends


                      Title: It describes the main purpose and content of the chart.
                      X-axis: It is the horizontal axis of the chart. It is also known as the category axis.





                   34   Trackpad (Version 1.0)-VI                                                                                                                                                                         Charts in Excel 2010  35
   31   32   33   34   35   36   37   38   39   40   41