Page 38 - Trackpad_V5_Book 6
P. 38

DOUGHNUT CHART

            A doughnut chart consists of more than one                                                                                          CHANGING CHART TYPE
            data  series. Each ring represents  one data                                                                              You can change the type of an existing chart at any time. Perform the following steps to change
            series in this chart. It displays the relationship                                                                        the chart type:
            of parts to a whole.
                                                                                                                                                                         1  Select the chart and click on Chart Design tab.










                                      Which chart is used to display the data in the form of long rectangular
                    uiz    Bee        rods?                                                                                                                                        2  Click on the Change Chart Type command.


                                      _______________________________________________________________
                                                                                                                                                3  Click on desired option (here we choose Line option).




                     CREATING A CHART

            The first step in creating a chart is collecting the data which will be displayed in the chart. To
            create a chart, follow the given steps:


                          2  Click on the Insert tab.                                                                                                   4  Click on Line with
                                                                                                                                                       Markers option.





                                                                                                                                                        5  Click on the OK button.
                                                                                  3  Choose the
                                                                                 desired chart from                                   The chart will change to Line Chart as shown above.
              1  Select the data                                                 the Charts group.
             range.
                                                                                                                                                 SETTING THE DATA RANGE


                                                                                                                                      The chart is created on the basis of data in the cell ranges and when the data is updated within
            The chart will appear on the worksheet.                                                                                   the range, it gets reflected in the chart immediately. However, when new rows and columns are

                                                                                                                                      added, they are not reflected in the charts. It can be done by following the given steps:
                                                       MARKS OBTAINED

                                         100
                                                                                                                                                                            1  Select  the chart and     2  Click on the Select Data
                                          80
                                                                                                                                                                           click on the Design tab.     command in the Data group.
                                          60
                                          40
                                          20
                                           0
                                                Hindi   English  Mathematics  Computer Sc.
                                                 1        2        3        4
                                                          Ravi  Lakshay



             36   Pro (Ver. 5.0)-VI
   33   34   35   36   37   38   39   40   41   42   43