Page 41 - Trackpad_V2.1_Class6
P. 41

3  Change the data range in the Chart data range text box.






















                                                   4  Click on Ok button.

                 Now, the new data will be reflected in the charts as shown above.



                           MOVING AND RESIZING THE CHART


                 We can move and resize the chart to make it easier to read.
                 To move the chart, click on the blank area in the chart. Excel selects it automatically and surrounds

                 it with borders and handles. Now click and drag the chart to the desired new location.

















                                      Move a chart                       Resize a chart

                 To resize the chart, click on the blank area of the chart and position the mouse pointer over the
                 handle of the chart. The mouse pointer changes to a two-sided arrow [       ]. Now click and drag it
                 to resize.




                                          Subject: To resize a chart proportionally


                                          To resize the chart proportionally, select the chart then, press and hold
                                          the Shift key while dragging.








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