Page 63 - ModularV1.1 _c6_flipbook
P. 63

Data Labels: Data labels include data values, category names, series names, legend keys and

                    values from cells.
                    Gridlines: These can be either horizontal or vertical lines depending on the selected chart
                    type. It makes it easier to read and understand the values.

                    Legend: Legend is a key that shows the meanings of symbols and colours used in the chart.

                    Chart Area: The area that includes all objects and elements in a chart.

                     TYPES OF CHARTS IN MS EXCEL

                 MS Excel provides a variety  of chart  formats such
                 as  Bar,  Column,  Pie,  Line,  Area,  Doughnut,  Scatter,
                 Surface, or Radar.

                 Line Chart: It is used to show trends over a period of

                 time. It is similar to plotting a graph on a graph paper
                 with its values on X and Y axis. It uses connecting dots
                 to display trends over a period of time.



                                                              Column Chart: It is usually used to display the data
                                                              in the form of vertical bars. It is used to show the
                                                              changes in data over a period of time or comparison

                                                              among the different data items. The categories are
                                                              represented on the horizontal axis and the values are
                                                              represented on the vertical axis.





                 Pie Chart:  It is a  circular  chart  divided into sectors

                 where  each sector shows the relative size  of each
                 value. It always shows only one data series. It is useful
                 when you want to emphasise on a significant element.




                                                              Bar  Chart: The bar  chart  displays the  data  in the
                                                              form of long rectangular rods also called bars. These

                                                              bars can be placed horizontally on the chart area. It
                                                              illustrates the comparisons amongst the individual
                                                              items. In this chart,  categories are  represented on
                                                              the vertical axis and values are represented on the
                                                              horizontal axis.




                                                                                                 Charts in Excel  61
   58   59   60   61   62   63   64   65   66   67   68