Page 70 - TP_Modular_V2.1_Class7
P. 70

Data Series: Data series is related to the set of values. It is represented by the bars or slices

                     that represent the data values.
                       Data Labels: Data labels include data values, category name, series name, legend keys and
                     values from cells.
                       Gridlines: These can be either horizontal or vertical lines depending on the selected chart

                     type. It makes reading and understanding the values easier.
                      Legend: Legend is a key which 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 EXCEL 2016


                  Excel 2016 provides a variety  of different  chart  formats
                  such as Bar,  Column, Pie, Line,  Area,  Waterfall,  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. Line charts are mostly
                  used to depict Stock price trends, temperature trends, educational performance etc.
                  Column Chart

                  It is the most commonly used chart in Excel. 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. Column chart is used in cases like Sales comparison, survey
                  results, population distribution, educational performance etc.




















                                                              Column Chart
                  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 emphasis on a significant
                  element. Examples of pie charts are survey results, expense breakdown, geographical distribution
                  etc.



                   68       Modular (Ver. 2.1)-VII
   65   66   67   68   69   70   71   72   73   74   75