Page 35 - Trackpad_V5_Book 6
P. 35

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                       Legend


               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.




                                                                                          Charts in Excel 2021  33
   30   31   32   33   34   35   36   37   38   39   40