Page 20 - TP_Pluse_V2.2_Class_7
P. 20

Gridlines
                                                                                                  Chart Title



                                                                                                  Plot Area




                                                                                                  Data Series
                               Y-axis
                               X-axis                                                             Data Labels


                                                                                                  Legend
                                                          Components of a Chart

                  •   Data Series: It is related to the set of values. It is represented by the bars or slices that represent the
                    data values.
                  •   Data Labels: It shows information about a data series or its individual data points.

                  •   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: It is a key which shows the meanings of 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, Doughnut, Scatter,
                  Surface and Radar.


                       Line Chart: It is used to show trends over a period
                  of time. It is  similar  to  plotting  a graph on the  graph
                  paper with its values on X and Y axes. It uses connecting
                  dots to display trends of a data over a given period of
                  time.




                                                                   Column Chart:  It is commonly 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  different data  items.  The categories  are

                                                              represented  on the horizontal axis and the values are
                                                              represented on the vertical axis.






                  18    Plus (Ver. 2.2)-VII
   15   16   17   18   19   20   21   22   23   24   25