Page 38 - Chinmaya_C6_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 of
                  take place in a value through a specified period                                                                          parts to a whole.
                  of time. It is also known as a frequency polygon.





                      Who invented chart?



                                                                      AREA CHART                                                                    uiz               Which chart is used to display the data in the form of long rectangular

                                                                      An  area  chart displays the quantitative                                            Bee        rods?
                                                                      magnitude of the data graphically over the                                                      _______________________________________________________________
                                                                      course of time. It also depicts the relationship

                                                                      of parts to a whole by displaying the sum of
                                                                      plotted values. The area chart emphasises the                                   CREATING A CHART
                                                                      area between the line and the axis with the                           The first step in creating a chart is collecting the data which will be displayed in the chart. To create
                                                                      help of the colours, textures, hatchings, etc.                        a chart, follow the given steps:
                                                                      These charts are based on the features of the
                                                                      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
                  each value. The pie chart only displays one data                                                                                                                                                    4  Choose the
                  series in the form of comparative charts. It is                                                                              1  Select the data                                                     desired chart.
                  useful when you want to emphasise a significant                                                                             range.
                  element.



                                                                                                                                            The chart will appear on the worksheet.

                                                                       SCATTER CHART                                                                                                      CHART TITLE

                                                                       A scatter chart is also known as XY scatter                                                        100
                                                                       plot chart. It shows the correlations between                                                      80
                                                                                                                                                                          60
                                                                       the two sets of values. The X and Y axes are                                                       40

                                                                       used to represent the data plots on the chart.                                                     20
                                                                                                                                                                           0
                                                                                                                                                                                Hindi    English  Mathematics  Computer Sc.
                                                                                                                                                                                 1        2        3        4
                                                                                                                                                                                           Ravi  Lakshay



                   36   Premium Edition-VI                                                                                                                                                                                Charts in Excel 2016  37
   33   34   35   36   37   38   39   40   41   42   43