Page 19 - TP_Play_V2.1_class7
P. 19

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.



                                                                                              Charts in Excel     17
   14   15   16   17   18   19   20   21   22   23   24