Page 40 - Trackpad_V1_Book 6_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 the 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.


                  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:


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


















                   38   Trackpad (Version 1.0)-VI                                                                                                                                                                         Charts in Excel 2010  39
   35   36   37   38   39   40   41   42   43   44   45