Page 40 - Trackpad_V2.1_Class6
P. 40

CHANGING CHART TYPE


                  You can change the type of an existing chart at any time. Perform the following steps to change the
                  chart type:

                                        1  Select the chart and click on Design tab.









                                                      2  Click on the Change Chart Type command in the Type group.


                              3  Click on desired chart type   5  Click on desired chart type
                             (here we choose Line).           (here we choose Line).

                                                                                       MARKS OBTAINED
                                                                     100
                                                                      90
                                                                      80
                                                                      70
                                                                      60
                                                                      50
                                                                      40
                                                                      30
                                                                      20
                                                                      10
                                     4  Select the desired            0
                                                                            Hindi      English  Mathematics  Computer Sc.
                                    type of Line chart.                      1          2           3          4
                                                                                          Ravi   Lakshay
                     6  Click on the OK button.

                  The chart will change to Line Chart as shown above.




                            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
                  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:


                                          1  Select  the chart and                   2  Click on the Select Data
                                          click on the Design tab.                   command in the Data group.
















                   38   Trackpad (V2.1)-VI                                                                                                                                                                                Charts in Excel 2016  39
   35   36   37   38   39   40   41   42   43   44   45