Chart Sheets

Select the data in cells A3:D7, as shown in Figure 8-1, and turn on the macro recorder. Right-click the sheet name tab, which contains the sheet name Sales, and select Insert. In the Insert dialog box, select Chart and click OK.

aj CtlSJtf.ilSITT

_ - V

A

e

C

D

E I

f a

1 1

Amalgamated Fruit Inc.

2

3

Mangoes

Jan

Feb

Mar

4

South

7777

7345

5354

5

North

1284

323B

4212

6

East

841

733

7858

7

West

5559

4311

5280

s

9 Bananas

Jan

Feb

Mar

LO :South

436

6539

8166

Ii North

4175

6362

4026

12 East

2566

9731

9735

13

West

3135

1312

661

14

15 Lyehees

Jan

Feb

Mar

16 South

7052

905

6428

17 North

3954

116

6013

18:East

9256

1434

6409

19 West

1GS4

8708

4412

20

21 Rambutan

Jan

Feb

Mar

22 :South

8068

8683

4976

23 North

7480

565

21

24 East

S190

7642

48 SB

25" West

1659

4444

5905

25

PJ

73130

72068

84354

H

r H sales Resoles

J3.

II ■ L

llll

Figure 8-1

Figure 8-2 shows the chart that's created. Don't turn off the recorder. You will record some adjustments to the chart.

From the Design tab of the Ribbon, click the Switch Row/Column button in the Data group and then the Quick Layout Button in the Chart Layouts group, and choose the top-left layout. A Chart title will appear that you can change to Mangoes. Click in the chart area to force the recorder to add the title change to its code, and turn off the recorder. The final chart should look like the chart in Figure 8-3.

Figure 8-2
Figure 8-3
0 0

Post a comment