Microsoft Office Tutorials and References
In Depth Information
After you create your chart, you can change its size to reflect whether the chart should
dominate its worksheet or take on a role as another informative element on the
worksheet. For example, Gary Schare, the chief executive officer of Consolidated Messenger,
could create a workbook that summarizes the performance of each of his company’s
business units. In that case, he would display the chart and data for each business unit
on the same worksheet, so he would want to make his charts small.
To resize a chart, select the chart, and then drag one of the handles on the chart’s
edges. Handles in the middle of the edges enable you to resize the chart in one
direction. Dragging a handle on the left or right edge enables you to make the chart narrower
or wider, whereas dragging the handles on the chart’s top and bottom edges enable you
to make the chart shorter or taller. Dragging a corner handle enables you to change the
chart’s height and width at the same time; holding down the Shift key as you drag the
corner handle changes the chart’s size without changing its proportions.
Just as you can control a chart’s size, you can also control its location. To move a chart
within a worksheet, drag the chart to the desired location. If you want to move the
chart to a new worksheet, click the chart and then, on the Design contextual tab, in
the Location group, click Move Chart to display the Move Chart dialog box.