Figure

The Sales Summary report and graph

Figure 14.10

The Top 5 Stores report

h'éJ Eil" View Insert Format

Tools Data Wildau Hdp

-9x1

U

..1 .! .J Ö ,|l il " ÎU

■B ; SiÉL» y

1 Tip Fire - f, =(C3i-B3J)/B3i

A I B

c 1

D

E

25

1 1

2S

Top 5 Stores in October

27

{} '1 ! i ! I'l 1 ! S1

2B

2002

2003

; l>et1ei.|woise}

29

Store #45 54

56

2.70%

3D

Store #148 51

S3

3.92%

31

Store #440 45

45

0.67%

32

Store #121 43

44

2.33%

33

Store #37 39

41

5.13%

34

Total®» 5 232

239

£93%

35

36

37

V

Ii 1

r M-\SheeH IReoorti/sheets / J<

II^MI_

>r

\ Ready

The code to implement the solution is shown in Listing 14.3. This listing uses early binding to establish a reference to PowerPoint, so if you try this yourself, be sure to set a reference to PowerPoint by selecting Tools ^ References from the VBE and placing a check mark next to the Microsoft PowerPoint 11.0 Object Library in the list of available references. If you're using a version of Microsoft Office other than Office 2003, you'll have a different version of PowerPoint such as Microsoft PowerPoint 10.0 Object Library.

0 0

Post a comment