Download Charts and Graphs-Using Powerpoint-Handout and more Exercises MS Microsoft PowerPoint skills in PDF only on Docsity!
16
Notice that the Series are the “ bars” in the chart. We see three Series in both the Excel spreadsheet and Power Point Chart. We have four “things” that people like with their peanut butter sandwiches, so we need to add another series. To add another Series to your spreadsheet carefully move your cursor over the small triangle in the lower right corner of highlighted area.
When you have your cursor over the triangle , you will see the two headed sizing arrow appear. When you see the arrow, click and hold down the left mouse button and slowly move your mouse to the right. As you do, you will see another Series appear (like the image below).
When you see this image – with Series 4 – take your finger off the mouse. We’re now ready to type in our peanut butter sandwich data to replace this data.
Click in cell B1 and replace Series 1 with Strawberry. Then do the same in the next three cells like we’ve done in the image on the right. Then type Best in Cell A.
As you enter the choices , you will see them appear in the PowerPoint slide on the left side of your screen.
But we still have a slight problem – Categories 2, 3 and 4 are still there. Let’s now remove them.
If you make a mistake, don’t forget the Undo Arrow!
17
We need to remove the rows with Categories 2, 3 and 4 – so that these bars will disappear from the PowerPoint chart – and we’ll only see our data.
This can be tricky, so don’t forget the Undo Arrow works in Excel just like it does in PowerPoint.
Move your cursor over the 3 (for the third row in the spreadsheet and you will see a black arrow appear. When you see the arrow , click and hold down the left mouse button and slowly move your mouse to the down to highlight rows 3, 4 and 5 (Categories 2, 3 & 4).
When you see the image ( on the right
- with rows 3, 4 & 5 highlighted) – take your finger off the mouse.
We’re now ready to delete these rows.
Move your cursor over the highlighted area and click the
RIGHT MOUSE BUTTON.
A drop-down menu (like the image on the left ) will appear. Move your mouse cursor over Delete and click
the LEFT mouse button.
The Excel spreadsheet data area should look like the image below.
19
To open your Excel spreadsheet ( again) , move your cursor over the Edit Data button in the Chart Tools Tab/Ribbon and click the Edit Data button.
Your Excel spreadsheet will open again on the right side of your screen.
When you have finished editing your Excel data, and your chart looks OK in PowerPoint, close the Excel spreadsheet and return to working with PowerPoint.
You may or may not desire to alter the appearance of your graph. It should be OK.
The Excel 2007 tutorial has additional detail on how to edit your Excel charts. These skills work the same in PowerPoint charts. You may refer to this tutorial as needed.
Slide 5 should look similar to the image on the right.
Save your work!
Slide 6
Click the down arrow in the lower right corner of the New Slide button once again.
We’ll use the Title and Content slide again. Click this slide.
Your Slide 6 screen should look like the top of Page 5.
20
Click the Click to Add title Text box at the top and type: Occasions for Eating PBJ’s
Click the • Click to add text Text box at the bottom and type:
School lunches (tap Enter)
Birthday parties (tap Enter)
Picnics (tap Enter)
Visits from persnickety grandchildren (tap Enter)
Late night snacks (tap Enter)
At the pool
Slide 6 should look similar to the image on the right.
Save your work!
Inserting Animated Images and Sounds into PowerPoint slides
You can insert images that move - called animated images - into your slides.. You can insert an animated Clip Art image on any slide. You’ll then want to move and resize the image for your slide. To insert an image, click the Insert Tab , and then click the Clip Art button in the Insert Ribbon (image on right).
When you click the Clip Art button a Clip Art Task Pane will open. This is the same Task Pane that you saw on Page 10 – however, we’re now going to use it in a new way , to find animated clip art and sounds on the internet. The right side of your Power Point screen should look like the image at the top of the next page. You can use this Task Pane as you did on Page 10, or the new way we’ll show you now.
22
We’ll “get into” sounds later, but now is a good time to learn about Motion Clips or Animated Clips. First we’ll do a search to see if we can find a cartoon motion clip that might fit into our Peanut Butter and Jelly theme. Look at the upper portion of the right side of the screen again. First, we’ll do a Clip Art search for cartoons and “hope” we get a motion/animated image.
Type -in cartoons in the area under Search text:
Then click -on the Go button.
A screen similar to the one on the left will appear on the right side of your PowerPoint screen – your screen will probably not look like this one – but you will be able to follow the sequence below.
Notice in the lower right corner of each image that there is either no “symbol ” or there is a “small yellow star.” The yellow star indicates that the clip art is animated. If you don’t see the star, this indicates that the image is not animated.
If none of your images have a star, not a problem. We’ll select an image you like, and later show you how to find animated images.
To “ see ” more about an image , move your cursor over the “right edge” of an image. You will see a light blue bar appear on the right edge of the image with a small down pointing arrow. Move your cursor over the arrow and click on it.
When you click the arrow , an image similar to the one at the top of the next page will appear.
23
From the image on the right you can see that the drop down menu furnishes you with a number of selections.
Move your cursor over Preview/Properties and click -on this selection.
This image gives specifics on the Clip Art picture you chose. If this is an animated image , you will see the animation moving in the left preview area.
This is a handy feature where you can check the many details of any image you select.
When you are finished looking at Preview/Properties , click the Close button in the lower right corner.
25
When you click the Accept button, you will be taken to the Microsoft Office Template and Media Control Screen below. This screen indicates that it would be wise to download this feature to enhance your work with the Clip Art selection and downloading. When you click the Continue Button ( arrow below ), you will see a screen that indicates that this process is occurring. Please read this screen and then click the Continue button.
It will take a few moments, but the Microsoft Office Online screen will open. Your screen will look similar to the image below. This image changes everyday with new Clip Art updates.
26
Look at this screen carefully - it contains “ all kinds of useful information .” On the left there are links to interesting Microsoft sites. In the middle , you’ll see the “ images of the day ” and current clip art collections – they change with the seasons. We frequently “get lost” on this page as we spend so much time clicking on these links. But for this tutorial, we’ll concentrate on clip art.
Look at the top left corner of the Microsoft Office Online screen. It will look like the image to the right. We’ll use this portion of the screen to search for animated clip art.
Notice - in the image above - there are a lot of arrows pointing to several areas. The top-right arrow points to a down pointing arrow , click -on this arrow. This causes a drop down menu screen ( lower right arrow ) to appear. It indicates that, when we do a search, we will find all of the images and sounds in the drop-down menu – All Media Types. Notice the left top arrow points to the “ white area ” – we typed cartoons in this area – so that we can search for cartoons again. Go ahead and type anything you would like to search for in this white area. For this tutorial we’ll stick with cartoons - for now.
Next, notice the Search button (top middle arrow). If you move your cursor over the Search button, a “ small pointy hand ” appears indicating that if you click the Search button , it will begin a search for the clip art choice you typed-in. After you enter what you want to search for, click the Search button.
A menu screen similar to the one below will appear.
28
A new choice with Office 2007 is the “pages” icon below the image. If you click this icon, it will place the image on your Clipboard for you to paste into your PowerPoint presentation, Word document, etc.
If you see any image that you desire to save on you computer, simply click-in
the small box below that image.
We clicked -in the small box below the Alarm Clock and two “things” happened immediately. As soon as the check mark appeared, the two images below changed a bit.
When the check mark appeared below the hat, the blue bar at the top of the screen indicated Download 1 item.
In the Selection Basket area, on the left side of the screen, it now indicates that there is one item to download.
As you select more images , these two areas will change to show the number of images you have selected.
As you move through the images , by clicking the Next button in the upper or lower right corners of the screen, you will notice that animated images “move.”
You’ll also see little speakers indicating sounds.
If you’re like us, we’ve clicked through about ten to fifteen screens, and we don’t see any of the image moving – indicating animation. So, let’s take care of this by “ refining ” our search.
29
We’ll continue to search for cartoons, but only “look” for animated clip art. To do this we’ll need to go back to the Search area in the upper left corner of the Microsoft Office Online Clip Art Screen( image on right). Click the down pointing arrow (see right arrow) to the right of All Media Types , a drop down menu will appear. Move your cursor over Animations and click on Animations.
Now click the Search button again to start a new clip art search.
You should now see only animated clip art. Every clip art image should be moving!
As indicated before, click in the small squares below any image that you would like to download. Click the Next arrows to see more clip art. As you click, the number of downloads will increase to reflect your choices.
We found a “dancing pig” and “feeding cow” that we liked. You’ll see that we put check marks below these two images so that we can download them.
You search until you find some Clip Art images you like. Check any of the boxes below the images you select.
We’ll now download the images you selected to your computer.
If you look at the top of your Microsoft Office Online Clip Art screen you will see the number of Clip Art images that you selected to download.
