Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 20 - 2626_South Point_C-7
P. 20

    Grid lines
                                                                                                      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 a 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.

                            Pie  Chart:   It is a circular chart divided into sectors

                      18    Premium Edition-VII

| 15 16 17 18 19 20 21 22 23 24 25 |