Sales Report

SALES FOR THE FIRST FOUR MONTHS OF 2007 WERE GENERALLY STABLE. ALTHOUGH BAKED GOODS & MIXES WERE SOMEWHAT FLAT BEVERAGES AND CANDY SHOWED IMPROVEMENT.

Figure 8-10. Title slide

Figure 8-11. Baked Goods & Mixes slide

Figure 8-11. Baked Goods & Mixes slide

Beverages fisuerages

Figure 8-12. Beverages slide

Candy

Candy

Figure 8-13. Candy slide

4. Return to the Excel window.

5. Click OK on the message box to finish running the code.

Very nice output, and not much more work than our Word document. If we want to include the text description on our chart slides, we can do that as well. For that, we need to do a few things differently, however.

In the previous example, we called on the Add method of the Slides collection using the following code:

Set m_oPptSlide = m_oPptShow.Slides.Add(i + 1, ppLayoutTitleOnly)

The layout type we used was ppLayoutTitleOnly, which gave us an empty slide with a Placeholder object to hold our title text. We used the remainder of the slide, which was empty, to place and size our chart. In our next example, we'll change the layout type to one that includes three placeholders: one for the title, one for the descriptive text, and one for the chart itself.

0 0

Post a comment