Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 29 - ClickGPT V4.0 C-5
P. 29

    Gridlines
                                                                                                     Chart Title

                                                                                                     Plot Area

                                                                                                     Data Series
                                  Y-axis
                                  X-axis                                                             Data Labels

                                                                                                     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.

                                                                                 Charts, Formulas & Functions in Excel  27

| 24 25 26 27 28 29 30 31 32 33 34 |