Page 39 - Trackpad_V4.0_c6_Flpbook
P. 39

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  37
   34   35   36   37   38   39   40   41   42   43   44