Page 41 - Trackpad_V1_Book 6_Flipbook
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 of 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 (Version 1.0)-VI                                                                Charts in Excel 2010  39
   36   37   38   39   40   41   42   43   44   45   46