Page 19 - TP_Prime_V2.2_Class7
P. 19

Chart Area: The area that includes all objects and elements in a chart.

                               Grid lines                                                       Chart Title



                                                                                                Plot Area



                                                                                                Data Series
                                  Y-axis                                                                                    ADVANCED FEATURES OF EXCEL
                                  X-axis                                                        Data Labels

                                                                                                Legend

                                                        Components of a Chart

                  Types of Charts in Excel

                 Excel provides a variety of chart formats such as                          LINE CHART
                 Bar,  Column,  Pie,  Line,  Area,  Doughnut,  Scatter,                                                   17

                 Surface, or Radar.
                 Most of the used charts in Excel are as follows:

                 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 over a period of time.

                              COLUMN CHART                   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 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 emphasis on a significant element.






                                   If Excel was a magical library, how would you sort books and filter books you had
                                   read?
   14   15   16   17   18   19   20   21   22   23   24