Page 14 - 2617_JSSPS_C-6
P. 14

Gridlines                                                              Chart Title




                                                                                               Plot Area



                                                                                               Data Series
                             Y-axis
                                                                                               Data Labels
                             X-axis

                                                                                               Legend


                  Legend: It is a key that shows the meanings of the symbols and colours used in the chart.
                  Chart Area: It includes all the objects and elements of a chart.

              Types of Charts in Excel


              Excel provides a variety of different chart formats,
              such as Bar, Column, Pie, Line, Area, and Scatter.
              Line Chart: It is used to show trends over a period of
              time. It is similar to plotting a graph on graph paper
              with its values on the X and Y axes. 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 for
                                                                  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 put emphasis
              on a significant element.











                 12     Premium Edition-VI
   9   10   11   12   13   14   15   16   17   18   19