Microsoft ® Office 2010 Simply Phần 6 pps

197

CHAPTER

12 EXCEL

Working with Charts

• You can click the Format tab

to find tools for formatting

various chart elements,

including chart text and

shapes.

• You can click the Layout tab

to find tools for controlling

how the chart elements are

positioned on the chart.

Can I select noncontiguous

data to include in a chart?

Yes. To select noncontiguous

cells and ranges, select the

first cell or range and then

press and hold while

selecting additional cells and

ranges.

How do I create an organizational chart in Excel?

You can add an organizational chart to track the

hierarchy of an organization or a process. When you

insert an organizational chart, Excel creates four

shapes to which you can add your own text; you can

add additional shapes and branches to the chart as

needed. To create an organizational chart, click the

Insert tab and then click the SmartArt button.

17_571941-ch12.indd 197 4/9/10 7:43 PM

198

3 1 2

3 Click and drag a handle to

resize the chart.

• A frame appears, representing

the chart as you resize it on the

worksheet.

4 Release the mouse button.

Excel resizes the chart.

Resize a Chart

1 Click an empty area of

the chart.

• Excel selects the chart and

surrounds it with handles.

2 Position the mouse pointer

over a handle.

The changes to .

Move and Resize Charts

After creating a chart, you may decide that it

would look better if it were a different size or

located elsewhere on the worksheet. For

example, you may want to reposition the chart

at the bottom of the worksheet or make the

chart larger so it is easier to read.

Moving or resizing a chart is like moving or

resizing any other type of Office object. When

you select a chart, handles appear around that

chart; you use these handles to make the chart

larger or smaller. Moving the chart is a matter

of selecting it and then dragging it to the

desired location.

Move and

Resize Charts

17_571941-ch12.indd 198 4/9/10 7:43 PM

199

Working with Charts

CHAPTER

12 EXCEL

2 3 1

Can I move a chart to its own

worksheet?

Yes. Select the chart, click the Design

tab, and click the Move Chart button.

The Move Chart dialog box opens;

click New Sheet and click OK. Excel

adds a new worksheet to the workbook

and places the chart in that worksheet.

How do I delete a chart that I no

longer want?

To remove an embedded chart, click

the chart and press Delete . If your

chart appears on its own worksheet,

you can delete the worksheet by right￾clicking its tab in the bottom left

corner of the screen, clicking Delete,

and clicking Delete again to confirm.

3 Click and drag the chart to a

new location on the worksheet.

• A frame appears, representing

the chart as you move it on

the worksheet.

4 Release the mouse button.

Excel moves the chart.

Move a Chart

1 Click an empty area of

the chart.

• Excel selects the chart and

surrounds it with handles.

2 Position the mouse pointer

over an empty area of the

chart.

The changes to .

17_571941-ch12.indd 199 4/9/10 7:43 PM

200

3 2 4 56 1

• Excel changes the chart to the

chart type that you selected.

1 Click an empty area of the

chart to select the chart.

2 Click the Design tab on the

Ribbon.

3 Click the Change Chart Type

button.

The Change Chart Type dialog

box appears.

4 Click a new chart type.

5 Click a chart style.

6 Click OK.

Change the Chart Type

Suppose you create a column chart but quickly

realize your data would be better presented in

a line chart. Fortunately, Excel makes it easy to

change the chart type in order to present your

data in a different way. Chart types include

column, line, pie, bar, area, scatter, stock,

surface, doughnut, bubble, and radar charts.

(Note that these charts are different from the

charts you can create using Excel’s SmartArt

tool.) You select a new chart type from the

Design tab on the Ribbon. To make this tab

available, you must click the chart to select it.

Change the

Chart Type

17_571941-ch12.indd 200 4/9/10 7:43 PM