Microsoft Office Tutorials and References
In Depth Information
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.
By using the handles in the middle of the edges, you can resize the chart in one
direction. When you drag a handle on the left or right edge, the chart gets narrower or wider,
whereas when you drag the handles on the chart’s top and bottom edges, the chart gets
shorter or taller. You can drag a corner handle to change the chart’s height and width
at the same time; and you can hold down the Shift key as you drag the corner handle to
change 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 tool tab, in the Location
group, click Move Chart to open the Move Chart dialog box.
To move the chart to a new chart sheet, click New Sheet and enter the new sheet’s name in
the accompanying field. Clicking New Sheet creates a chart sheet that contains only your
chart. You can still resize the chart on that sheet, but when Excel creates the new chart
sheet, the chart takes up the full sheet.
To move the chart to an existing worksheet, click Object In and then, in the Object In list,
click the worksheet to which you want to move the chart.