Page 38 - Trackpad_V1_Book 6_Flipbook
P. 38

LINE CHART                                                                                                                DOUGHNUT CHART
                  A line chart is a type of graph that displays                                                                             A doughnut chart consists of more than one

                  continuous  data  at  regular intervals. It is                                                                            data  series. Each ring represents  one data
                  generally used to highlight the changes that                                                                              series in this chart. It displays the relationship
                  take  place  in a value through  a specified                                                                              of parts to a whole.
                  period of time. It is also known as a frequency
                  polygon.





                      Who invented chart?
                                                                      AREA CHART                                                                                      Which chart is used to display the data in the form of long rectangular

                                                                      An  area chart displays  the  quantitative                                    uiz    Bee        rods?
                                                                      magnitude of the data graphically over the                                                      _______________________________________________________________
                                                                      time change. It also depicts the relationship
                                                                      of parts to a whole by displaying the sum of
                                                                      plotted values. The area chart emphasises the
                                                                      area between the line and the axis with the                                     CREATING A CHART

                                                                      help of the colours, textures, hatchings, etc.                        The first step in creating a chart is collecting the data which will be displayed in the chart. To
                                                                      These charts are based on the features of the                         create a chart, follow the given steps:
                                                                      line chart.
                                                                                                                                                      2  Click on the Insert tab.         3  Click on any chart type from the Charts group.
                  PIE CHART
                  A pie chart is shaped like a circle divided into
                  slices, each slice showing the relative size of                                                                                                                                              4  Choose the
                                                                                                                                               1  Select the data
                  each  value. The pie  chart  only  displays  one                                                                            range including the                                              desired chart.
                  data series in the form of comparative charts.                                                                              column headings
                  It is  useful when you  want  to  emphasise  a                                                                              and row labels.
                  significant element.





                                                                                                                                            The chart will appear on the worksheet.
                                                                       SCATTER CHART

                                                                       A scatter chart is also known as XY scatter
                                                                       plot chart. They show the correlations
                                                                       between the two sets of values. The X and Y
                                                                       axes are used to represent the data plots on
                                                                       the chart.








                   36   Trackpad (Version 1.0)-VI                                                                                                                                                                         Charts in Excel 2010  37
   33   34   35   36   37   38   39   40   41   42   43