Page 36 - Chinmaya_C6_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    Gridlines


                                                            MARKS OBTAINED
                                Y-axis
                                   120

                                   100
                                    80
                   Plot Area                                                                                Chart 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.






                   34   Premium Edition-VI                                                                                                                                                                                Charts in Excel 2016  35
   31   32   33   34   35   36   37   38   39   40   41