[ June 2000 ] [ July 2000 ] [ August 2000 ] [ Sept 2000 ] [ Oct 2000 ] [ Nov 2000 ] [ Dec 2000 ]
[ PPT VBA copy XL ]
|
6:30-7:00 pm
|
Introduction:
General Questions and Problems from the Audience |
|
7:00-8:00 pm
|
Excel and Powerpoint
 |
Excel vs. Graph - Why use Graph at all? |
|
Pasting Excel Charts into PowerPoint |
|
Embedding Excel Workbooks into PowerPoint |
|
|
8:00-8:10 pm
|
(Break) |
|
8:10-9:00 pm
|
|
Linking Excel and PowerPoint |
|
Advantages and Disadvantages of each
method |
|
VBA code to automatically copy an Excel
Chart to a new PPT slide. |
|
lotto9.zip XL and PPT
zipped files 950KB.
Contents:
|
Lotto9.xls Take the winning numbers from
the Texas State Lottery available from the internet. Use a Pivot
Table to count the number of times each number was picked within a time
period (Year or Year & Quarter). Then make a Stacked
Column Chart showing the number of picks by period by winning number.
This file also has an example of Animating a Chart.
|
|
IncStmt.xls A simple Financial Statement showing
Oil Production by Quarter by Division. Make a Stacked Column
Chart of the table
|
|
PasteXL4.ppt
A PowerPoint File with a VBA Macro to Copy an the Active XL Chart as a
picture, then add a slide to the PPT presentation, paste the XL Chart,
resize and position, then enter a title.
|
|
Prod.PPT A PowerPoint File showing the
IncStmt.xls with Pasted Tables, Charts, and Paste Link Tables and Charts. |
From Lotto.xls and PasteXL4.ppt.
Top of the Page
|
