Advanced PowerPoint:
Import Data
|
Advanced PowerPoint:
|
|
|
When you want to use data from an
existing
spreadsheet or document, you certainly don't want to have to type it in all
over again. Happily, you
can import the whole file by embedding
or linking it. These look alike on a slide,
but behave differently when you edit. Embed: Puts a static copy of the document inside your presentation
Link: Uses data directly from original document.
|
|
Project 2: PowerPoint Formatting Project 3: Advanced PowerPoint
|
|
Working with ObjectsYou import a file by inserting it as an object. The commands that you will have available to you will depend on what kind of object it is. Example: Excel Spreadsheet An Excel spreadsheet is called a Worksheet Object in the Edit menu and in the popup menu when you right click a worksheet object. Both of these menus open a submenu with three choices:
Start with: The Story So Far:
Import DataWhen you import data into PowerPoint, you are bringing in a whole file. For Excel files, you can choose which sheet is displayed on the slide.
Open ObjectOne of the advantages of importing your data as an object is that you can edit it in place with the original program. It's as easy as a double-click!
Edit ObjectWhile your object (the spreadsheet) is in this window, you can make changes. Since you did not Link this object back to the original file, your changes don't affect the original at all. You are free to play!
Select & Delete Placeholder Under ChartIs the original text placeholder is still here underneath the chart? It won't show when the slide is shown. But you can get rid of it. You will to use a new technique to get at it. The TAB key comes to the rescue! (Even if your text placeholder vanished, read through the steps to see how get to an object that is covered by another object.)
Alternate method- Change Stacking Order: Select the chart. From the Drawing bar, click the Draw button and select |. This puts the chart underneath the text box. Now you can select the text box and delete it. Add Text Box and FormatThe chart does not include the number of people who speak English. The bar for English would be so tall that the other bars would be impossible to read! You can add that information in a text box, as a kind of subtitle for the slide.
Evaluate
The font size may have changed to 18 for the numbers and languages. (It changes automatically when you resize the chart.) This is OK for viewing on a monitor. It may be too small to do much good on a projection screen in a large room.
~~ 1 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~ Last updated: 22 Jan 2008 |
,
Add a new slide to follow
How to handle a full Class disk
From the menu select 
Click on the radio button (circle) for 
Click
on OK. The sheet that was showing when the file was last saved is
displayed on the slide, centered. 
If
AutoLayout is on, the table will be sized smaller to fit in the Body
placeholder. Makes a bad situation even worse!
Click
on the right arrow in the navigation bar at the bottom of the
spreadsheet. There are two more sheets in this Excel file. 
Click
on the last tab, 
If
your chart is off the slide to the right, move your mouse pointer
to the inside edge of the border and drag left. The mouse
pointer does NOT change shape in this case.
Resize the chart by dragging the corner handles.
(The display may look like overlapping charts but there aren't really two of
them.)
Click
on the chart title to select it. 
Right
click on the number labels for the Y-axis.
Select
the Scale tab.
Select
the Font tab.
Chart frame
is off the slide at the bottom: 
On
the Formatting toolbar, change the Zoom to the next smaller
percentage. Can you see the handles at the bottom of the chart's frame? If
not, try smaller Zoom settings until you can see the handles.
Drag
the bottom center handle up until the chart frame is fully onto the
slide. The language labels may turn vertical, as in the illustration at the
right. 
Click
on the slide, outside of the chart area.
Click
on the words Click to add text to try to
select the placeholder. Did the placeholder's border turn to dots? Probably
not. As the illustration at the right shows, the circle
handles for the chart are showing.
Press
the TAB key on your keyboard. The Title text box is selected.
.
When you move your mouse over the slide, the pointer changes to
vertical bar with a small
crossbar near the bottom. 
Click
underneath the Title placeholder. A small text box appears with the cursor in
it, ready for your typing.
Align
Text Box: 
Is the chart working
well on this slide? What was the purpose for this presentation? Will this slide help
accomplish that purpose?
