Basic HTML Version

|  | Table of Contents |  | View Full Version

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 |