Microsoft Office Tutorials and References
In Depth Information
Moving and Resizing a Chart
Basic Tasks with
Charts
Moving and Resizing a Chart
When you insert a chart into an existing worksheet, it becomes a floating object,
hovering above your worksheet. Depending on where Excel puts it, it may temporarily
obscure your data. The chart box doesn’t damage your data in any way, but it can end
up hiding your worksheet’s numbers and text (both onscreen and in your printouts).
You have to learn to grab hold of these floating boxes and place them where you
really want them. The process is pretty straightforward:
1. Clickthechartoncetoselectit.
You’ll notice that when you select a chart, Excel highlights the worksheet data
the chart uses, as shown in Figure 19-4. At the same time, three new tabs appear
in the ribbon, under the Chart Tools heading.
Figure 19-4:
You’ll know you’ve
selected the chart when
three new charting
tabs appear in the
ribbon under the
Chart Tools heading.
2. Hoveroverthechartborderuntilyourcursorchangestoafour-wayarrow.
Figure 19-5 shows what you’re looking for.
3. Clickanddragwithyourmousetomoveorresizethechart.
Using the four-way arrow, you can drag the chart anywhere on your worksheet,
releasing the mouse button when it’s in the right spot.
Using the two-way arrow, you can drag the border to make the chart larger or
smaller. Once you make a chart box larger, you may also want to resize the
individual components inside the chart to better use the available space. Page 516
tells you how to select chart elements and resize them.
Search JabSto ::




Custom Search