Page 40 - Chinmaya_C6_flipbook
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.


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

                                                                                   MARKS OBTAINED
                                                                 100
                                                                 90
                                                                 80
                                                                  70
                                                                 60
                                                                 50
                                                                  40
                                                                 30
                                                                  20
                                                                  10
                                4  Click on                       0
                                                                        Hindi      English  Mathematics  Computer Sc.
                                Line option.                             1          2          3          4
                                                                                     Ravi    Lakshay


                  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 click   2  Click on the Select Data
                                                           on the Chart Design tab.    command in the Data group.















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