Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 37 - logicode 2609 C6
P. 37

    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 a corner handle.

                                                                                        Advanced Features of Excel 2021   35

| 32 33 34 35 36 37 38 39 40 41 42 |