Page 39 - Trackpad_V5_Book 6
P. 39

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 Chart Design tab.












                                                         2  Click on the Change Chart Type command.


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













                              4  Click on Line with
                             Markers option.





                             5  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.












                                                                                          Charts in Excel 2021  37
   34   35   36   37   38   39   40   41   42   43   44